TalkPHP - View Single Post

StevenF · 02-05-2008, 07:31 PM

Thanks for that Bill.

"Athlete" is spelt wrong in the table, I know, instead of changing it I just made the query match it, so the problem doesn't lie there.

I have also removed that last comma, then changed the last line to the way Robert had wrote. So:

Code:

place = "'.mysql_real_escape_string($place).'"
   WHERE athlete_number = $ud_athletenumber';

Became

Code:

place = "'.mysql_real_escape_string($place).'"
   WHERE athlete_number = '.$ud_athletenumber;

It now works as intended! I can now search the database, insert a new row through a form and update the data through a form :)

Thanks a lot
Steven

02-05-2008, 07:31 PM	#7 (permalink)
StevenF The Contributor Join Date: Jan 2008 Posts: 87 Thanks: 49	Thanks for that Bill. "Athlete" is spelt wrong in the table, I know, instead of changing it I just made the query match it, so the problem doesn't lie there. I have also removed that last comma, then changed the last line to the way Robert had wrote. So: Code: place = "'.mysql_real_escape_string($place).'" WHERE athlete_number = $ud_athletenumber'; Became Code: place = "'.mysql_real_escape_string($place).'" WHERE athlete_number = '.$ud_athletenumber; It now works as intended! I can now search the database, insert a new row through a form and update the data through a form :) Thanks a lot Steven __________________ My Personal and Photo Blog