Re: Join tables

Ok thanks for that info, but I guess I am ignorant to what MS Access is. Please enlighten me. Thanks Jennifer Downey "Marius Ursache" <marius.ursache@tm.cit.alcatel.fr> wrote in message news:3C7DFB13.FFA8797B@tm.cit.alcatel.fr... > the best tool for building "join" queries is MS Access . > > make a db same as that you use in mysql and build the query with access. then copy/paste queries from there. > > to build queries in access is very simple . drag/drop and other visual ways. > > > Jennifer Downey a écrit : > > > Hi all, > > > > Ok first I have figured out my question on storing an image path. > > > > my question now is on joining data from two tables. > > > > wt_users has two fields (cols) called > > uid and pid, > > uid refers to the user > > pid refers to the users pet > > > > image_data has a field called > > id which refers to the image path > > > > id in image_data has the same value as id in wt_users > > 1 1 > > > > These two queries are what are needed to get the image to display: > > $pet = mysql_query("select id from wt_users where uid={$session["uid"]}"); > > $ret = mysql_query($pet); > > > > $query = "select binary_data,filetype from image_data where id=$id"; > > $result = @mysql_query($query); > > > > I'm using echo "<img src=\"petdata.php?id= this should correspond with both id's \">"; to display the image > > > > how do I join the two tables so that the id's match and give the correct image? > > > > And again thanks in advance for your help > > Regards > > Jennifer Downey > > > > P.S. I have looked at the mysql manual and a few tutorials. None of them helped or worked. > > -- > Marius Ursache (3563 || 3494) > > \|/ ____ \|/ > "@'/ ,. \`@" > /_| \__/ |_\ > \__U_/ > >