mysql_fetch_array error

[Lonepig]

I'm getting this error, Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result, from the follow piece of code and I don't know why. If I put the query straight into the mysql console the query gives the correct result but the mysql_fetch_array still bugs out. I've used the same syntax in dozens of queries prior to this so i'm completely lost.

$query = "SELECT DISTINCT Color FROM oemtoprinter WHERE (Part<>'Solid Ink' AND Part<>'Refill Kit' AND Color<>'NA' AND Color<>'N/A')";
     $result = mysql_query($query,$connection);
     confirm_query($result);

 while ($result_item = mysql_fetch_array($result)) {
   $color = $result_item['Color'];
   $query = "INSERT INTO prod_options_values (product_options_values_name,products_options_values_sort_order) VALUES ('$color','1')";
   $result = mysql_query($query, $connection);
   confirm_query($result);

results from mysql console,

mysql> SELECT DISTINCT Color FROM oemtoprinter WHERE (Part<>'Solid Ink' AND Part
<>'Refill Kit' AND Color<>'NA' AND Color<>'N/A');
+---------------+
| Color         |
+---------------+
| Black         |
| Color         |
| Cyan          |
| Magenta       |
| Yellow        |
| Photo Cyan    |
| Photo Magenta |
| Photo Black   |
| Matte Black   |
| Photo Color   |
| Green         |
| Red           |
| Waterfast     |
+---------------+
13 rows in set (0.01 sec)

[laserlight]

That warning is due to one or more of these:

• Failed to connect to database server

• Failed to select database

• Failed to execute corresponding SQL statement

Since you are sure that the SQL statement is correct, you should check if the database server connection was successful and the correct database was selected.

[bradgrafelman]

What does the confirm_query() function do?

Even if you think the query is correct, you should still check if [man]mysql_query/man returns false (and if so, echo out [man]mysql_error/man to see why).

[Lonepig]

The confirm_query function is the mysql_error checker/generator, as show below. I've also checked in the database for any results. The code runs once and makes one entry before bugging out. No error is being generated by the mysql_error() and i'm still getting the mysql_fetch_array(): supplied argument is not a valid MySQL result. Any idea? Needless to say i'm a bit baffled.

	function confirm_query($result_set) {
		if (!$result_set) {
			die("Database query failed: " . mysql_error());
		}
	}

mysql> SELECT * FROM prod_options_values;
+----------------------------+-------------+-----------------------------+------------------------------------+
| products_options_values_id | language_id | product_options_values_name | products_options_values_sort_order |
+----------------------------+-------------+-----------------------------+------------------------------------+
|                          0 |           1 | Black                       |                                  1 |
+----------------------------+-------------+-----------------------------+------------------------------------+
1 row in set (0.00 sec)

[leatherback]

You are using the $result within the loop, which would effectively render it useless for the next loop.

[Lonepig]

Somebody slap me please, Leatherback thank you very much. So obvious but its been driving me mad.

Ah well you live and learn.

[laserlight]

Remember to mark this thread as resolved using the thread tools.

[leatherback]

[slaps the LonePig]
No problem. it is easy to figure out when you have been staring at it too long .