mysql help

[joecooper]

Hi, used to be very skilled with php a while back but my brain has failed me!

 

all i want to do is have $funds be the value of the funs field from the table users where the user is $username.

 

help please.

[rarebit]

Not much to go on there!

 

$s = "SELECT * FROM users";
$res = mysql_query($s, $conn) or die(mysql_error());

$num_rows = mysql_num_rows($res);

while ($a = mysql_fetch_array($res))
{
$funds = $a['funds'];
}

 

or

 

$s = "SELECT * FROM users";
$res = mysql_query($s, $conn) or die(mysql_error());

$num_rows = mysql_num_rows($res);
if($num_rows==1)
{
$a = mysql_fetch_array($res)
$funds = $a['funds'];
}

[joecooper]

i have had some to drink so now is probally not the best time for me to try coding...

 

but what you said i think is wrong... this is what im trying but not working

 

 

$sql = "SELECT * FROM users WHERE username=$username";

$result = mysql_query($sql);

$funds=$result['funds'];

  echo("Funds: $funds");

[rarebit]

your missing the...

$a = mysql_fetch_array($res)

...bit!

[joecooper]

ahhh i tried what you said exactly and it returned nothing

 

 

im going out now. will come back to this stupid mysql thing tomorrow.. when sober