[RESOLVED] How to list only links that do not match current product ID

[dmacman1962]

Hi again,

I have a code snippet that list the links for all the products in a category (5 items, with product IDs 1-5 respectively).

Here is the code that shows all the items and works great:

<?PHP 
 $sql2 = "Select prodName, prodID, prodGroup from tblProduct Where prodType='Video' ORDER BY prodName ASC";  

    $result2 = mysql_query($sql2);
	while($row2=mysql_fetch_array($result2)){
   echo "<a href=\"http://www.intheclassroom.org/noFrames/products/product.php?prodID=".$row2['prodID']."\">".$row2['prodName']."</a>"; 
	echo "<br>";
}  

?>

What I am trying to change is if you are on products 1 page, that the it does not list that in the above code.

IE,

( this is the prodID number, and it does not display the ID) then product Description.
1 Apples
2 Oranges

So when I am on the "apples" page it lists all the other products but not the text and link for apples.

Does that make sense??

Thanks,

Don

[thorpe]

maybe im mssing something... but could it be as simple as?

SELECT ProdID, prodName FROM products WHERE prodID <> 1

hope this helps.

[dmacman1962]

Sort of...

What I want is when the user is on product 3's page, I want the links to reflect IDs 1, 2, 4, 5.

When they are on product 1s page, I want the links to reflect IDs 2, 3, 4, 5.

So what I need is sort of:

Select prodName, prodID, prodGroup from tblProduct Where prodType='Video' AND prodID !=currentprodID ORDER BY prodName ASC

Does that help?

Thanks,
Don

[marshallm]

Does that query not work?

Of course, you need the PHP variable name in there, like this:

$query = "Select prodName, prodID, prodGroup from tblProduct Where prodType='Video' AND prodID !=". $currentprodID ." ORDER BY prodName ASC";

[dmacman1962]

Thanks, that worked PERFECTLY.

I appreciate the help,

Don