[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:
---
snip
$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');
?//retrieve data from DB display in dynamic drop down ?
SELECT class=textarea name=tutor_name /
?
$sql = mysql_query(SELECT DISTINCT tutor_name FROM tutor );
while ($row = mysql_fetch_array($sql))
{
print OPTION VALUE=\$tutor_name\ SELECTED .$row
[tutor_name]. /option ;
}
$result = $db- query($sql);
?
/select
?
while($selected_tutor_name == $tutor_name)
echo $_POST[tutor_name];
?
/snip
---
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_namesame 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 :
SELECT class=textarea name=tutor_name
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
[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].');
_
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
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.
?
$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].');
_
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
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
