Looking for a little assistance in understanding what I am missing!
Using PHP/MySql to allow users to browse through items in a gallery. Clicking 'next' and 'previous' links works fine using the item ID number to sequentially see all items.
Trouble arises when category and ID variables are passed. I'm thoroughly confused on how to let the user click a 'next' link after they have entered a category page in order to see the next item in that category. The "elseif ($ID AND $cat)" statement is the offending code. Here's my script if anyone can make suggestions. Thanks in advance for any help!
<?php
// Check the database for correct authorization.
$host = "xx;
$user = "xx";
$password = "xx";
$db = "soaps";
mysql_connect ($host, $user, $password) or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("soaps") or die ("Could not select database");
$all = mysql_query("SE LECT * FROM soap_inventory" ) or die ("Query failed here");
$allpix = mysql_num_rows( $all);
if (isset($_GET['ID'])) {
$ID = $_GET['ID'];
} else {
$ID = "";
}
if (isset($_GET['category'])) {
$cat = $_GET['category'];
} else {
$cat = "";
}
if ($ID AND !$cat) {
//show single soap if user clicks on a picture (THIS WORKS OK)
$sql = mysql_query("SE LECT * FROM soap_inventory WHERE ID=$ID");
$row = mysql_fetch_arr ay($sql);
echo "<img class='thumb' src='images/$row[ID].jpg' width='400px' alt='$row[Name]'><br />";
echo "<br /><strong>$row[Name]</strong><br /><br />";
echo "$ $ro w[Price]<br /><br />";
echo "$row[PayPal_ADD_butt on]<br /><br />";
echo "$row[PayPal_VIEW_but ton]<br /><br />";
$IDpre = 0;
$IDnex = 0;//echo "$ID . $IDpre . $IDnex . $allpix";
if ($ID==1) {$IDpre = $allpix;$IDnex= $ID+1;}
elseif ($ID==$allpix) {$IDnex=1;$IDpr e=$ID-1;}
else {$IDnex=$ID+1;$ IDpre = $ID-1;}
//echo "<br />$ID . $IDpre . $IDnex . $allpix";
echo "<div class='clear'>& nbsp;</div>";
echo "<div class='catnav'> ";
echo "<a href='soap_cata log.php?ID=$IDp re'><<< Previous</a>";
echo "<a href='soap_cata log.php'>Soap Catalog</a>";
echo "<a href='soap_cata log.php?ID=$IDn ex'>Next >>></a>";
echo "</div>";
}
elseif ($ID AND $cat) {
//(TROUBLE SPOT - NEXT/PREVIOUS LINKS DO NOT WORK)
$sql = mysql_query("SE LECT soap_inventory. ID, soap_inventory. Name, soap_inventory. Price FROM soap_inventory, soap_category, soap_cat_lookup WHERE soapid=soap_inv entory.ID AND categoryid=soap _category.ID AND categoryid=$cat AND Active=1");
$IDcat = mysql_fetch_arr ay($sql);
$IDrow = $IDcat;
$allpic = mysql_num_rows( $sql);
echo "<img class='thumb' src='images/$IDrow[soapid].jpg' width='400px' alt='$IDrow[Name]'><br />";
echo "<br /><strong>$IDr ow[Name]</strong><br /><br />";
echo "$ $ID row[Price]<br /><br />";
echo "<div class='clear'>& nbsp;</div>";
echo "<div class='catnav'> ";
echo "<a href='soap_cata log.php?ID=$IDr ow[0]&category=$cat' >First</a>";
echo "<a href='soap_cata log.php'>Soap Catalog</a>";
echo "<a href='soap_cata log.php?ID=($ID row[0]+1)&category=$c at'>Next </a>";
echo "</div>";
}
elseif ($cat AND !$ID){
//show soaps in category if user clicks on a link in left column (THIS IS OK)
$sql = mysql_query("SE LECT * FROM soap_inventory, soap_category, soap_cat_lookup WHERE soapid=soap_inv entory.ID AND categoryid=soap _category.ID AND categoryid=$cat AND Active=1");
while ($cats = mysql_fetch_arr ay($sql)) {
echo "<div class='thumb'>< a href='soap_cata log.php?ID=$cat s[soapid]&category=$cat' ><img class='thumb' src='thumbs/$cats[soapid]-s.jpg' alt='$cats[Name]' width='150px'></a><div class='clear'>& nbsp;</div><h5>$cats[Name]</h5><br />$$cats[Price]<br /><br /></div>";
}
echo "<div class='clear'>& nbsp;</div><a href='soap_cata log.php'>Back to Soaps Catalog</a>";
}
else {
//show complete soap catalog listing (THIS IS OK)
// Select the table to query
$result = mysql_query("SE LECT * FROM soap_inventory WHERE Active=1") or die ("Query failed here");
while ($res = mysql_fetch_arr ay($result)) {
echo "<div class='thumb'>< a href='soap_cata log.php?ID=$res[ID]'><img class='thumb' src='thumbs/$res[ID]-s.jpg' alt='$res[Name]' width='150px'></a><div class='clear'>& nbsp;</div><h5>$res[Name]</h5><br />$$res[Price]<br /><br /></div>";
}
echo "<div class='clear'>& nbsp;</div>";
}
?>