> -----Original Message----- > From: Simcha Younger [mailto:simcha@xxxxxxxxxxxx] > Sent: 04 August 2010 08:19 > > > Paul_S_Johnson@xxxxxxxxxxxxxxxx wrote: > > > > > > > THE INPUT: > > > > > > $sql_insert_registration = sprintf("INSERT INTO > > > Registrations ( > > > Class_ID, > > > prid, > > > Registrant, > > > Company, > > > Phone, > > > Email > > > ) > > > VALUES ( > > > $_POST[Class_ID], > > > $_POST[prid], > > > '%s',". > > You need double-quotes here, > \"%s\", No, he doesn't. Single quotes are fine. Doubles would more than likely be a SQL error. > > > parseNull($_POST['Company']).", > > > '$_POST[Phone]', > > > '$_POST[Email]' > > > )", mysql_real_escape_string($_POST['Registrant'])); > > > > > > -- > Simcha Younger <simcha@xxxxxxxxxxxx> Cheers! Mike -- Mike Ford, Electronic Information Developer, Libraries and Learning Innovation, Leeds Metropolitan University, C507 City Campus, Woodhouse Lane, LEEDS, LS1 3HE, United Kingdom Email: m.ford@xxxxxxxxxxxxxx Tel: +44 113 812 4730 To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
