Selecting Featured Merchants Query

swattle

I am having difficulties figuring out my error. I am new to PHP. My site http://www.swattle.com I am trying to add a featured merchants list and display an image which links to the merchant. I first tried using the code

<?php 
		  if ($row_FeaturedMerchant['featured_merchant'] = 1)
		  		{
		  			echo '<img src="' . $row_FeaturedMerchant['MerchantLogo'] . '"></img>';
		  		}
?>

This worked but only selected the first row it encountered that had the field featured_merchant = 1

So next I tried a while statment. That only seemed to display an infinite loop of the first record it encountered that was a featured merchant. Is there anyone who can help with this limited info?

justsomeone

 
if ($row_FeaturedMerchant['featured_merchant'] = 1)

This is almost certainly wrong. Should you have two equals signs in there? Having just one assigns a value of 1 to the variable rather than testing its current value. This would explain why it only shows the merchant with an id of 1.

swattle

Originally posted by justsomeone
 
if ($row_FeaturedMerchant['featured_merchant'] = 1)
This is almost certainly wrong. Should you have two equals signs in there? Having just one assigns a value of 1 to the variable rather than testing its current value. This would explain why it only shows the merchant with an id of 1. [/B]

No I had it with == (typo) I just can't get it to move to the next row. If a merchant is featured it has a value of 1 in the db and 0 if it's not a featured merchant.

justsomeone

Originally posted by swattle
No I had it with == (typo) I just can't get it to move to the next row. If a merchant is featured it has a value of 1 in the db and 0 if it's not a featured merchant.

By having just one equals in there, you are setting the value of the variable to 1, not checking if it is already equal to 1.

There is nothing in your code snippet to loop through the merchants. There is nothing in your code snippet to load the array.

You need to send a select query to the database, where featured_merchant = 1. (MySQL uses just one equals for a comparison). This will then set up an array of return values for you to loop through, printing any fields you want.

For a good example of what you need to be doing, check out the first example on this page:
http://www.php.net/manual/en/ref.mysql.php