it's supposed to be: INSERT INTO table VALUES (val1,val2,...,valn);
all string and date values go between ' '...numeric values don't need them...
here's an example: INSERT INTO table VALUES ('abc',500,'12-12-2003');
if your table has 5 fields but you don't want to insert values for them all then you must specify the fields that you want to insert:
INSERT INTO table (field1,field2) VALUES (val1,val2);
hope this helps.
Rui Cunha
Andrew Rothwell writes:
Hi Larry, Thank you very much for the very quick response, I set my php.ini
file (located /etc/php.ini ) for the register_globals = On (it was off by
default)
Now however I get an error Error adding entry: You have an error in your SQL syntax near 's spanish
driver is found shot dead, Inspector Jacques Clouseau is the first off' at
line 8
My Database is a movie database of my dvd's that I own (for insurance
reasons)
My addmovie.php is this
<?
mysql_connect("localhost","username","password");
mysql_select_db("movies");
$add = "INSERT INTO movies SET
movie_name='$movie_name',
genre='$genre',
director='$director',
star1='$star1',
star2='$star2',
star3='$star3',
brief_synopsis='$brief_synopsis',
imdb_link='$imdb_link'";
if (@mysql_query($add))
{
echo("<p>Your entry has been added. <br>
$movie_name</p>");
}
else
{
echo("<p>Error adding entry: " .
mysql_error() . "</p>");
}
?>
And the addmovie.htm page (atleast the form action is this)
<body bgcolor="#FFFFFF">
<form method="post" action="addmovie.php" name="addmovies">
<table width="300" border="0" cellspacing="2" cellpadding="2"
bordercolordark="#FF0033" bordercolorlight="#FFFF66">
<tr>
<td width="41%" bgcolor="#999999">Movie Name </td>
<td width="59%" bgcolor="#99FFCC"> <input type="text" name="movie_name">
</td>
</tr>
Andrew
-----Original Message-----
From: Larry E. Ullman [mailto:LarryUllman@xxxxxxxxxxxxxxx] Sent: Sunday, June 13, 2004 11:22 AM
To: Andrew Rothwell
Cc: php-db@xxxxxxxxxxxxx
Subject: Re: Mysql not receiving the data
Online I could see everything, and the pages gave the appearance of working, however when I went into the DB using PHPMYADMIN to check the status of the new data entered, all I found was blank rows ( for the new data since the rebuild, all the old data was there) There were the correct number of new rows for the amount of records that I had entered, which tells me (unless I am nistaken) that the PHP is talking to the DB, and is atleast sending a insert command, but the rest of the data is not getting in. -
Without seeing any code whatsoever and since this worked before but no
longer works on a new install, I can only assume that your code was written
with the assumption that register_globals was turned on and it's not on in
your current configuration.
If that is the case, see the PHP manual or search the Web for the solution
($_POST, $_GET, etc.).
Larry
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
