This is really weird... i have tried the same exact code in phpmyadmin and it works like a charm, but when i run the script... no errors then i go to phpmyadmin and nothing has changed :(
this is the code:
============================================================================
$how_many_to_update=count($cardno_array);
// update the cards status to sent
for($i=0;$i<$how_many_to_update;$i++)
{
$update_sql="update greetings set is_sent=1 where cardno='".$cardno_array[$i]."' and rand_str='".$rand_str_array[$i]."' LIMIT 1";
$result = mysql_query($sql_1);
$num_rows1 = mysql_num_rows($result);
if(!$result || $num_rows1==0){echo "Error: unable to update sent greetings";exit;}
echo "updating<br>$update_sql<br>";
}
=========================================================================
In the second last line you can see i have an echo statement... the SQL thats outputted from there works perfectly in phpmyadmin...
any idea whats wrong?
Slightly OT, any better way to run the multiple updates needed above than instead of running the update query in a loop?
I searched google and the best i could find was the IN() for mySql... but that does not take 2 parameters (eg: cardno and rand_str) it would work just on card_no like this in('14','34')
Thanks!
R
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
