Re: [PHP-DB] MYSQL: INsert html form data;

[[EMAIL PROTECTED]]

I'm not sure what you're asking but the fields are set to varchar(40) which
will accommodate the information I have been insertinging...

/T


on 4/30/02 9:00 PM, Neil at [EMAIL PROTECTED] wrote:

 Have you checked to see that id tidying is set to the amount equal to the
 fields in your form.
 - Original Message -
 From: Info_Best-IT [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, April 30, 2002 4:56 PM
 Subject: [PHP-DB] MYSQL: INsert html form data;
 
 
 I have a problem writing form data to a table in MySQL.  I have an
 action.php file
 that it called when the information is submitted and it looks something
 like this:
 
 ?php
 
   $connection = mysql_connect(@localhost,root, password)
 or die (The DataBase is Down!);
 
mysql_select_db(web_feedback, $connection)
 or die (I Can't connect at database!);
 
$query_st_name = mysql_query(INSERT into name_email (col1)
 values($name));
$query_st_email = mysql_query(INSERT into name_email (col2)
 values($email));
 mysql_close($connection); // Close this connection
 ?
 
 Thanks for submitting your name and e-mail, I will contact you soon to
 discuss your
 interest in more detail.
 
 I can tell the file is being called since the previous message appears in
 the window.
 But when I go to check out my table there are no records.  Anyone see
 where this may
 be going wrong?  I also set a php_error log path in the PHP.ini and I do
 not get any
 errors written there.  I think it may be something else but not sure
 what...
 
 the site: www.best-it.biz
 the link: services
 thanks in advance!
 /Tim
 
 
 --
 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] MYSQL: INsert html form data;

[Info_Best-IT]

I have a problem writing form data to a table in MySQL.  I have an action.php file 
that it called when the information is submitted and it looks something like this:

?php

  $connection = mysql_connect(localhost,root, password)
or die (The DataBase is Down!);

   mysql_select_db(web_feedback, $connection)
or die (I Can't connect at database!);
   
   $query_st_name = mysql_query(INSERT into name_email (col1) values($name)); 
   $query_st_email = mysql_query(INSERT into name_email (col2) values($email));
mysql_close($connection); // Close this connection
?

Thanks for submitting your name and e-mail, I will contact you soon to discuss your
interest in more detail.

I can tell the file is being called since the previous message appears in the window.  
 
But when I go to check out my table there are no records.  Anyone see where this may 
be going wrong?  I also set a php_error log path in the PHP.ini and I do not get any 
errors written there.  I think it may be something else but not sure what...

the site: www.best-it.biz
the link: services
thanks in advance!
/Tim


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php