Using dynamic urls to populate jquery slideshow
<p>I am trying to dynamically populate a jquery slideshow using dynamic urls. The way this theoretically should work is the list with the images will contain dynamic links instead of the standard static links. So instead of having example.com/pics/specificpicture.jpg it would be example.com/pics/id?id=[this is what I don't know what to put]... the primary issue besides not knowing what to put there is that not only do I not know what to do to make a dynamic url, I also don't know how to make a list work proper. To explain, the jquery slideshow carousel I am using will have 6 images displaying at once, moving to the left every five seconds with the last picture being taken off to put a new picture on, so how would I keep the images from going in order, and thus each list would repeat images that another image already displayed?</p>

<p><strong>EDIT</strong> this is some code very similar to what I am trying to do </p>

<p><strong>PHP</strong></p>

<pre><code>&lt;?php 
// Run a select query to get my letest 6 items
// Connect to the MySQL database  
include "storescripts/connect_to_mysql.php"; 
$dynamicList = "";
$sql = mysql_query("SELECT * FROM products ORDER BY date_added DESC LIMIT 6");
$productCount = mysql_num_rows($sql); // count the output amount
if ($productCount &gt; 0) {
    while($row = mysql_fetch_array($sql)){ 
             $id = $row["id"];
             $product_name = $row["product_name"];
             $price = $row["price"];
             $date_added = strftime("%b %d, %Y", strtotime($row["date_added"]));
             $dynamicList .= '&lt;table width="100%" border="0" cellspacing="0" cellpadding="6"&gt;
        &lt;tr&gt;
          &lt;td width="17%" valign="top"&gt;&lt;a href="product.php?id=' . $id . '"&gt;&lt;img style="border:#666 1px solid;" src="inventory_images/' . $id . '.jpg" alt="' . $product_name . '" width="77" height="102" border="1" /&gt;&lt;/a&gt;&lt;/td&gt;
          &lt;td width="83%" valign="top"&gt;' . $product_name . '&lt;br /&gt;
            $' . $price . '&lt;br /&gt;
            &lt;a href="product.php?id=' . $id . '"&gt;View Product Details&lt;/a&gt;&lt;/td&gt;
        &lt;/tr&gt;
      &lt;/table&gt;';
    }
} else {
    $dynamicList = "We have no products listed in our store yet";
}
mysql_close();
?&gt;
</code></pre>

<p><strong>HTML</strong></p>

<pre><code>  ...&lt;td width="35%" valign="top"&gt;&lt;h3&gt;Title&lt;/h3&gt;
      &lt;p&gt;&lt;?php echo $dynamicList; ?&gt;&lt;br /&gt;
        &lt;/p&gt;
      &lt;p&gt;&lt;br /&gt;
      &lt;/p&gt;&lt;/td&gt;...
</code></pre>

<p>This is from developphp.com, basically how this is echoing a dynamic list, what I am trying to to is similarly echo a list, but with the 6 dynamic urls... even if I could do random images (which would not be near as productive as desired) i'd be thankful to have that much up there for now :/</p>
