[PHP-DB] Problem with INSERT Query
Hi all: Well, when i bring out the page with the drop down list it was able to display all tutors' names from "tutor_name" column. Anyway here's a review of my code (snip) again before i continue: --- $sql = "INSERT INTO class (class_code, tutor_name, edu_level, timetable_day, timetable_time) VALUES ('$class_code','$tutor_name','$edu_level','$timetable_day','$timetable_time')"; " .$row ["tutor_name"]. " "; } $result = $db-> query($sql); ?> --- so when i submit the form, i am suppose to echo the values i have entered into the field and then INSERT the values into DB (Queries stated above). However i was able to echo all other values eg. class_code, edu_level, etc...but not "tutor_name"same thing happen when i do an INSERT, all other values are inserted into DB but not $tutor_namewhy is this so???Really need some help here...Anyway i have already specify a name to be reference : and then I also did an echo of "tutor_name" being selected: while($selected_tutor_name == $tutor_name) echo $_POST["tutor_name"]; All help are greatly appreciated =) Irin. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] problem with insert query
It seems to me that this code will not provide useful information: if ($result) echo mysql_affected_rows()." affected."; If the insert was successful, it will always say "1 affected." Since you are only inserting one row at a time. On Sat, 07 Jun 2003 08:49:15 -0400, Becoming Digital wrote: > Try this. I made some minor syntax changes and added some error reporting. > While it may not fix things, it might help you figure out what's wrong. > > $mails=file("mails.txt"); > $number_of_mails = count($mails); > > for ($i=0; $i<$number_of_mails; $i++) > { > $link = @ mysql_connect("localhost") > or die( mysql_error() ); > $db = mysql_select_db("me2resh00", $link); > $query = "insert into recipients (recipient_name, > recipient_email) values > (\"friend\", \"".$mails[$i]."\")"; > $result = mysql_query($query); > if ($result) > echo mysql_affected_rows()." affected."; > } > ?> > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > > > - Original Message - > From: "Ahmed Abdelaliem" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, 07 June, 2003 08:15 > Subject: [PHP-DB] problem with insert query > > > hi > i am wrote a script to read e-malis from a file and insert it into the > tables of database > i get error when i write it > here is the code > can anyone tell me what is wrong? > > $mails=file("mails.txt"); > $number_of_mails = count($mails); > > for ($i=0; $i<$number_of_mails; $i++){ > > @ $db = mysql_connect("localhost"); > mysql_select_db("me2resh00"); > $query = "insert into recipients (recipient_name, recipient_email) values > ('"friend"', '".$mails[$i]."')"; > $result = mysql_query($query); > if ($result) > echo mysql_affected_rows()." affected."; > >} > ?> > > > here is the error that i get > > Parse error: parse error in enter.php on line 9 > > > and line 9 is > > $query = "insert into recipients (recipient_name, recipient_email) values > ('"friend"', '".$mails[$i]."')"; --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] problem with insert query
Try this. I made some minor syntax changes and added some error reporting. While it may not fix things, it might help you figure out what's wrong. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Ahmed Abdelaliem" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, 07 June, 2003 08:15 Subject: [PHP-DB] problem with insert query hi i am wrote a script to read e-malis from a file and insert it into the tables of database i get error when i write it here is the code can anyone tell me what is wrong? here is the error that i get Parse error: parse error in enter.php on line 9 and line 9 is $query = "insert into recipients (recipient_name, recipient_email) values ('"friend"', '".$mails[$i]."')"; _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] problem with insert query
hi i am wrote a script to read e-malis from a file and insert it into the tables of database i get error when i write it here is the code can anyone tell me what is wrong? for ($i=0; $i<$number_of_mails; $i++){ @ $db = mysql_connect("localhost"); mysql_select_db("me2resh00"); $query = "insert into recipients (recipient_name, recipient_email) values ('"friend"', '".$mails[$i]."')"; $result = mysql_query($query); if ($result) echo mysql_affected_rows()." affected."; } ?> here is the error that i get Parse error: parse error in enter.php on line 9 and line 9 is $query = "insert into recipients (recipient_name, recipient_email) values ('"friend"', '".$mails[$i]."')"; _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php