[RESOLVED] Insert mysql Problem

[saint4]

Hi,

I'm having a problem with this. The data is not being inserted into the database. I do not get no errors.

I tried <?=$_POST['username'];?> and it displayed the correct value on the page. So i think its getting the information i just dont understand why its not working. I may have overlooked something.

I'm including the database connection and i know that works fine.

Please help

<?
mysql_query("INSERT INTO crib_users (username,password,email,rname,gender,country,birthdate) VALUES ('".$_POST['username']."','".md5($_POST['password'])."','".$_POST['email']."','".$_POST['rname']."','".$_POST['gender']."','".$_POST['country']."','".$bdate."')");
?>

[wreed]

do, and see how the query is, then try and paste it into mysql and see if its inserting there right.

Also might want to assign the username to a variable first then put that variable into the insert statement.

echo $mysql_query;

[saint4]

I figured it out, rathor simple really.

[TobyRT]

and what was the solution?

Could you mark this thread as 'resolved' please?

ta!