The WHERE clause value has to be in single quotes: I usually try to keep my query separate from where I run it. You might also want to look into a good MySQL class for your db interaction...makes it *so* much easier. $q = "SELECT pic FROM users WHERE author = '".$author[author]."'"; $result = mysql_query( $q ); Aloha, John PS - I have a *really good* PHP tip I'm saving for when I really need one...go ahead, provoke me ;) > -----Original Message----- > From: thelist-admin at lists.evolt.org > [mailto:thelist-admin at lists.evolt.org] On Behalf Of Razzak Jallow > Sent: Monday, January 20, 2003 3:19 PM > To: thelist at lists.evolt.org > Subject: [thelist] PHP and MySQL Multiple Query/Array > > > Hey all. I've been fuming over this for a long time now and > am hoping someone can shed some light on it, because I'm > amazingly stuck. I'm trying to get information from two > tables on the same database, but keep getting an error in the > two lines after //select pic. Any help is greatly > appreciated. I've tried messing with $author[author] and > changing it to an absolute value such as `Bill` but no luck. > > > $db = "gridiron"; > $user = "----"; > $pass = "----"; > > $link = mysql_connect( "localhost", $user, $pass ); > if ( ! $link ) > die( "Couldn't connect to MySQL" ); > mysql_select_db( $db, $link ) > or die ( "Couldn't open $db: ".mysql_error() ); > $result = mysql_query( "SELECT author FROM > articles where submitdt = $id" ); > $author = mysql_fetch_array( $result, MYSQL_ASSOC ); > > //select pic > $result = mysql_query( "SELECT pic FROM users > where author = > $author[author]"); $pic = mysql_fetch_array( > $result, MYSQL_ASSOC ); > > //html it > print '<div align="center"><img > src="../images/profilepics/'.$pic["pic"].'" > alt="'.$author["author"].'" width="88" height="76" border="0"></div>'; > > -- > * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !