MySQL help

[Macemore]

I have a form and it posts some one's username (give through form) to this:

<?php
$user = $_POST['usre'];
$con = mysql_connect("localhost","u240887943_use","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("u240887943_use", $con);

mysql_query("INSERT INTO users (user)
VALUES ($user)");
mysql_close($con);
echo 'totally worked';
?>

but nothing ends up in my table! I'm not getting connection issues because there's no error. so I'm guessing it's something with tables.
Could you set up a SQL file that I can run in my database and see if that works? ;<

help please

 

[Ept]

<?php
$user = $_POST['usre'];
$con = mysql_connect("localhost","u240887943_use","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("u240887943_use", $con);
 
mysql_query("INSERT INTO users (user)
VALUES ('$user')");
mysql_close($con);
echo 'totally worked';
?>

Try that.

 

[Macemore]

<?php
$user = $_POST['usre'];
$con = mysql_connect("localhost","u240887943_use","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("u240887943_use", $con);
 
mysql_query("INSERT INTO users (user)
VALUES ('$user')");
mysql_close($con);
echo 'totally worked';
?>

Try that.

THAT WORKED!
yaaay, what'd you change?

 

[Ept]

I changed

 ($user)

to

 ('$user')

 

[XenPHP]

Next time, after a query, just make it die. This way, you can get the actual error, and it will be a whole lot easier, and one less help thread on DevBest. For example...

mysql_query("UPDATE users SET username = '$user' WHERE id = '1'") or die(mysql_error());

 

[Macemore]

Next time, after a query, just make it die. This way, you can get the actual error, and it will be a whole lot easier, and one less help thread on DevBest. For example...

mysql_query("UPDATE users SET username = '$user' WHERE id = '1'") or die(mysql_error());

Thanks, I started SQL today so ;d

 

[XenPHP]

Thanks, I started SQL today so ;d

Haha, no problem! Just letting you know, as it will really help in certain situations (no internet )