Inserting Variable Text

[raouleduke]

I am running a query, and as per the query I am trying to print different text for each record based upon the query. I seem to work on some of them but not all, am I doing this right. Here is the code that I am running when printing out. The $ro is the primary key for the selected records.

$query171 = "SELECT * FROM coupons WHERE dealer = 'FLFORDRECOMMEND' and template = 'main' and position = '1'";
			$result171 = mysql_query($query171);
			while ($row171 = mysql_fetch_array($result171)) {
			$coupon1id = $row171["id"];
			$coupon1type = $row171["type"];
			$coupon1year = $row171["year"];
			$coupon1make = $row171["make"];
			$coupon1model = $row171["model"];
			$coupon1mileage_low = $row171["mileage_low"];
			$coupon1mileage_high = $row171["mileage_high"];
			for($i = 0; $i < count($ro); $i++){
			if($coupon1type == 'smart'){
			if($year = $coupon1year || $make = $coupon1make || $model = $coupon1model || ($nextincrementmileage >= $coupon1mileage_low && $nextincrementmileage <= $coupon1mileage_high)){
				$coupon1text1 = $row171["text_1"];
				$coupon1text2 = $row171["text_2"];
				$coupon1text3 = $row171["text_3"];
				$coupon1text4 = $row171["text_4"];
				$coupon1text5 = $row171["text_5"];
				$coupon1text6 = $row171["text_6"];
			}
			}else{
				$query17 = "SELECT * FROM coupons WHERE dealer = 'FLFORDRECOMMEND' and template = 'main' and position = '1' and type = 'default'";
				$result17 = mysql_query($query17);
				while ($row17 = mysql_fetch_array($result17)) {
				$coupon1text1 = $row17["text_1"];
				$coupon1text2 = $row17["text_2"];
				$coupon1text3 = $row17["text_3"];
				$coupon1text4 = $row17["text_4"];
				$coupon1text5 = $row17["text_5"];
				$coupon1text6 = $row17["text_6"];
				}
			}
			}
			}

Thanks for any help.

[Azala]

for($i = 0; $i < count($ro); $i++){

What's this good for? You don't take advantage of any for loop variables in your code.

$year = $coupon1year

If you are trying to compare the two variables you should use the == operator.

if($year = $coupon1year || $make = $coupon1make || $model = $coupon1model || ($nextincrementmileage >= $coupon1mileage_low && $nextincrementmileage <= $coupon1mileage_high)){

This if/else snippit has no else, meaning if it fails nothing happens, that seems weird.

while ($row17 = mysql_fetch_array($result17)) {

With this while loop all you are doing is overwriting the same variables each time it runs, that can't be intended, the assigned variables will only hold data from the last record in the recordset.

Where are you using the variables?

Try to explain in more detail what you are trying to achieve cause I don't have a clue after looking through this code 🙂

Azala

[raouleduke]

What I am doing is selecting records out of our database for our dealership, then with those records I am printing out the results. These results are letters that are getting mailed out to customers, we want to use different coupons for each customer based upon year make mileage. So the coupons can have YEAR, MAKE, MODEL, MILEAGE, and then we want to use each coupon based upon there year make and mileage. The snippit of code that I have in there is for one of the coupons.

Does this help

[Azala]

How are you displaying the data, or coupons?

Are you trying to make a list of coupons that you can print out on your printer, then use postal mail to get it to your clients?

Do you have a static webpage (html) with a coupon on so we can see what you are trying to make graphically?