Hi Jennifer. Change {$session["uid"]} to {$session['uid']} --> double quotes to single quotes. It's inside a set of single quotes already, so you have to use double quotes.
/bsh/ Jennifer Downey wrote: >Hi all, > >I'm really stuck and I'm not asking anyone to re-write this just show me what is >wrong, or explain why it wont work. It just seems logical that this should work. > >The first query will print the pet id in the browser. > >$query="SELECT id FROM wt_users WHERE uid={$session["uid"]}"; >$ret = mysql_query($query); >while(list($pet)= >mysql_fetch_row($ret)) >print("<BR>your pet id is $pet"); > >So if $pet will print the id from the wt_users (has a value of 3) and I assign $id = >$pet (id also has a value of 3 in image_data) why doesn't it show the image? > >if($id) { > > >$id = $pet; > $query = "select bin_data,filetype from image_data where id=$id"; > > $result = mysql_query($query); > > $data = mysql_query($result,0,"bin_data"); > $type = mysql_query($result,0,"filetype"); > > Header( "Content-type: $type"); > echo $data; > >}; >echo "<img src=\"petdata.php?id=$id\">"; > >Thanks >Jennifer Downey > -- /---------------------------------------------=[ BILLY S HALSEY ]=--\ | Member of Technical Staff - Sun Microsystems, Inc. | | ESP Solaris Software - Software Problem Resolution Team | | "No day but today." - J. Larson, RENT x55403/858-526-9403 | \--=[ [EMAIL PROTECTED] ]=------------------------------------------------/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php