02-05-2008, 03:47 PM
|
#4 (permalink)
|
|
The Addict
Join Date: Jan 2008
Location: USA
Posts: 217
Thanks: 16
|
As I said, MySQL doesn't like double-quotes. Try:
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;
__________________
Programmers are in a race with the Universe to create bigger and better idiot-proof programs, while the Universe is trying to create bigger and better idiots. So far the Universe is winning. - Rich Cook
|
|
|
|