Jump to content

Nothing too complicated I guess...HELP!


Penders

Recommended Posts

Hi!

 

I`m trying to make a photo gallery website. I`m trying to echo galleries and images that are only to specific user_id, (SESSION user_id)

 

I found this query and I can`t figure out how to connect it with user_id. Please help!

 

 

$query=" select distinct(images.gal_id),img_name, gname,img_id  from images,  gallery where images.gal_id=gallery.gal_id group by images.gal_id order by gal_id desc limit $eu,$limit";
 
$query2=" select distinct(images.gal_id),img_name, gname,img_id  from images,  gallery where images.gal_id=gallery.gal_id group by images.gal_id order by gal_id ";
 
 
 
Thank You!
Link to comment
Share on other sites

Could be because galI_id in the ORDER BY is ambiguous and I put the WHERE after ORDER (Ooops!)

Try

SELECT 
    gallery.gal_id
    , gname
    , img_id  
    , img_name
FROM 
    gallery
INNER JOIN
    images ON images.gal_id=gallery.gal_id 
WHERE gallery.user_id = $whatever 
ORDER BY gallery.gal_id DESC
LIMIT $eu,$limit
Edited by Barand
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.