Cannot insert data error

tpiel33

hey guys, I have been out of the loop awhile working as a magazine editor and am now back in the programming world. I am trying to do a simple insert into database and it is throwing me an error. I am just no sure where my code is wrong, any help would be appreciated. Thanks....

Here is my insert code, it gathers info from the POST method on the previous page.......

INSERT CODE

<?php

session_start();

$connect = mysql_connect("mysql3.host, "login", "password")
or die ("Couldn't Connect to server.");

$db = mysql_select_db("databasename", $connect)
or die ("Couldn't Connect To Database.");

$subscribe = "INSERT INTO subs (UserID, BName, BAddress1, BAddess2, BCity, BState, BZip, BCountry, SName, SAddress1, SAddress2, SCity, SState, SZip, SCountry, CCType, CCNumber, CCExpMon, CCExpYear, CCVer, Email) VALUES('$UserID', '$BName', '$BAddress1', '$BAddress2', '$BCity', '$BState', '$BZip', '$BCountry', '$SName', '$SAddress1', '$SAddress2', '$SCity', '$SState', '$SCountry', '$CCType', '$CCNumber', '$CCExpMon', '$CCExpYear', '$CCVer', '$Email')";

$subscribe_result = mysql_query($subscribe,$connect)
or die ("Couldn't insert record!");

header("Location: thanksyou8.php");
exit;
?>

tpiel33

The error I get of course is "Couldn't insert record!"

ahundiak

First thing to do is to change your die statements to:
or die(mysql_error());
This way, the system can give you more info on what the problem is. This Should Zip you to the solution.

Did you notice that your columns clause has 21 names but your values clause only has 20?

tpiel33

Yeah I saw and changed where i was missing one value but no luck... lemme try the new die statement... brb 🙂

tpiel33

Hmmmm....

The form they fill out is on like subscribe.php and the script with the insert is subscribe2.php which header redirects to thankyou.php

I changed the die statement to the above mentioned and now I land on subscribe2.php with a blank white page.... ideas? I need to get my brain back in PHP mode 🙂

Current subscribe2.php Code

<?php

session_start();

$connect = mysql_connect("mysql3.domain", "dbname_admin", "password")
or die(mysql_error());

$db = mysql_select_db("XtremeO_subs", $connect)
or die(mysql_error());

$subscribe_result = mysql_query($subscribe,$connect)
or die(mysql_error());

header("Location: thankyou.php");
exit;
?>

tpiel33

Alright I fingered it all out and working alright now, thanks! I am an asshat!

So should I change my errors back to some error like contact the admin or something, so they dont see whats wrong with my shizzle?