0 is not a MySQL result index ...

I know i have seen this somewhere else but i cant recall it right now. And now i have that problem, can someone please help?

Thanx,
--Tyrnt
http://www.blizzardnexus.com

hi,
There is a problem in your select(query) statement.but still it will display the content and show's the error,this because u r passing orderby clause as parameter while executing it the orderby is null that's the reason i feel.

now the error is on a different script. i will paste the actual code

$result = mysql_query( "select * from friends where $type is $search");


// fetch the rows one at atime, and then echo the data to the page
while ($row = mysql_fetch_row($result)) {

os there an error here? the $type and $search are variables from a form that is also on this script.

Thank you,
--Tyrnt
http://www.blizzardnexus.com
ICQ UIN: 1802676

After your mysql_query line you can put a echo mysql_error() line to print the mysql error to the browser. That should help you troubleshoot your query.

A couple things to make sure of however, is $type always going to be a correct column name, and perhaps you should put apostrophe's around $search.

i did finally figure out what the problem, it was the syntax or somethin, kinda forgot exactly what i did but it works now and i even made another script and i made it so i can delete entries from my web browser, its really really kewl =) thank you for your help.


--Tyrnt
http://www.blizzardnexus.com
ICQ UIN: 1802676

I have found the quickest way to debug these errors is to print the query string to the browser and cut and paste iy into a MySQL session (i telnet into the linux web server for this).

This way you can fine tune the syntax.