Færdiggjort

Sort MySQL Table with advanced options + Advanced Search code

**What I Need**

Part 1:

a) I need to output MySQL data in table format according to specifications by me and allow the viewer to sort the different headings by ASCENDING or DESCENDING (data in table be alphabetical, numerical, or both so to save coding you could set it to sort numbers first then alphabetically)

* All data from the table won't start with a non-alphabetical or numerical character (i.e. $ # % ^ &, etc) so the coding should be easy! If there is too much data (10+), numbers at the bottom shuold be displayed to take the viewer to another page.

b) I need to output MySQL data based on differing 'Category' titles.

- For example, the common key between some data in the MySQL are the 'Category' names. When I output a table in Category format, I need it to display all the data with that category. The category names cannot be hard coded because they can be dynamic.

- To illustrate,

*Table A*

**Category ProductName Price**

TV Sony 50" HDTV $499.99

TV Panasonic 20" TV $99.99

MP3 Apple iPod 80 Gig $299.99

The code should run through the MySQL table and output like this:

**TV**

Sony 50" HDTV for $499.99

Panasonic 20" TV for $99.99

**MP3**

Apple iPod 80 Gig for $299.99

Part 2:

a) I need an advanced search code. This code should search a particular MySQL table and outputting any matches it finds. The output will be identical to how the table in Part 1a should be. (so pretty much copy the code there) The only additional parameters are to limit the search.

- For example,

Price Under/Over(dropdown) $"text field" (user enters price)

Limit to 5, 10, 15 results per page

Sort by 'various headings'

Evner: Ingeniørarbejde, MySQL, PHP, Projekt Ledelse, Software Arkitektur, Software Testning, Web Hosting, Hjemmeside Management, Hjemmeside Testning

Se mere: sort sort sort, sort sort, advanced search results, 5 gig, project management titles, mysql dropdown, mp3 search, illustrate character, illustrate an easy, mysql mp3 search, mp3 search php, mp3 search php code, mysql sort field, mysql sort, mysql pretty, mysql dynamic search, mysql search table, data table viewer, php data viewer, mysql save data

Om arbejdsgiveren:
( 2 bedømmelser ) Toronto, Canada

Projekt ID: #3318615

Tildelt til:

brandoovw

See private message.

$2 USD in 14 dage
(1 bedømmelse)
0.0

9 freelancere byder i gennemsnit $7 på dette job

citiva

See private message.

$6.8 USD in 14 dage
(114 bedømmelser)
6.3
vw6977538vw

See private message.

$8.5 USD in 14 dage
(95 bedømmelser)
5.1
vw6809571vw

See private message.

$8.5 USD in 14 dage
(11 bedømmelser)
4.5
waterworker

See private message.

$8.5 USD in 14 dage
(15 bedømmelser)
4.4
vw7125788vw

See private message.

$3.4 USD in 14 dage
(7 bedømmelser)
1.4
floWon

See private message.

$8.5 USD in 14 dage
(5 bedømmelser)
1.0
richardja

See private message.

$4.25 USD in 14 dage
(0 bedømmelser)
0.0
vw7066289vw

See private message.

$8.5 USD in 14 dage
(0 bedømmelser)
0.0