problem with inserting form data in database

prasadsawant5

hi every1
recently i'm facing a problem in inserting form data in my sql database....

Parse error: syntax error, unexpected T_IF in C:\wamp\www\database1.php on line 3
dis is d error i'm getting plz help itz urgent.............

prasadsawant5

<?php
$connection = mysql_connect("localhost", "root", "")
    if (!$connection){
        die ("Could'nt connect to server");
    }
$db = mysql_select_db("project", $connection)
   if (!$db){
        die ("Could'nt select database");
   }
$query = "INSERT INTO account (username, password, email_id, country, address, pin, contact_no, gender) VALUES ('$_POST[usrname]', '$_POST[pswrd1]', '$_POST[email]', '$_POST[nationality]', '$_POST[address]', '$_POST[pin]', '$_POST[contact]', '$_POST[gender]')";gender]')";

$result = mysql_query($query)
    or die ("Query failed " . mysql_error());
?>

bradgrafelman

Few things I noticed...

You might want to at least try to use proper English next time. This isn't a chat room, y'know. (Also note that we don't care how "urgent" it is for you... we're all volunteering our time here for free.)
There's no need to post a bunch of irrelevant code in the form of attachments. In other words, there's no need for you to make it as hard as possible for us to help you (unless, of course, your goal was to discourage people from even bothering to read your code let alone reply).
There is a stickied thread in this forum dedicated to parse errors called Parse Error: syntax error. While there are currently 72 pages to that single thread, I'd be willing to bet that less than 5 unique solutions cover > 90% of all of those posts.

For example, your problem is caused by a missing semicolon for the statement preceding the one referenced in the error message.

EDIT: Ignore #2 above - didn't see your more recent post (which got stick in the moderation queue - sorry 'bout that)!

Bonesnap

You're missing two semicolons in your code. One is right before an IF statement...