I got a lot through a tutorial, but problem is when i tried to insert, problem occured using following code:$query = "INSERT INTO contacts VALUES ('','$first','$last','$phone','$mobile','$fax','$email','$web')"; mysql_query($query); But when i used a code provided by my server for same purpose was sucessful, which was: $sql = 'INSERT INTO `server account_database name`.`table name` (`id`, `first`, `description`, `mobile`, `fax`, `email`, `web`) VALUES (NULL, \'first\', \'$description\', \'$mobile\', \'$fax\', \'ghjhjhg\', \'ghgjghjghkgk\');'; Now My problem is that :- It supports only a single or static record at a time & from my cpanel, but I want that the users of my website can fill that form and when the click "submit query", then their input should be added to the table and they can view their data... I think that , here is a trouble in diff. version. Please If you give me the code(query"). With this hope that you will surely reply me at [EMAIL PROTECTED]
If the id field is auto increased by the sql server then try this: $sql = "INSERT INTO `server account_database name`.`table name` ( `first`, `description`, `mobile`, `fax`, `email`, `web`) VALUES ( 'first', '$description', '$mobile', '$fax', 'ghjhjhg', 'ghgjghjghkgk')"; omitting the id field which will get the next available value. You can define an auto_increment field while creating the table. -- Thodoris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
