Very weird error.. im positive it's perfect..

[bl4ckl4b3l]

$insert = "INSERT INTO list (username, password, email, site, url, description, ip, date, in, out) VALUES('$username','$password','$email','$site','$url','$description','$ip','$date',0,0)";

mysql_query($insert) or die(mysql_error());

What could possibly be wrong with this?

Here is my error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'in, out) VALUES('yttryt','yytrry','ttry','tyt','ytyt','rytyr','0.0.0.0','j' at line 1

[jazz_snob]

Seems like your 'date' is the letter 'j'. Will that make mysql complain if date column is date or datetime format? I think it might.

[bl4ckl4b3l]

it's just text, even if i set it null it still does it - ive tried EVERYTHING

[bl4ckl4b3l]

even this gives me error...

			$insert2 = "INSERT INTO list (username, password, email, site, url, description, ip, date, in, out) VALUES (0,0,0,0,0,0,0,0)";
			mysql_query($insert2) or die(mysql_error());

[bl4ckl4b3l]

heres the whole script if it helps someone figure this out... theres a whole header but i didnt include it.

<? 
mysql_connect("localhost","filehunt_top","puma") or die (mysql_error()); //connect to db
mysql_select_db("filehunt_top") or die (mysql_error()); //select db
		if ($submit) {
			//username, password, email, site, url, description, in, out, date, ip
			$in = 0;
			$out = 0;
			$date = 0;
			$ip = $_SERVER['REMOTE_ADDR'];


		$insert = "INSERT INTO sites (username, password, email, site, url, description, in, out, date, ip) values ('$username','$password','$email','$site','$url','$description','$in','$out','$date','$ip')";
		mysql_query($insert) or die (mysql_error());
		echo '<div align="center" class="arial12b">Your site was successfully added.  Please place this link on your site: <b>http://top.filehunter.org/in.php?id='.$username.'</b></div>';
}

if (!$submit) {
	?>
	<form method="post" action="add.php">
	  <table width="335" border="0" cellpadding="3" cellspacing="0" class="list">
        <tr>
          <td height="21" colspan="4" bgcolor="#bd1515" class="arial0" style="border-bottom:0px;">Join FileHunter TopList... </td>
        </tr>
        <tr>
          <td colspan="3" class="arial12b" style="border-bottom:0px; border-right:0px;"><div align="center" class="arial12b">
            <div align="center">Username</div>
          </div></td>
          <td width="50%" style="border-bottom:0px;"><input name="username" type="text" class="arial12b" size="30" maxlength="30"></td>
        </tr>
        <tr>
          <td colspan="3" class="arial12b" style="border-bottom:0px; border-right:0px;"><div align="center">Password</div></td>
          <td width="50%" style="border-bottom:0px;"><input name="password" type="text" class="arial12b" size="30" maxlength="30"></td>
        </tr>
        <tr>
          <td colspan="3" class="arial12b" style="border-bottom:0px; border-right:0px;"><div align="center">Email</div></td>
          <td width="50%" style="border-bottom:0px;"><input name="email" type="text" class="arial12b" size="30" maxlength="30"></td>
        </tr>
        <tr>
          <td colspan="3" class="arial12b" style="border-bottom:0px; border-right:0px;"><div align="center">Site Name </div></td>
          <td width="50%" style="border-bottom:0px;"><input name="site" type="text" class="arial12b" size="30" maxlength="30"></td>
        </tr>
        <tr>
          <td colspan="3" class="arial12b" style="border-bottom:0px; border-right:0px;"><div align="center">Site URL </div></td>
          <td width="50%" style="border-bottom:0px;"><input name="url" type="text" class="arial12b" size="30" maxlength="30"></td>
        </tr>
        <tr>
          <td colspan="3" class="arial12b" style="border-bottom:0px; border-right:0px;"><div align="center">Short Description </div></td>
          <td width="50%" style="border-bottom:0px;"><input name="description" type="text" class="arial12b" size="30" maxlength="50"></td>
        </tr>
        <tr>
          <td height="20" colspan="4" bgcolor="#bd1515" class="arial0" style="border-top:0px;"><div align="center">
            <input name="submit" type="submit" class="arial12b" id="submit" value="Join Toplist">
          </div></td>
        </tr>
      </table>
      </form>
      <? } ?>
	</div></td>
</tr>
</table>
<!-- End ImageReady Slices -->
</body>
</html>

[Lars_Berg]

in and out are reserved words in SQL. Rename those columns

[kitchin]

IN is a reserved word. Use
in
or just backtick all of the identifiers.
http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html