[SOLVED] can you spot the not?

[coder9]

hi

 

can you see any problem with this codes below?

$query = "SELECT * FROM jwinners WHERE gsid='1'";
$result = mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());
$row = mysql_fetch_row($result);

$username = $row[username];

echo "user:  ".$username;

 

i used it and it run without an error and it show no value at all

 

any help or advice please?

 

thank you.

 

 

[MasterACE14]

change this...

$row = mysql_fetch_row($result);

 

to either this:

$row = mysql_fetch_assoc($result);

or this:

$row = mysql_fetch_array($result);

 

either one should work.

[coder9]

thank you.

[MasterACE14]

click "Topic Solved" button, bottom left of this post 

 

and no problem. Glad I could help.

 

ACE