getting mysql error during query

[popendot]

im getting an error during a query...i need some help troubleshooting..

here is the code:

$step2 = @mysql_query("INSERT INTO clublist SET name='$name', pnotes='$pnotes', pres='$pres', hashed='$upass', adv='$adv', pemail='$pmail', timestamp='$stamp', aemail='$amail', email='$clubmail', dues='$dues', payloc='$ploc', payable='$payable', website='$website', user='$user', pass='$pass', school='$school', notif='1'");
        if ($step2) {
        $cid = mysql_insert_id();
        $default = @mysql_query("INSERT INTO clubmember SET club='$cid', member='0'");
        if ($default) {
            echo "<div class='bodytext'>-- $name"; }
        } else {
        exit('Error verifying club' . mysql_error()); } 

here is the error:

Error verifying clubYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's transcript to the check as we accept membership on a competiti

the text in the error corresponds to "$pnotes" in line 2 of the code.

[clamcrusher]

put your sql query into a variable, so you can echo it and look at what your sending to mysql.

[php_daemon]

It appears to be a problem because of quotes, use mysql_real_escape_string() on all values.

[sajjad]

remove @ sign and then check the result

[amirbilal]

please use either of these functions with all of the text inputs variables
addslashes
mysql_escape_string
mysql_real_escape_string

Regards.