Ok thanks for that info, but I guess I am ignorant to what MS Access is.
Please enlighten me.


Thanks
Jennifer Downey


"Marius Ursache" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED].;
> 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_/
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to