Hi, I am trying to create a tabbed image gallery using php and mysql . The following are my table structure. CREATE TABLE IF NOT EXISTS `gallery_category` ( `category_id` int(11) NOT NULL auto_increment, `category_name` text NOT NULL, PRIMARY KEY (`category_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; CREATE TABLE IF NOT EXISTS `photos` ( `photo_id` int(20) NOT NULL auto_increment, `photo_filename` varchar(25) NOT NULL, `photo_caption` text NOT NULL, `photo_category` bigint(20) NOT NULL, PRIMARY KEY (`photo_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ; I am tring to create a tabbed gallery like this. <ul class="tabs"> <li><a href="#" rel="view1">gallery1</a></li> <li><a href="#" rel="view2">gallery2</a></li> </ul> <div class="tabcontents"> <div id="view1" class="tabcontent"> Gallery1 images goes here. </div> <div id="view2" class="tabcontent"> Gallery2 images goes here. </div> </div> Here is my code which i am trying to make this work. <ul class="tabs"> <?php $sql = "SELECT * FROM category ORDER BY category_id ASC"; $query = mysql_query($sql); while($row = mysql_fetch_array($query)) { $cid = $row['category_id']; $category_name = $row['category_name']; echo "<li><a href='?catid=".$cid."' rel='view".$cid."'>$category_name</a></li> "; } echo "</ul>"; ?> <div class="tabcontents"> <?php $sql = "SELECT * FROM category ORDER BY category_id ASC"; $query = mysql_query($sql); while($row = mysql_fetch_array($query)) { $catid = $row['category_id']; $category_name = $row['category_name']; $count = $row['COUNT(photo_id)']; echo"<div id='view".$catid."' class='tabcontent'>"; $catid = (int)($_GET['catid']); $sql = "SELECT * FROM gallery_photos WHERE photo_category = $catid ORDER BY photo_id DESC"; $query = mysql_query($sql); while($row = mysql_fetch_array($query)) { $pid = $row['photo_id']; $photo_caption = $row['photo_caption']; $photo_filename = $row['photo_filename']; echo "$photo_caption</br>"; echo "<img src='".$images_dir."/tb_".$row[photo_filename]."' border='0'"; } } ?> </div> </div> The category is displaying correctly (first <ul> </ul> part) but it content display part is not working. Can any one please help me with this.. Thanks, Sam.

Jump to content

Existing user? Sign In
Sign In

Remember me Not recommended on shared computers

Forgot your password?
Sign Up

Browse
- Forums
- Staff
- Leaderboard
- Guidelines
- Terms of Service
- More
Activity
- All Activity
- Search
- More
Join our Discord!
More
- More

PHP Coding Help

Tabbed image gallery problem

By sam123
January 14, 2013 in PHP Coding Help

Share

https://forums.phpfreaks.com/topic/273138-tabbed-image-gallery-problem/

Followers 0

Join the conversation

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

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.

Insert image from URL

×

Share

https://forums.phpfreaks.com/topic/273138-tabbed-image-gallery-problem/

Followers 0

Go to topic listing

×

Browse
- Back
- Forums
- Staff
- Leaderboard
- Guidelines
- Terms of Service
Activity
- Back
- All Activity
- Search
Join our Discord!

×

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.

Sign In

Tabbed image gallery problem

Recommended Posts

sam123

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information