INSERT inserts new data to database. If you want to update data, use
UPDATE instead of INSERT.
Olavi Ivask
I have been racking my brains trying to figure out what I am doing wrong.
i
have created a basic form that calls requests user information...the form
then runs insert.php. No errors are
mysql_query (INSERT INTO users (First,Last,Phone,Mobile,Email,Web) VALUES
('$first_name','$last','$phone,'$mobile','$email','$web') );
echo('$username','$last')
This doesn't work. You need to make a variable for the executed query, like,
$query = mysql_query(.);
After that, you get
If you are still having issues with this, try echoing out your query to the
browser before sending the query to the database. Once you do that, you can
look at the query that will be sent to the database. If there is an error
there, you can fix it. If not, you can rule out your query string as
echo('$username','$last')
???
what was your intention with this line?
assuming your table's field names are as set in your query then everyuthing is
OK. which brings me to the line above (which is quite oddly syntaxed!).
Please explain what you meant by this and I may be able to help you
I tried using pdo (www.php.net/pdo) as it would be nice for my projects
to be portable to another database systems, but quickly ran into problems.
The lesser important: One time, there was a simple typo in one of my
queries and I got an error that php is not able to save session
variables
