Am stuck with SELECT FROM , WHERE

nonlinear

Hey ppl
I'm really in a dreadfull situation.. i got my submissions tomorrow.. and my brain seems to be off now.... i have a database called test and table called user.
user table has all possible stuff like userid, username, upass, fname and etc.... i need to use SELECT query to display userid in one corner, fname in other... how do i do this... its seriously urgent.....
thanks

laserlight

Well, quite obviously your query would be something like:

SELECT userid, fname FROM user;

What have you tried? If you have not tried anything up to this late hour, then yes, you deserve to fail.

nonlinear

laserlight wrote:
What have you tried? If you have not tried anything up to this late hour, then yes, you deserve to fail.

That was morally discouraging to hear those words. Well it was my mistake of expecting to get something solved here without posting the query fully, that i gave a chance for you to say that. well try figuring out whats wrong in this piece of code..... it was this which made me go uhmmm after 4 yrs of getting my hands dirty with PHP and MySQL

<?php
include "init.php";
$query = "SELECT uname, upass, fname FROM user WHERE uname= xyz";
$result = mysql_query($query);
echo $result['uname'];
echo $result['upass'];
echo $result['fname'];
?>

there are no errors displayed as such..in fact nothin is displayed.. and btw, consider that there exists an entry for "uname =xyz"

Thanks in advance for your comments....

laserlight

You would need to enclose xyz in single quotes if it is a value rather than an identifier. You need to use [man]mysql_fetch_assoc/man on the result resource in order to get an array that you can use.

<?php
include "init.php";
$query = "SELECT uname, upass, fname FROM user WHERE uname='xyz'";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
echo $row['uname'];
echo $row['upass'];
echo $row['fname'];
?>