Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199903

[PHP3] Why won't this thing INSERT? From: Alan Wicks (aswicks <email protected>)
Date: 03/21/99

Greetings,
I have a frame set with a menu for making choices in the
upper frame.
In the lower frame the php3 pages show up showing the
current data in a table and then a form to enter adds,
edits, deletes. The problem is that the add table won't
INSERT. Actually, it won't even echo the variable that is
supposed to be passed over. But, php3 works in the first
page since it fills a table with the info in the car_colors
table.

Here is the form data:
--------------------
<form method="POST" action="add_color.php3"
name="EnterNewColor" target="_self">
  <p>Enter new Color: <input type="text" name="color"
size="10"><input type="submit"
  value="Submit" name="submit1"><input type="reset"
value="Reset" name="reset1"></p>
</form>
--------------
Here is the add_color.php3. I know it actually gets to the
page because it prints the two lines before the <script=php>
line. 

--
<p>ADD COLOR.PHP3</p>
<p>just to be sure</p>
<p><script language="php3">
echo "COLOR = $color<BR>"; //this value never shows up on
the screen.
$connection = msql_connect() or die("COULD NOT CONNECT TO
mSQL server");
$dbname = "pacmp_cardb";
$table1="car_color";
$insert = msql($dbname, "INSERT INTO $table1 (color)"
." VALUES ('$color')")";
</script>
-------------
color is the name of the variable in the car_color table.

Thanks,
Alan S. Wicks

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3
List administrator:  zeev-list-admin <email protected>