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 lali399@xxxxxxxxx
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
