On Sat, 28 Apr 2001, Adrian D'Costa wrote:
> hi,
>
> I have listed the code below. I have the below table:
> | id | int(11) | | PRI | | auto_increment |
> | operator | varchar(30) | | | | |
> | email | varchar(35) | YES | | | |
> | url | varchar(50) | YES | | | |
>
> I want the operator field to be listed out in four columns and each row to
> have alternate colours. I am able to get it to come out in four columns
> but not the color. Where am I wrong?
>
> <?php
> require("common.php");
> require 'functions.php';
>
> $searchStmt = "select * from toperator order by operator" ;
>
>
> // connect to the db
>
> if (!($link = mysql_pconnect($db_server, $db_login, $db_passwd))){
> DisplayErrMsg(sprintf("internal error %d:%s\n",
> mysql_errno(), mysql_error()));
> exit() ;
> }
>
> // Selct the db
>
> if (!mysql_select_db($db, $link)) {
> DisplayErrMsg(sprintf("Error in selecting %s db", $db)) ;
> DisplayErrMsg(sprintf("error:%d %s", mysql_error($link),
> mysql_error($link))) ;
> exit();
> }
> // Execute the Statement
> if (!($result = mysql_query($searchStmt, $link))) {
> DisplayErrMsg(sprintf("Error in executing %s stmt", $searchStmt));
> DisplayErrMsg(sprintf("error:%d %s", mysql_errno($link),
> mysql_error($link)));
> exit();
> }
>
> $num = mysql_numrows($result);
> include("header.php");
> ?>
> <body bgcolor=white>
> <center>
> <table border=0 width=75% cellpadding=2 cellspacing=3>
>
> <?php
> $i=0;
> $t=0;
> $count=0;
> echo $cfgBgcolorOne;
> echo $cfgBgcolorTwo;
> $bgcolor = $cfgBgcolorOne;
>
> echo("<tr bgcolor=$bgcolor>");
> while($row=mysql_fetch_object($result)) {
> $i % 2 ? 0: $bgcolor = $cfgBgcolorTwo;
> $i++;
>
>
> if($count % 4==0) {
> echo("</tr>");
> echo("<tr bgcolor=$bgcolor>");
> echo $bgcolor;
> }
>
> $count++;
> ?>
> <td><font face=Arial size=2 color=000000><B><?php echo
> $row->operator;?></B></font></td>
> <?php
> if($count % 4==0) {
> echo("</tr>");
> }
> }
>
> ?>
>
> </table></center>
> while($row=mysql_fetch_object($result)) {
> $i % 2 ? 0: $bgcolor = $cfgBgcolorTwo;
> $i++;
>
>
> if($count % 4==0) {
> echo("</tr>");
> echo("<tr bgcolor=$bgcolor>");
> echo $bgcolor;
> }
>
> $count++;
> ?>
> <td><font face=Arial size=2 color=000000><B><?php echo
> $row->operator;?></B></font></td>
> <?php
> if($count % 4==0) {
> echo("</tr>");
> }
> }
>
> ?>
>
> </table></center>
> <?php
> include("footer.php");
> ?>
>
> TIA
>
> Adrian
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
