SQL problem

[pinehead18]

function sign_up() {

  $uname = $uname; 

   $db = mysql_select_db("pinehead", $con);
        $sql = mysql_query("INSERT INTO users (uname) VALUES ('$uname')",$con)
or die(mysql_error());

    echo mysql_error();

    mysql_close();



}

OK, this is being really stupid.. It submits a blank line into the db. But when i set $uname = "HI"; it submits high, Yet it wont submit $uname.. Even when i set $uname = $uname. I tell the page to echo $uname and it does ehco it just fine. WTF is goin on?

[Sxooter]

Originally posted by pinehead18

function sign_up() {
  global $uname;  # <- ADD THIS
  global $con; # <- ADD THIS
  $uname = $uname;  # <- DELETE THIS

   $db = mysql_select_db("pinehead", $con);
        $sql = mysql_query("INSERT INTO users (uname) VALUES ('$uname')",$con)
or die(mysql_error());

    echo mysql_error();

    mysql_close();  # <- REMOVE THIS.  If you aren't opening mysql in this function, don't close it here.



}

OK, this is being really stupid.. It submits a blank line into the db. But when i set $uname = "HI"; it submits high, Yet it wont submit $uname.. Even when i set $uname = $uname. I tell the page to echo $uname and it does ehco it just fine. WTF is goin on? [/B]