not a valid MySQL result

esbsolutions

Could someone help me figure out this error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/esbsolu/public_html/project/powerbucks/form.php on line 98

Thanks in advance! Here's the segment of code this is regarding:


	if($submit == 'Submit')
		{	
		$agency=$HTTP_POST_VARS['selectedagency'];
		$Employee=$HTTP_POST_VARS['Employee'];
		$Client=$HTTP_POST_VARS['Client'];
		$JobNum=$HTTP_POST_VARS['JobNum'];
		$Project=$HTTP_POST_VARS['Project'];
		$Hours=$HTTP_POST_VARS['Hours'];

		$agencyquery= "SELECT * FROM listings WHERE agency = '".$agency."'" or die(mysql_error());

		$result=mysql_query($agencyquery);

		$agencyresults= mysql_result($result,0); 

		while($r = mysql_fetch_array($agencyresults))  
			{      
			$AgencyID=$r["id"];  
			$transactionsquery= "SELECT * FROM transactions WHERE AgencyID= '".$AgencyID."'";
			$idquery= mysql_query($transactionsquery) or die(mysql_error());
			$idresult= mysql_result($idquery,0);				
			$qrycount = mysql_num_rows($idresult);

LordShryku

You have your die statements in the wrong place.

This

$agencyquery= "SELECT * 
               FROM  listings 
               WHERE  agency = '".$agency."'" or die(mysql_error());
$result=mysql_query($agencyquery);

Should be this

$agencyquery= "SELECT * 
               FROM  listings 
               WHERE  agency = '".$agency."'";
$result=mysql_query($agencyquery) or die(mysql_error());

Move those around on your queries. This error is usually the cause of a bad SQL query

esbsolutions

Hmmmmmmm, that didn't do anything when I moved the die statements.....any other considerations? Should I post more code or do you have enough to go by? Thanks!

LordShryku

OH! I'm blind. You're trying to fetch the array from the results, not the query

$agencyresults= mysql_result($result,0); 

        while($r = mysql_fetch_array($agencyresults))

I'm not sure what you want. The array or the result, but if the array, you should use

while($r = mysql_fetch_array($result))