June 11th, 2000, 04:23 AM
I have a form. When the user add an entry, it should get added in the Mysql table.
How is it done.
Again, I have a databse of 600 records typed in excel can I use it as my MySql database so that I don't have to type it again.
Here is part of the form.
<FORM ACTION='email.php3' METHOD='POST'>
<INPUT TYPE='text' NAME='CatID' SIZE='20' MAXLENGTH='30'>
Your name <BR>
<INPUT TYPE='text' NAME='CatName' SIZE='20' MAXLENGTH='30'>
Learn HTML and Java at
June 11th, 2000, 05:52 AM
// Split the variables into their individual variables..
while (list($name, $value) = each($HTTP_POST_VARS));
// connect into the database..
$db = mysql_connect ("localhost","username", "password");
// Inserting the values into tablename..
$sql_insert = "INSERT INTO tablename ( catID, catName ) VALUES ( '$catID', '$catName' )";
good luck with the rest