[RESOLVED] Error with mysql query

[lgefrank]

Hi, I'm trying to get a simple search query of a table of news articles working. But it keeps giving me an error for the "mysql_fetch_array( )" on line 34. I can't see what I've done wrong.

#create the query 
$sql = "
SELECT text
FROM article
WHERE text like '%$search%' 
order by date desc";

#execute the query
$rs = mysql_query( $sql, $conn );

#loop through all records
while ( $row = mysql_fetch_array( $rs ) ) 
{
echo( $row["text"]. "<br>");
}

This is the section of the code that doesn't work. I've most likely made a silly mistake, but I can't spot my error. Please help me out here please. :o

[ahundiak]

date is a reserved word in mysql though oddly enough it does allow you to create columns with the name. So either change the name to something else (datex) or use back ticks around it date. Check the mysql manual for other reserved words.

And you might lookup the use of mysql_error() in the php manual.

[lgefrank]

Thanks It works now. Wow this forum is great! thanks again.

[bradgrafelman]

Don't forget to mark this thread resolved.

[lgefrank]

sorry. Thanks for telling me about the resolved link. Please tell me if I am doing any thing wrong