You have to execute the query, like so:
mysql_query( $sql );
placing this after the code which creates $sql.
Also check that your datatypes match, it's often worthwhile echoign $sql so
you can see exactly what it contains.
Regards - Miles Thompson
At 01:52 PM 1/3/2002 -0500, James Kupernik wro
check if all your fields are indeed strings (char, varchar) and not
numbers.
Mihail Bota
On Thu, 3 Jan 2002, James Kupernik wrote:
> I'm trying to input that data entered into a form into a table in my DB.
> Here is the code I have.
>
> $db = mysql_connect("localhost","cloft","spring");
>
>
ELO,DATE) VALUES
('$BFNAME','$BLNAME','$BADD1','$BADD2','$BCITY','$BZIPA','$BSTATE','$BCTRY',
'$BTELO','$TODAY')";
Mysql_query($sql);
--Ryan
-----Original Message-----
From: James Kupernik [mailto
I'm trying to input that data entered into a form into a table in my DB.
Here is the code I have.
$db = mysql_connect("localhost","cloft","spring");
mysql_select_db("countryloft",$db);
$sql = "INSERT INTO catalogreq
(BFNAME,BLNAME,ADD1,ADD2,BCITY,BZIPA,BSTATE,BCTRY,BTELO,DATE) VALUES
('$BFN