Mysql Insert Switching Names And Place

[katai]

Hey!

 

I got Insert into table

 

Name and Content but when I add into name it switches place with content.

So name -> Content and Content -> Name :/

 

Anyone knows a fix or what's wrong?

[requinix]

It probably has something to do with your code. Which we can't see right now...

[katai]

http://pastebin.com/m5gfNtK3 here mate

[requinix]

Couldn't just post it?

function addPost($pName, $pAuth, $pContent,$pCat = 1) {
$query = mysql_query("INSERT INTO posts VALUES(null,'$pName','$pAuth','$pContent','$pCat')") or die(mysql_error());
}

Specify the names for the fields...

INSERT INTO table (field1, field2, field3) VALUES ("value 1", "value 2", "value 3")

INSERT INTO table SET field1="value 1", field2="value 2", field3="value 3"

because I bet your problem is that you haven't noticed how the order of the fields in the table don't agree with the order of the fields in your SQL.

[katai]

oh thanks alot man, will try it out =)