View Single Post
Old 02-07-2008, 12:41 PM   #10 (permalink)
EyeDentify
The Acquainted
 
EyeDentify's Avatar
 
Join Date: Nov 2007
Location: Sweden
Posts: 106
Thanks: 13
EyeDentify is on a distinguished road
Default

StevenF.

Try this one below and see if it helps.

Note the way i´ve put (') and (").

This is how i usally do it. but also with sprintf sometimes.

and i found that you used an extra "," comma on the last column to be updated before the WHERE clause. Guess that could be a problem.

And make sure all table and column names are correct

PHP Code:
$query "UPDATE althlete SET    
athlete = '" 
mysql_real_escape_string($ud_name) . "',
regno = '" 
mysql_real_escape_string($ud_regno) . "',
gender = '" 
mysql_real_escape_string($ud_gender) . "' ,
age = '" 
mysql_real_escape_string($ud_age) . "',
eventno = '" 
mysql_real_escape_string($ud_eventno) . "',
distance = '" 
mysql_real_escape_string($ud_distance) . "',
stroke = '" 
mysql_real_escape_string($ud_stroke) . "',
time = '" 
mysql_real_escape_string($time) . "',
place = '" 
mysql_real_escape_string($place) . "'
WHERE athlete_number = '" 
$ud_athletenumber "'"
__________________
Of course the whole point of a doomsday machine, would have been lost if you keep it a secret.
EyeDentify is offline  
Reply With Quote