Thanks for your suggestions.
first my /etc/php.ini
register_globals = on
second i made the change as you suggested and i added a
[$blabla = "truly random";]
when the input.php is excuated, 'blabla' value is inserted into the
table. '$first_name' is still left blank.
this leads me to believe that '$first_name' is blank to start with!
somehow the input.html gives input.php blank $first_name , $location .
care to look at my input.html ? thanks alot.
#
<?php
$db_name ="cheese_catalog";
$table_name = "user";
$blabla = " bla bla";
$connection = @mysql_connect("localhost","test","new0pass") or
die("Couldn't Connect.");
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select
database.");
if ("none_required"=="none_required") {
$sql = "INSERT INTO $table_name (first_name,location,phone,messages)
VALUES ('$first_name','$location','$phone', '$blabla');";
$result = @mysql_query($sql, $connection) or die("Error #".
mysql_errno() . ": " . mysql_error());
include("input_added.html");
}
?>
#
Michael Hazelden wrote:
> Hi there,
>
> Two things:
>
> (a) in my experience - you should use single quotes in your query to
> surround the values and so you don't need to escape them either (e.g.
> '$first_name')
>
> and (b) Make sure register_globals is on - otherwise you need to use
> $_POST[first_name]
>
> Cheers,
>
> Michael.
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 10 September 2002 01:15
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] whats wrong with my sql insert statement?
>
>
> Hi
> I am using redhat 7.3 with mysql-3.23.49-3 php-4.1.2-7.3.4
> apache-1.3.23-11.
> I want to insert few values into a mysql table. This input.php sort
> works. it will add a new entray to the table but with blank values. What
> did I do wrong?
> #
> #
> # file name input.php
> <?php
>
> $db_name ="cheese_catalog";
> $table_name = "user";
> $connection = @mysql_connect("localhost","test","test") or die("Couldn't
> Connect.");
> $db = @mysql_select_db($db_name, $connection) or die("Couldn't select
> database.");
> if ("none_required"=="none_required") {
>
> $sql = "INSERT INTO $table_name (first_name,location,phone,messages)
> VALUES (\"$first_name\",\"$location\",\"$phone\", \"$messages\");";
> $result = @mysql_query($sql, $connection) or die("Error #".
> mysql_errno() . ": " . mysql_error());
>
> include("input_added.html");
>
> }
>
> ?>
> #
>
> # file name input.html
> #
> <html>
> <head>
> <title>New Record</title>
> </head>
> <body>
> <p>Please fill out the following information:</p>
> <form method="post" action="input.php"" enctype="multipart/form-data">
> <table width="100%" border="0" cellspacing="3" cellpadding="3">
> <tr>
> <td width="25%">first_name:</td>
> <td width="75%"><input name="first_name" type="text" size=40
> maxlength=255 value=""></td>
> </tr>
> <tr>
> <td width="25%">location:</td>
> <td width="75%"><input name="location" type="text" size=40
> maxlength=255 value=""></td>
> </tr>
> <tr>
> <td width="25%">phone:</td>
> <td width="75%"><input name="phone" type="text" size=40
> maxlength=255 value=""></td>
> </tr>
> <tr>
> <td width="25%">messages:</td>
> <td width="75%"><input name="messages" type="text" size=40
> maxlength=255 value=""></td>
> </tr>
> <tr>
> <td width="25%"> </td>
> <td width="75%" align="left"><input type="submit"
> name="submit" value="Enter"> <input type="reset" name="reset"></td>
> </tr>
> </table>
> </form>
> </body>
> </html>
> #
> #
>
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
