-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Not to be rude or anything, but if you want to do two things with one click, wouldn't the javascript list be the place you would want to go? Mel wrote: > Could someone please help me figure out how to show some description > (where applicable) at the same time as I show an image, when I click on > a link, without repeating the entire query? > The image and the description are both in the same table in my database. > > I now show the image when I click on the link which is good, but the > description stays on at all times instead of appearing only when active. > > http://www.squareinch.net/single_page.php > > This is the code I have for the image area: > /* query 1 from client */ > $query = "SELECT * FROM client > where status='active' or status='old' > order by companyName"; > > $result = mysql_query($query) > or die ("Couldn't execute query"); > > while ($aaa = mysql_fetch_array($result,MYSQL_ASSOC)) > { > echo "<span class='navCompany'>{$aaa['companyName']}</span><span > class='navArrow'> > </span>\n"; > > /* query 2 from job */ > $query = "SELECT * FROM job > WHERE companyId='{$aaa['companyId']}'"; > $result2 = mysql_query($query) > or die ("Couldn't execute query2"); > > foreach($aaa as $jobType) > { > $bbb = mysql_fetch_array($result2,MYSQL_ASSOC); > echo "<span class='navText'><a > href='single_page.php?art=".$bbb['pix']."'>{$bbb['jobType']}</a></span>\n"; > } > echo "<br>"; > } > ?> > > </div> > > > <div class="navbox3"><?php $image = $_GET['art']; ?> > <img src="images/<?php print ($image) ?>" alt="Portfolio > Item" border="0" width="285" height="285"></div> > > > This is the code I have for the description area: > > /* query 1 from client */ > $query = "SELECT * FROM client > where status='active' or status='old' > order by companyName"; > > $result = mysql_query($query) > or die ("Couldn't execute query"); > > while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) > { > > /* query 2 from job */ > $query = "SELECT * FROM job > WHERE companyId='{$row['companyId']}'"; > $result2 = mysql_query($query) > or die ("Couldn't execute query2"); > $url = mysql_query($result2); > > foreach($row as $url) > { > $row = mysql_fetch_array($result2,MYSQL_ASSOC); > if ("url={$row['url']}") > echo "<span class='navText'><a > href='{$row['url']}'>{$row['web']}</a></span>"; > } > > echo "<br>"; > } > ?> > > > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFFWGE2bHd4gglFmoARAnNWAJ0fs+NHm5MbNwDpm3E7Flu3giU+LQCgkF7O uCu6zhUFfviNC+aaxpNy+Vg= =NQVC -----END PGP SIGNATURE----- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
