[SOLVED] Fetch data and display

[daveoffy]

First off my task is to fetch a 5 digit number from my database that got uploaded when users upload a picture so the picture name is in the database.

 

$row = mysql_fetch_array("SELECT picture_id from picture WHERE member_id = '{$_SESSION['SESS_MEMBER_ID']}'");
$abcd= $row['picture_id'];	
if (isset($_SESSION['SESS_MEMBER_ID'])) {  
    echo '<img src="/uploads/users/'.$abcd.'">';
}
else { BLAH BLAH NOT NEEDED }

 

I have connecting to database right but pulling data I don't. Table is picture, in table there is member_id and picture_id. The picture_id is what I want to display after /users/ so it displays their picture. Any questions about what I am asking just reply.

[delickate]

just change ur Query like

 

$row = mysql_fetch_array("SELECT * from picture WHERE member_id = '{$_SESSION['SESS_MEMBER_ID']}'");

$abcd= $row['picture_id']; 

if (isset($_SESSION['SESS_MEMBER_ID'])) {

    echo '<img src="/uploads/users/'.$abcd.'">';

}

  else { BLAH BLAH NOT NEEDED }

[daveoffy]

That didn't work... I don't know what is going wrong.

[The Little Guy]

Try this:

 

$sql = mysql_query("SELECT * from picture WHERE member_id = '{$_SESSION['SESS_MEMBER_ID']}'");
$row = mysql_fetch_array($sql);

[daveoffy]

Thanks, it took a little while for me to get it working but I got it.