MySQL error for NO REASON!!!

[Anon]

Does nyone see a prob with this code?
I'm getting a MySQL error on the line with the while loop.
I swear to god im going insane...

<?php

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

$retrieve = stripslashes($code);

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

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

$sql = "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]'";
$query = mysql_query($sql);
}

?>

[Anon]

what is $code? where is it defined?

Jim

[Anon]

What is the "MySQL error" ? I don't see where you're checking to see whether the call to mysql_query is returning a positive value.

Try the following change and tell us what you get :

$workit = mysql_query($werking) or die("Error: ". mysql_error());

If that doesn't get you anywhere, try making the database handle explicit, i.e. make your first line

$db = mysql_connect(blah blah);
mysql_select('db', $db);
and make sure you put mysql_error($db) in the line above.

HTH,

AC