AAARGG!!! help with error no. 1065

Ryan_McAuley

I have a small kennel db that I need to retrieve a list of dogs from... I am using the following query;

mysql_select_db($database_chry7248, $chry7248);
		$query_prospect = "SELECT tbldogs.dog_id, tbldogs.callname, tbldogs.regname, descr FROM tbldogs WHERE tbldogs.for_sale='Y' AND tbldogs.prospect='Y'";
		$rsprospect = mysql_query($rsprospect, $chry7248) or die(mysql_errno() .": ". mysql_error());
		//$row_rsmature = mysql_fetch_assoc($rsmature);
		$totalRows_rsprospect = mysql_num_rows($rsprospect);

Which should return 1 dog. At least it deas in phpmyadmin. But when run from a browser it responds with;
1065: Query was empty

I do not understand why, when I take the sql and paste it in phpMyAdmin returns 1 record but in the script... no record.

Please help before I yank out the rest of my hair.

dagon

your missing a mysql_connect

HalfaBee

nope,

You define
$query_prospect = "SELECT tbldogs.dog_id, tbldogs.callname, tbldogs.regname, descr FROM tbldogs WHERE tbldogs.for_sale='Y' AND tbldogs.prospect='Y'";

and use $rsprospect as the query.
$rsprospect = mysql_query($rsprospect, $chry7248)

Ryan_McAuley

Thanks for the replies. Halfabee you solved my issue... lol thank you.