Won't Insert Into Table

Shawazi

All I want is to put this info into the table transactions. I know a connection has been made. When it dies and echoes the query and I use it in something similar to phpmyadmin, it works. So the query's syntax is 100% correct. I have used code like this many times. Is there something I don't see here?

$query = "insert into transactions (payer_email, theorder, thestatus) values ('$firstemail', '$theorder', 'Pending')";
$result = mysql_query($query) or die("You Failed : $query");

bastien

change this

$result = mysql_query($query) or die("You Failed : $query");

to this

$result = mysql_query($query) or die("query failed because ".mysql_error());

it will give you a more meaningful error message...

also try echoing out the sql before execution to ensure wellformedness and all that stuff....

Shawazi

Here is what I get

You Failed : insert into transactions (payer_email, theorder, thestatus) values ('correctemail', 'correctorder', correctstatus)
Error is :Unknown column 'theorder' in 'field list'

This makes no sense because there is a column called theorder. If I copy paste this exact query, it will work without an error.

bastien

ensure no spaces, hypens or any other type of markings are in the column name

show field list

brailleschool

insert into transactions (payer_email, theorder, thestatus) values ('correctemail', 'correctorder', correctstatus)

ok, first off, you dont have correctstatus as 'correctstatus'

also, to my knowledge, the database names and the name of the input field has to be the SAME name. Your insert statement doesnt reflect that.

This is a query that I have in my site which works, as you can see, the names are the same (except for the $ sign which takes the value from the input field and inserts it into the relevant field in the database.

$query = "INSERT INTO login (username,password,fname,sname,email,country,city,interests,age,dobday,dobmonth,dobyear,iam,gender,school,status,aboutu,whyjoin,hobbies,children, userpic, userpicalt)".
"VALUES ('$username', '$password', '$fname','$sname', '$emaila', '$country', '$city', '$interests','$age', '$dobday', '$dobmonth', '$dobyear', '$iam', '$gender', '$school', '$status', '$aboutu', '$whyjoin', '$hobbies', '$children', '$userpic', '$userpicalt')";

LordShryku

Also make sure everything is capalized that should be. All column names are case sensitive. Alot of front end apps will correct that type of mistake for you.

Shawazi

This is just funny. I am going to kill my boss. See we transferred from one site to the next but were still on the same server (he owns it and the databases). So he changed what database every page was lookin at except the page I was just workin on. So I thought everythin was still looking in Database A when he changed it to B so this new page was messed up cause it was pointed at A and the connection was made just to the wrong place.