https://www.webmaster-forums.net/crss/node/1016873 en https://www.webmaster-forums.net/serverside-scripting/insert-1-field-instead-10#comment-1098036 <p>I don't see anything wrong...<br /> <div class="codeblock"><code><span style="color: #000000"><span style="color: #0000BB">&lt;?php<br /></span><span style="color: #007700">if (</span><span style="color: #0000BB">$result </span><span style="color: #007700">== </span><span style="color: #0000BB">0</span><span style="color: #007700">) {<br />&nbsp;&nbsp;&nbsp; </span><span style="color: #0000BB">$sql_contact </span><span style="color: #007700">= \</span><span style="color: #DD0000">"INSERT INTO biocontact (uname) VALUES ('</span><span style="color: #0000BB">$uname</span><span style="color: #DD0000">')\";<br />&nbsp;&nbsp;&nbsp; </span><span style="color: #0000BB">$result_contact</span><span style="color: #DD0000"> = mysql_query(</span><span style="color: #0000BB">$sql_contact</span><span style="color: #DD0000">);<br />&nbsp;&nbsp;&nbsp; if (!</span><span style="color: #0000BB">$result_contact</span><span style="color: #DD0000">) {<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo \"\n\n&lt;!--\n\";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo \"File: \" . __FILE__ . \"\n\";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo \"Line: \" . __LINE__ . \"\n\n\";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo \"QUERY ERROR:\n\" . query_error() . \"\n\n\";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo \"QUERY:\n</span><span style="color: #0000BB">$sql_contact</span><span style="color: #DD0000">\n\";<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo \"--&gt;\n\n\";<br />&nbsp;&nbsp;&nbsp; }<br />}<br />?&gt;</span></span></code></div>Does this print an error? Have you tried running the query in phpMyAdmin or at the mysql prompt?</p> Fri, 11 Jan 2002 07:26:05 +0000 Mark Hensler comment 1098036 at https://www.webmaster-forums.net