Image popup from E-commerce store

[wizardworkz]

Hello All!

Having a bit of a problem combining php with javascript here. What I have is a store with images (There will be a smaller image of each item, and a larger image of each item, but I want users to click on a link under the image shown (Smaller image) for a popup window showing a larger image. I have already setup an additional table line named "image2" and want the image be puleed from the db (images folder) to pop up to a window that will default 20 pixels around the image.

Here is the script I placed in the head of the script:
PLEASE PUT YOUR CODE BETWEEN code TAGS NEXT TIME!!

<script language="javascript">
<!-- //Hide from old browsers.
 
//Make a pop-up window function
function create_window (image, width, height) {
 
    // Add some pixel dimensions here.
    width = width + 20;
    height = height + 40;
 
    // If the window is already open, resize it to the new dimensions.
    if (window.popup_window && !window.popup_window.closed) {
        window.popup_window.resizeTo (width, height);
        }
        //set the window properties
        var window_specs = "location=no, scrollbars=no, menubars=no, toolbars=no, resizable=yes,
        left=0, top=0, width=" + width + ", height=" + height;
 
        //Set the URL
        var url = "image_window.php?image=" + image;
 
        //Create the pop-up window.
        popup_window = window.open(url, "PictureWindow", window_specs);
        popup_window.focus();
 
} //End of function
//--></script>
 
OK, here is my php script on the store page:
 
<?php
 
require_once('mysql_connect.php');
if (isset($_GET['page'])) {
    $page = $_GET['page'];
} else {
    $page = 1;
}
$where = NULL;
$link = NULL;
$order = 'ItemID DESC';
 
if(isset($_GET['submit'])) {
    $order = $_GET['order'];
    if($_GET['category'] != '0') {
        $category = $_GET['category'];
        $where .= " AND CategoryID = '$category'";
        $vlink = "$page&category=$category&order=$order&submit=Search";
        $_SESSION['vlink'] = $vlink;
        $link = "&category=$category&order=$order&submit=Search";
    } else {
        $vlink = "$page&category=0&order=$order&submit=Search";
    }
    $_SESSION['vlink'] = $vlink;
}
?>
<table border="0" width="587"><tr><td width="18">&nbsp;</td><td width="559">
<form name="form1" method="get" action="">
  <table width="500" height="29" border="0" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC" bordercolordark="#000000">
    <tr> 
      <td width="57" height="27" align="right" nowrap><font size="2">Category:</font></td>
      <td width="140"><font size="2"> 
        <select name="category">
        <option value="0" selected>Choose a Category</option>
        <?php
        $u = NULL;
        $qu = mysql_query("SELECT I.CategoryID, C.Name FROM Items I, Category C WHERE I.CategoryID = C.CategoryID AND I.InUse = 'Yes' ORDER BY I.CategoryID");
        while($r = mysql_fetch_array($qu, MYSQL_NUM)) {
            if($r[0] != $u) {
                echo "<option value='$r[0]'>$r[1]</option>";
            }
            $u = $r[0];
        }
        ?>
        </select>
        </font></td>
      <td width="106" align="right" nowrap><font size="2">Order By:</font></td>
      <td width="98" nowrap><font size="2"> 
        <select name="order" id="select3">
          <option value="Name" selected>Name</option>
          <option value="Price">Price</option>
        </select>
        </font></td>
      <td width="83" align="right" nowrap><input name="submit" type="submit" id="submit2" value="Search"></td>
    </tr>
  </table>
</form>
<?php
$alt = 'first';
$page = $page-1;
$pag = $page*20;
$q = mysql_query ("SELECT ItemID FROM Items WHERE InUse = 'Yes'$where ORDER BY $order");
$query = mysql_query ("SELECT ItemID, Image, Name, Price, Sale, Description, Tax, Shipping, Image2, Inventory FROM Items WHERE InUse = 'Yes'$where ORDER BY $order LIMIT $pag, 20");
$n = mysql_num_rows($q);
$num = $n/20;
$num = ceil($num);
while($row = mysql_fetch_array($query, MYSQL_NUM)) {
    echo "<table width='550' border='1' cellspacing='0' cellpadding='2' bgcolor='#EFEFEF' bordercolor='#000000'>
              <tr> 
                <td width=80 rowspan='2'><img src='items/$row[1]' border=0>
             <strong><font size='1' face='Arial, Helvetica, sans-serif'>             
 
 
             <br> Click here for larger image. </br></font></strong>
             </td>
 
                <td><strong><font size='2' face='Arial, Helvetica, sans-serif'>Name: $row[2]</font></strong></td>";
               if ($row[4] != 'No') {
                  echo "<td><strong><font size='1' face='Arial, Helvetica, sans-serif' color='red'>Sale Price: $row[4]</font></strong></td>";
              } else {
                  echo "<td><strong><font size='1' face='Arial, Helvetica, sans-serif'>Price: $$row[3]</font></strong></td>";
             }
             echo "<td width=80 rowspan='2' align=center nowrap><a href='add_cart.php?pid=$row[0]'><font size='2' face='Arial, Helvetica, sans-serif'>Add to cart</font></a></td>
             </tr>
              <tr> 
                <td colspan='2' valign=top><font size='1' face='Arial, Helvetica, sans-serif'><strong>Description: $row[5]
              </strong></font></td>
              </tr>
        </table><br>";
}
echo "<font size=2>&lt;&lt;Prev ";
$a = 0;
while ($a < $num) {
    $a++;
    echo "<a href='index.php?page=$a$link'>$a</a>";
    if ($a != $num) {
        echo " - ";
    }
}
echo " Next&gt;&gt;</font>";
 
//<form target="paypal" action="https://www.paypal.com/cgi-bin/webscr" method="post">
//<input type="image" src="https://www.paypal.com/en_US/i/btn/x-click-but22.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
//<input type="hidden" name="add" value="1">
//<input type="hidden" name="cmd" value="_cart">
//<input type="hidden" name="business" value="[e-mail]">
//<input type="hidden" name="item_name" value="ItemName">
//<input type="hidden" name="item_number" value="ItemID">
//<input type="hidden" name="amount" value="1.00">
//<input type="hidden" name="no_note" value="1">
//<input type="hidden" name="currency_code" value="USD">
//<input type="hidden" name="lc" value="US">
//<input type="hidden" name="bn" value="PP-ShopCartBF">
//</form>
?>
 

PLEASE PUT YOUR CODE BETWEEN [code] TAGS NEXT TIME!!

Any suggestions would be greatly appreciated! Thanks...