grrr.. PHP/MySQL error...

Anon

Wazzup everybody...

In a php script (the code is listed below) interfacing with a MySQL db, I'm recieving the following error on a line utilizing a while loop to perform a task with each row of data pulled from the db in a select statement.

Any idea why this isn't werking?
This is a cookie-cutter while loop I use all of the time.

The basics:
- I did attempt to use the select statement manually through the db - it DOES work.
- The connection to the db works too
- I am going insane right now...
- the variable $codeis the actual SQL statement submitted via an HTML form to this page
- Yes I used echo statements to verify that this data is successfully being sent over

Thank you all in advance for any help you might provide...
-=Lazzerous=-

The Script:

<?php

mysql_connect("localhost",user,pass);
mysql_select_db('dbName');

$retrieve = "$code";
$workit = mysql_query($retrieve);

while($row=mysql_fetch_array($workit)){

$fixxx = "update outage set custcalled = 'yes' where tss like '$row[0]' and name like '$row[1]' and city like '$row[4]' and datestamp like '$row[32]'";
$xxxif = mysql_query($fixxx);

}

echo "Code: $code \n";
echo "Retrieve: $retrieve \n";
echo "Workit: $workit \n";

echo "Thank you! \n";
echo "All of the entries requested have been updated. \n";
echo "Please close this browser window to return to the Administrative guide site. \n";

Anon

Are your fields named by the numbers you use above like $myrow[0] and $myrow[1] seems to to me you should use mysql_fecth_row instaead of mysql_fetch_array

Anon

Depending on how PHP was configured prior to compilation, or how your php.ini file is set up, $code might not be automagically available in the script's global scope. Have you tried explicity grabbing it with $HTTP_POST_VARS["code"]?

Anon

$code does have the correct value - I tested that.
but I'm still getting the error:
Supplied argument is not a valid MySQL result resource

here's the chunk of code with the problem - the error is on the line with the while statement:

str_replace("\'","'",$code);
$retrieve = stripslashes($code);

$werking = "$code";
$workit = mysql_query($werking);

while($row=mysql_fetch_row($workit)){

$fixxx = "update outage set custcalled = 'yes' where tss like '$row[0]' and name like '$row[1]' and city like '$row[4]' and datestamp like '$row[32]'";
$xxxif = mysql_query($fixxx);

}
?>

Anon

Well, couple of things...
You shouldn't need the str_replace() on $code if you're going to run a stripslashes() immediately afterwards - since it looks like your str_replace is doing the same thing...

You also don't need to include the quotes on the $werking = "$code" assignment.

After that, if you're getting an 'invalid MySQL result resource' error then it means that the query you ran with mysql_query() was syntactically incorrect, or just didn't return any matching rows.

Anon

Kyle,

It won't return false on no matching rows.

Laz,

Try:

print mysql_error();

after the query is sent.