I have a category on my site. The range in a particular category is also available in two other categories. I need a link to say "Also available in Category1 (5 items) and Category3 (1 item)" dynamically. At the moment I have it working from form entry which is saved in database and then outputted by me but I've noticed the links are the same on each page (even if you're on the page with Category3, the link will say Category1 and Category3) and i'd like these randomized so the current link displaying is not included in the link on the page. Make sense? :s
This is what Im doing at the moment:
CODE
$result2=mysql("$DBName","SELECT * FROM range");
while($row2=mysql_fetch_row($result2)){
$rid = $row2[0];
$range=$row2[1];
$details=$row2[2];
$availablelink1=$row2[5];
$availablelinktitle1=$row2[6];
$itemsfromlink1=$row2[7];
$availablelink2=$row2[8];
$availablelinktitle2=$row2[9];
$itemsfromlink2=$row2[10];
if ( $itemsfromlink1 == 1) { $itemfromlink1 = $itemsfromlink1 . ' item'; } else { $itemfromlink1 = $itemsfromlink1 . ' items'; }
if ( $itemsfromlink2 == 1) { $itemfromlink2 = $itemsfromlink2 . ' item'; } else { $itemfromlink2 = $itemsfromlink2 . ' items'; }
if ( $availablelink2 && $availablelinktitle2 && $itemsfromlink2 == '' && $availablelink1 && $availablelinktitle1 && $itemsfromlink1 != '')
{ echo "<p>Also available for <a href=\"$availablelink1\">$availablelinktitle1 ($itemfromlink1)</a>"; }
if ( $availablelink1 && $availablelinktitle1 && $itemsfromlink1 && $availablelink2 && $availablelinktitle2 && $itemsfromlink2 != '')
{ echo "<p>Also available for <a href=\"$availablelink1\">$availablelinktitle1 ($itemfromlink1)</a> and <a href=\"$availablelink2\">$availablelinktitle2 ($itemfromlink2)</a></p>"; }
echo "</div></div>";
| 