i have a gallery SCript which i saw in tutorial sitepoint.com
everything is working well except that i want to limit users,which means the albums will be opening accoding to user=name
WHERE SHOULD I PUT THE WHERE CLAUSE LIKE THIS user='$user'
in the script below.
query( "SELECT c.category_id,c.category_name,photo_filename,COUNT(photo_id) FROM gallery_category as c LEFT JOIN gallery_photos as p ON p.photo_category = c.category_id GROUP BY c.category_id" );
here is the link of the tutorial,any help will be appreciated.