Database Errors (MySQL on Windows XP)

Akito

I get two errors, one, while inserting into the database. Although the insert does work, it gives me this error:

Warning: Supplied argument is not a valid MySQL result resource in functions.php on line 21

Here is the query:
INSERT INTO plants SET id = 'plant,18703,7410,29649,id', common_name = 'Burgundy Bungle', botanical_name = 'Ajuga', description = 'Blue flowers atop burgundy and bronze foliage of this perennial. Blooms from May to June. May be planted in full sun or shade, requires moderate water, and is deer resistant. ', picture_url = 'ajuga/ajuga.jpg', type = '7', size = '1', flower_color = '6', flower_period = '1', fall_color = '', water_tolerance = '2', sun_requirements = '3', deer_resistant = '1', max_elevation = '4', hardness = ''

Also, when deleting from PHPmyadmin, I get this error:
Warning: Supplied argument is not a valid MySQL result resource in e:/webserve/apache/apache/htdocs/phpmyadmin/sql.php on line 251

Warning: Cannot add header information - headers already sent by (output started at e:/webserve/apache/apache/htdocs/phpmyadmin/sql.php:251) in e:/webserve/apache/apache/htdocs/phpmyadmin/sql.php on line 367

I have no idea what is wrong 🙁

nnichols

Originally posted by Akito
Warning: Supplied argument is not a valid MySQL result resource in functions.php on line 21

This error is produced by PHP because it doesn't like the result resource identifier that you have passed to a "mysql_fetch_" function. If you want a more detailed answer you need to post your code so I (or someone else) can have a look.

Hope this helps 😉

Akito

Hey there, sorry for the late response!

The code:
(it starts by passing the code into a function I created for mySQL querys. the first var is for the actual query, and the second tells us if we are going to be looping the request or not)

query_database($add_string,"");

Then goes to functions.php (included in script) for..

function query_database($query_request, $looped_request)
{

if(!$result = mysql_query($query_request)) // initial query
{
build_error("I'm sorry, we couldn't connect to the database and retrive what you asked for (error1 using code $query_request)","yes");
}
$var_to_return = $result;

if(!$looped_request) // we are not putting the info in a loop, so don't loop it (while statement coded in later)
{
	if(!$myrow = mysql_fetch_array($result)) 
	{
	build_error("Cannot fetch item (error2 using code $query_request)","yes");

	}
$var_to_return = $myrow;
}	
return $var_to_return;

}[/i]

All the build_error function does is report the error so I can read it (kinda my own error checking). The first var is the error, the second is for telling the script if it should die or not (fatal error)..

Edit: Line 21 is if(!$myrow = mysql_fetch_array($result))

Akito

bump

anybody?

nnichols

I suggest you use the following line after your queries or add a variation of it to your error_handler -

echo "<b>mySQL error no: " . mysql_errno() . "<br>mySQL error: " . mysql_error() . "</b>";

The reason you are getting the error when using "mysql_fetch_array()" after the insert is simple. When doing inserts, updates, etc your "mysql_query()" will return "true" or "false" (1 || 0). Hence when you try "mysql_fetch_array($result)" it is trying to fetch an array when there is only "true" or "false".

Hope this helps 😉

Akito

Yes, that makes perfect sense. I can't believe I didn't see that before. I assume just treating it like a request that's going to be put in a while statment would work fine - because you don't even need mysql_fetch_array();

I'm going to add that to my code, and also rewrite it to be more flexable, being able to support more types of querys and also advanced error handling..

Edit: That worked like a charm. I just told the script I was going to loop it (second var) and it didn't give me any errors 🙂

Thanks!