PHP/MySQL Questions

LazyD · 08-31-2006, 08:40 AM

Hi all,

Im currently creating a website that is going to display credit cards by type, insurance and credit services.

Each credit card, credit service or insurance listing is going to be in its own box with a small space between each one, each listing is to be created by the MySQL output loop.

My questions are these:
1. Is there a way to tell the the MySQL output, to put something, like an advertisement from an affiliate between every 3rd or 4th listing?

2. For the area where im going to put APRs and other card properties, to make it easier to read, I would like to alternate what color the background is, is there a way I can tell the MySQL output, that I want entries with a certain fieldname to use "Div A" and other ones "Div B"?

Noobie · 08-31-2006, 09:17 AM

You may want to use modulus (%)

Example

PHP Code:

  $x = 0;

????: NamePros.com http://www.namepros.com/programming/233430-php-mysql-questions.html
$query = 'SELECT * FROM my_table';

$result = mysql_query($query) or die('Query failed: ' . mysql_error());

while($line = mysql_fetch_row($result)){

 ($x % 2 == 0 ? $div = "diva" : $div = "divb"); // modulus here

   echo "<div class=\"$div\">$line[0]</div>";

   $x++;

}

Same can be used for your ads

LazyD · 08-31-2006, 10:17 AM

Originally Posted by Noobie

You may want to use modulus (%)

Example

PHP Code:

  $x = 0;

$query = 'SELECT * FROM my_table';

????: NamePros.com http://www.namepros.com/showthread.php?t=233430
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

while($line = mysql_fetch_row($result)){

 ($x % 2 == 0 ? $div = "diva" : $div = "divb"); // modulus here

   echo "<div class=\"$div\">$line[0]</div>";

   $x++;

}

Same can be used for your ads

Thanks Noobie... Just so I understand, since at the part where your echoing back the div, you have $line[0], how will that work with my output loop? Would having 0 in the array area cause problems? I dont understand how that works, and I am curious from a learning aspect...

Noobie · 08-31-2006, 03:08 PM

the $line[0] just means the first field in your resultset, was just an example.

replace my $line[0] with a table or whatever you want to display.

08-31-2006, 08:40 AM	THREAD STARTER #1 (permalink)
LazyD NamePros Member Join Date: Jul 2005 Location: Petaluma, California Posts: 128	PHP/MySQL Questions Hi all, Im currently creating a website that is going to display credit cards by type, insurance and credit services. Each credit card, credit service or insurance listing is going to be in its own box with a small space between each one, each listing is to be created by the MySQL output loop. My questions are these: 1. Is there a way to tell the the MySQL output, to put something, like an advertisement from an affiliate between every 3rd or 4th listing? 2. For the area where im going to put APRs and other card properties, to make it easier to read, I would like to alternate what color the background is, is there a way I can tell the MySQL output, that I want entries with a certain fieldname to use "Div A" and other ones "Div B"? __________________ Credit Cards - Loans - Insurance Realtors by State House Financing & Mortgage Information Surfing News & Information

08-31-2006, 09:17 AM	#2 (permalink)
Noobie NamePros Regular Join Date: Feb 2006 Location: Montreal, Quebec, Canada Posts: 324	You may want to use modulus (%) Example PHP Code: `$x = 0; ????: NamePros.com http://www.namepros.com/programming/233430-php-mysql-questions.html $query = 'SELECT * FROM my_table'; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); while($line = mysql_fetch_row($result)){ ($x % 2 == 0 ? $div = "diva" : $div = "divb"); // modulus here echo "<div class=\"$div\">$line[0]</div>"; $x++; }` Same can be used for your ads __________________ Goldkey.com is a scam What's your BMI? \| Timestamp Generator Last edited by Noobie; 08-31-2006 at 09:21 AM.

08-31-2006, 03:08 PM	#4 (permalink)
Noobie NamePros Regular Join Date: Feb 2006 Location: Montreal, Quebec, Canada Posts: 324	the $line[0] just means the first field in your resultset, was just an example. replace my $line[0] with a table or whatever you want to display. __________________ Goldkey.com is a scam What's your BMI? \| Timestamp Generator

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)