Hi all,
Need some help trying to insert data into a database but its not working and not sure why.
Code:
<?php
$db = mysql_connect("server","username","password");
$result = mysql_select_db("m08jpr23", $db);
$Price = $_REQUEST['Price'];
$Description = $_REQUEST['Description'];
$query1 = "INSERT INTO price (Price,Description) VALUES ('$Price','$Description')";
mysql_close($db);
?>
and the table i and using
Code:
create table price (
price_code int not null auto_increment,
Price varchar(10) not null,
Description varchar(200) not null,
primary key (price_code)
)
engine = innodb;
all i get is blank page when i see if the data is in the table its not their..
Last edited by millwalll; 05-20-2009 at 06:54 AM..
|