PLS HELP!!! query syntax problem

[l_evans]

//$username is the entry from a textfield

im trying to get all values from a table where the '$username' >in the form is equal to the user name in my table. my query >looks like the following:

$username = $_POST['username_form'];

$getfname = mysql_query("SELECT fname FROM identity WHERE $username = identity.username");

$insertquery = "INSERT INTO problems(id_num,fname,lname,contact,phone_num,problm,resolution)
VALUES(1,'$getfname','$getlname','$getcontact','$getphone','$problem','$resolution')";

but when i go to print the values out in a table the values the output is resource id #2. i know for sure it is a problem with the query.

thanks for any help

Lee

[barand]

A couple of problems here.

because username is text, it needs single quotes round it in the query, plus it's more usual to hav field = criteria.

Also mysql_query returns a result resource, hence you problem with the contents.

$result = mysql_query("SELECT fname FROM identity WHERE identity.username = '$username' "); 

if ($row = mysql_fetch_array($result)) {
  $getfname = $row['fname'];
}
else {
  echo "No record found<br>";
}

hth

[l_evans]

man thanks a lot! it worked......

peace🙂