Re: one click - two actions?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux