quick PHP Help

[denby]

hi


can anyone shed any light on why this query does not work?

$result=mysql_query("SELECT uid FROM users WHERE username='$_POST[username]' ");

$end = mysql_result($result);

echo $end;

'$_POST[username]' is being sent by the previous page


thanks

 

[denby]

hi


that code just gives me a blank page


but when i do this i get the username from the previous page ,

$usrnme = $_SESSION['username'];
echo $usrnme;

im now just trying to get the uid that relates to the username in this case the uid is "1"

 

[denby]

Did you make a connection?

for example:

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');

You can check for an error with

mysql_error()

Yeah i have included the file that handles the connection

 

[denby]

ok so ,the whole query looks like this now

$r=mysql_query("SELECT uid FROM users WHERE username='{$_POST['username']}'");
$last = mysql_fetch_array($r); 
echo ($last);

but still shows nothing on the page

what could be wrong

thanks