[RESOLVED] Warning: mysql_num_fields(): supplied argument is not a valid MySQL result ...

[peanutgallery83]

I've been staring at this error for about an hour now and cannot figure it out for the life of me. Tried looking at a few other threads on here and they all seemed to suggest a failed connection to my db, but that shouldn't be the issue as I'm using the same method of connecting to the db on several other pages that ARE working fine.

Any help troubleshooting this code would be much appreciated! Purpose of the code is to load data from a table and create an excel export.

The full error code is:

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/therefli/public_html/iowareferees/modules/registrarTools_registrationDownloadBatch.php on line 39

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/therefli/public_html/iowareferees/modules/registrarTools_registrationDownloadBatch.php on line 44

The code creating the issue:

	include("../classes/databaseConnection.php");
			$select_recert = "
			SELECT ' ', ' ', ' ', uRegBATCHID, '$date_download', ' ', ' ', ' ', uUSID, '1', '2', 
				uRegYEAR, uRegLAST, uRegFIRST, ' ', uRegADDRESS, ' ', uRegCITY, uRegADDRSTATE, uRegZIP, uRegGENDER, 
				uRegDATEOFBIRTH, uRegNATIONBIRTH' ', uRegNATIONCITIZEN' ', uRegPHONE1, ' ', uRegGRADE, uRegSTATE,  

				uRegEMAIL, ' ', uRegFIRSTREGISTERED, ' ', ' ', ' ', ' ', uRegFELONY, uRegDATE, '', '', uRegUID  

			FROM usersRegistration 
			WHERE uRegSTATUS='registered' 
				AND uRegACTION='recert' 
				AND uRegCLASS='Referee'
				AND uRegYEAR='$VAR[regyear_year]'
				AND uRegBATCHID=$batch_number
			ORDER BY uRegLAST";
	$export_recert = mysql_query($select_recert); 
	$fields_recert = mysql_num_fields($export_recert); 
	for ($i = 0; $i < $fields_recert; $i++) { 
		$header_recert .= mysql_field_name($export_recert, $i) . "\t"; 
	}  

	//EXTRACT DATA
	while($row = mysql_fetch_row($export_recert)) {   // this is line 39
		$line = ''; 
		foreach($row as $value_recert) {                                             

			if ((!isset($value_recert)) OR ($value_recert == "")) { 
				$value = "\t"; 
			} else { 
				$value_recert = str_replace('"', '""', $value_recert); 
				$value_recert = '"' . $value_recert . '"' . "\t"; 
			} 
			$line .= $value_recert; 
		} 
		$data_recert .= trim($line)."\n"; 
	} 
	$data_recert = str_replace("\r","",$data_recert);

Thanks so much in advance!!

[Weedpacket]

First: what debugging have you done so far? The first error message tells you where things went wrong: the call to mysql_query didn't send back a result set. Did you use mysql_error() to see what the error message was? Have you looked at the query that actually sent? What did you see?

[peanutgallery83]

Thanks for the reply, and sorry I didn't get back right away...been out of town on business.

A little update on the issue...i replaced my SELECT query with * so as to just select every field in the database in the order in which it appears and the file WAS able to export.

So...this brings me back to the original problem...what about my SELECT query is causing this to fail? Specifically...why would it be returning an empty result set?

This is even more confusing because I quite literally copied this code from a previous version of this same site in which the code worked, modified only the names of the table columns since they had changed with the new db, and yet now it won't work.

I know the next question will likely be "why dont' you just use the and get all table data?" and the answer is because i have to export the data from my database table into an excel format that is provided to me and thus certain bits of data need to be in specific order in the excel output. Pain in that ** but that's what happens when you work with an organization that didn't know what they were trying to do when they did it the first time...

I know its gotta be something simple but I'm just not seeing it.

Thanks again.