I am using this code and It doesn't insert the data into the data base.
$db = mysql_connect(localhost, $loginname, $loginpassword) or die("Unable to connect to database");
mysql_select_db ("$DBName",$db) or die("Unable to select database $DBName");
mysql_query ("INSERT INTO $category VALUES
('$username', '$password', '$category',
'$company', '$address', '$city', '$state',
$zipcode, '$name', $phonenumber, $faxnumber,
'$email', '$website', '$hours', '$holidays',
'$directions', '$classad1', '$classad2',
'$classad3', '$cctype', $ccnumber, $ccmonth, $ccyear)
") or die("Unable to insert info into $category");
Everything works until it gets to the TABLE part and then bails out!!!
PLEASE HELP!!
Thanks,
Sam
$db = mysql_connect(localhost, $loginname, $loginpassword) or die("Unable to connect to database");
mysql_select_db ("$DBName",$db) or die("Unable to select database $DBName");
mysql_query ("INSERT INTO $category VALUES
('$username', '$password', '$category',
'$company', '$address', '$city', '$state',
$zipcode, '$name', $phonenumber, $faxnumber,
'$email', '$website', '$hours', '$holidays',
'$directions', '$classad1', '$classad2',
'$classad3', '$cctype', $ccnumber, $ccmonth, $ccyear)
") or die("Unable to insert info into $category");
Everything works until it gets to the TABLE part and then bails out!!!
PLEASE HELP!!
Thanks,
Sam