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:[EMAIL PROTECTED] 
Sent: Sunday, June 13, 2004 11:22 AM
To: Andrew Rothwell
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] 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

Reply via email to