query problems

Anon

i'm new to php, so if my mistake is puerile, i apologize.

when running a query on a mysql database i'm getting this error message: "
Warning: 0 is not a MySQL resultindex /usr/local/etc/httpd/htdocs/sa/groove.php3 on line 122"

the page itself can be viewed at http://www.factory201.com/sa/groove.php3 and the code can been found at http://www.factory201.com/sa/groove.txt

thanks very much

Anon

the rrro you got usally means that your SQL statement is not correct.

Try printing the sql statement just before you execute it, so you can see just what you are trying to send to the database server.

Also, insert some IF statements to check if your query was executed, and print the mysql error code if it was not.

Check the PHP manual for info on how to print the mysql error messages.

Anon

There is not supposed to be a comma between your $sort_field and $sort_sirection.

Ex "SELECT * FROM table ORDER BY usename ASC"

Hope it helps.