Change you query string to something like:
mysql_query ("INSERT INTO name (name,surname)
VALUES (\"$name\",\"$surname\")");
or
mysql_query ('INSERT INTO name (name,surname)
VALUES ("'.$name.'","'.$surname.'")');On Friday, March 14, 2003, at 10:39 AM, Mahmut KARADEMIR wrote:
Hi All;
I am trying to add a new record web database using Mysql&PHP.
But after at every add process a new blank record is added to mysql table.
The entered text is not considered with codes.
What is my trouble in this html or php code?
Could anyone has any idea?
Thanks.
***************name.html******************
<html>
<body>
<form action="name.php" method="post">
<PRE>
name...... : <input
type="text"
name="name"
size="25"
maxlength="25"
value="<? echo $name>">
<P>
surname: <input
type="text"
name="surname"
size="25"
maxlength="25">
< input type="submit"
name="submit"
value="submit">
</PRE>
</form>
</body>
</html>
*******************name.php***************
<?php
mysql_connect("localhost","user","password");
mysql_select_db ("mydatabasename");
mysql_query ("INSERT INTO name (name,surname)
VALUES ('$name','$surname')");
echo ('Your record has been added.');
print ("<p>");
print ("Your Name:");
print ($name);
print (" ");
print ("<p>");
print ("Your Surname:");
print ($surname);
print ("<p>");
print ("THANKS");
?>
Mahmut
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
