AND Syntax not working in query

EverToDesign

Hey. Basically I need to get records base off two requirements

when i make the query like this

	$query = "SELECT asReportID, ADtransnum FROM $reports_table WHERE asReportID = $controlnumber AND RAgency2 = $id
								  $order_by_str $sort_order_str $limit_str";

it doesn't work.

however if its just

	$query = "SELECT asReportID, ADtransnum FROM $reports_table WHERE asReportID = $controlnumber
								  $order_by_str $sort_order_str

$limit_str";

It works fine. Any ideas? Note- not sure if it makes a difference but RAGency2 is an INT(11) in the DB

rachel2004

When you say it doesn't work, do you mean you get a syntax error? As far as I can tell, it looks like it should work, but that doesn't necessary mean you have any matches to your query. So if you're coming back with an empty set, the query is working, but you just don't have records that match.

Also, please echo out what your variables are. If RAgency2 is an int type in your table, but $id is not an int type, that could be another cause for a problem.

EverToDesign

nothing comes up its blank. I know there is a record because i have two records with he value '1' for RAgency2. as for $id it equals 1 i echoed it out before the query.

rachel2004

Getting back to basics, how about hard coding the values into your query and using single quotes around those values? If that works, then you'll know it's something incorrect that you are assigning (or not assigning) to your variables.

EverToDesign

lol tried that already btu no go. :-( its driving me insane.

rachel2004

Please post what is in these three variables:

$order_by_str $sort_order_str $limit_str"