acer88

our hosting is through godaddy and they are using version 4.0.24

I get this error when trying to do a mysql query with select. Here is the error I get: SELECT Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select barcode from itemdescription) order by listing.date DESC and here is the code that I believe is generating the error: //$records = mysql_query( "SELECT *  FROM listing where title like '%$title%' and barcode in (select barcode from itemdescription) order by date DESC") $records = mysql_query( "SELECT listing.recordid,listing.barcode,listing.itemnumber,listing.title,listing.inputdate,itemdescription.category, category.categoryname FROM listing left join itemdescription on listing.barcode=itemdescription.barcode left join category on itemdescription.category=category.categoryid where listing.title like '%$title%'   and listing.barcode in (select barcode from itemdescription) order by listing.date DESC") or die("SELECT Error: ".mysql_error()); $num_rows = mysql_num_rows($records); what is wrong with my syntax?? Sometimes it just take another pair of eyes to spot the problem:) Thanks

I am just starting out learning PHP and have been trying to connect to a MYSQL DB as a tutorial. I get this error: [quote] Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Top Systems\Top PHP Studio\project\index~tps~~tps~.php on line 5 [/quote] and this is my code: [quote] <? $db = "gene"; $link  =  mysql_connect( "localhost", "root", "gene"  ); if ( ! $link )   die("Couldn't Connect to mysql" );     mysql_select_db( $db)     or die ("Couldn't open $db: ".mysql_error() )     ?> [/quote] I have MYSQl 5 installed and PHP4 running. What am I ding wrong here?? thanks from a newbie