MySQL Insert not working

necrotic posted this at 02:18 — 10th October 2002.

Joined: May 2002

I am trying to insert into a mysql db, which I've done a million times before, but it won't work this time! I've tried everything I can think of a million times over!

code snippet:

<?php
      $password = md5($password);
      mysql_query(\"INSERT INTO `$db[pre]users` (`id`, `username` , `password` , `email` , `aim` , `icq` , `msn` , `active` , `wesbsite` , `userlevel` , `comments` ) VALUES ('', '$username', '$password', '$email', '', '0', '', '1', 'http://', '1', '0')\");
?>

I also tried:

<?php
      $password = md5($password);
      mysql_query(\"INSERT INTO `$db[pre]users` (`username` , `password` , `email`, `active`, `userlevel`) VALUES ('$username', '$password', '$email', '1', '1')\");
?>