where do i put??

fr0stx

I'm having a problem that I don't know where to put while loop this below

while {

if ($row_color = "#000000") { $row_color = "#FFFFFF"; }
else { $row_color = "#000000"; }

Will put <?php echo($row_color); ?> in bgcolor= but I don't know where to do put that 🙁

<?
require "config.php";
$conn = mysql_connect($db_serv, $db_user, $db_pass);
$num = $_GET['id'];
$scud = mysql_db_query($db_bas , "SELECT * FROM download");

echo "<LINK REL=STYLESHEET HREF='style2.css' TYPE='TEXT/CSS'>";
echo "<table cellspacing='1' cellpadding='1' bgcolor='#D5D4D4' width='640' align='center'><tr bgcolor='#FFFFFF' align='center'><td>
	<b>Title</td>
	<td><b>Size</td>
	<td><b>Category</td>
	<td><b>Download hits</td></tr>";

while ($rad = mysql_fetch_array ($scud)) {
echo "<tr bgcolor='#FFFFFF' align='center'>
<td><a href='dl.php?file=" . $rad['filename'] . "'>".$rad['title']."</a></td>
<td>" . $rad['size'] . " KB</td>
<td>" . $rad['cat'] . "</td>
<td>" . $rad['downloads'] . "</td></tr>";
}
echo "</table>";
?>

Thanks

pjleonhardt

$rowcolor = "";
while ($rad = mysql_fetch_array ($scud)) { 

if ($row_color = "#000000")
{ $row_color = "#FFFFFF"; }
else { $row_color = "#000000"; }

echo "<tr bgcolor='#FFFFFF' align='center' style='background-color: " . $row_color . "'> 
<td><a href='dl.php?file=" . $rad['filename'] . "'>".$rad['title']."</a></td> 
<td>" . $rad['size'] . " KB</td> 
<td>" . $rad['cat'] . "</td> 
<td>" . $rad['downloads'] . "</td></tr>"; 
} 
echo "</table>";

pjleonhardt

didnt test it, but you should get the idea..

fr0stx

not working in different colour table rows

check this

http://fr0stx.net/downloads.php

chaotica

Originally posted by fr0stx
not working in different colour table rows

check this

http://fr0stx.net/downloads.php

have you checked out the html source?

...<tr bgcolor='<?php echo(#EEEEEE); ?>' align='center' style='background-color: #EEEEEE'>...

that <?php echo(#EEEEEE); ?> means that either you're trying to print out PHP code (which won't run, since php doesn't execute its output), or the server in question doesn't have php support. It looks like the former, as there are no signs of the variables and such that would be needed in a script that keeps track of what color the current row should be. 🙂

got code?

pjleonhardt

...<tr bgcolor='<?php echo(#EEEEEE); ?>' align='center' style='background-color: #EEEEEE'>...

not to mention you dont need both tr bgcolor and the style attributes

fr0stx

Can anyone please make Alternate Table Rows then put it this below

 <? 
require "config.php"; 
$conn = mysql_connect($db_serv, $db_user, $db_pass); 
$num = $_GET['id']; 
$scud = mysql_db_query($db_bas , "SELECT * FROM download"); 

echo "<LINK REL=STYLESHEET HREF='style2.css' TYPE='TEXT/CSS'>"; 
echo "<table cellspacing='1' cellpadding='1' bgcolor='#D5D4D4' width='640' align='center'><tr bgcolor='#FFFFFF' align='center'><td> 
    <b>Title</td> 
    <td><b>Size</td> 
    <td><b>Category</td> 
    <td><b>Download hits</td></tr>"; 

while ($rad = mysql_fetch_array ($scud)) { 
echo "<tr bgcolor='#FFFFFF' align='center'> 
<td><a href='dl.php?file=" . $rad['filename'] . "'>".$rad['title']."</a></td> 
<td>" . $rad['size'] . " KB</td> 
<td>" . $rad['cat'] . "</td> 
<td>" . $rad['downloads'] . "</td></tr>"; 
} 
echo "</table>"; 
?>

pjleonhardt, sorry it doesn't work and chaotica, yes I have checked in view source but I don't know why. Geez I don't want to give up 🙁

ssmith1227

Somehting similar to this should work. I also got rid of all the echoing and concatenation. Just drop out of php to do the row and show your variable contents with the short cut tag:

<?=$var?>

to me, it makes the code much simpler.

<?php
$index = 0;
while ($rad = mysql_fetch_array ($scud)) {
$index++
if($index % 2) {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#EEEEEE";
}
?>
<tr bgcolor="$bgcolor" align="center">
<td><a href="dl.php?file=<?=$rad['filename']?>
"><?=$rad['title']?></a></td>
<td><?=$rad['size']?> KB</td>
<td><?=$rad['cat']?></td>
<td><?=$rad['downloads']?></td></tr>
<?php
}
?>
</table>

chaotica

<?php 
require "config.php"; 
$conn = mysql_connect($db_serv, $db_user, $db_pass); 
$num = $_GET['id']; 
$scud = mysql_db_query($db_bas , "SELECT * FROM download"); 

echo "<LINK REL=STYLESHEET HREF='style2.css' TYPE='TEXT/CSS'>"; 
echo "<table cellspacing='1' cellpadding='1' bgcolor='#D5D4D4' width='640' align='center'>
<tr bgcolor='#FFFFFF' align='center'>
      <th><b>Title</th> 
      <th><b>Size</th> 
      <th><b>Category</th> 
      <th><b>Download hits</th>
</tr>"; 
$colored = false;
while ($rad = mysql_fetch_array ($scud)) { 
    echo "<tr bgcolor='{$colored ? '#eeeeee' : '#ffffff'}' align='center'> 
          <td><a href='dl.php?file={$rad['filename']}'>{$rad['title']}</a></td> 
          <td>{$rad['size']} KB</td> 
          <td>{$rad['cat']}</td> 
          <td>{$rad['downloads']}</td>
</tr>"; 
    $colored = !$colored;
} 
echo "</table>"; 
?>

sorry...haven't tested the code. i'm just rattling it off. 🙂

fr0stx

Parse error: parse error, expecting `'}'' in /home/fr0stx/public_html/downloads.php on line 17

Parse error: parse error, expecting ','' or';'' in /home/fr0stx/public_html/downloads.php on line 17

The line 17 is

echo "<tr bgcolor='{$colored ? '#eeeeee' : '#ffffff'} align='center'>

addie

hi, if you mean odd rows to be shown on loop u can see my example i had long time.

<?
require_once 'config.php';

MySQL_connect("$host","$login","$pass");
MySQL_select_db("$db") or die("Could not select database");


$sql = "SELECT * FROM $table "; 
$query = mysql_query($sql) or die(mysql_error()); 
$total = mysql_num_rows($query); 


function rowColor($id)  

{
    if($id%2) {
        return "row1";
    } else {
        return "row2";
    }
  }

While( $rows = MySQL_fetch_array($result) ) {
$id = $rows['id']; 
$username = $rows['username'];
$usermail = $rows['usermail'];

echo "<table border=0 cellPadding=0 cellSpacing=0 width=300 height=100 class=techline>";
    echo "<tr>";
    echo "<td class=\"".rowColor($id)."\">";
    echo "<br><b>User Name:</b> $username";
    echo "<br><b>User Email:</b> $usermail";
    echo "</td>";
    echo "</tr>";
}


 MySQL_close()
?>

now you edit for your needs

chaotica

Originally posted by fr0stx
Parse error: parse error, expecting `'}'' in /home/fr0stx/public_html/downloads.php on line 17

Parse error: parse error, expecting ','' or';'' in /home/fr0stx/public_html/downloads.php on line 17

Then change line 17 to

echo "<tr bgcolor='" . ($colored ? '#eeeeee' : '#ffffff') . "' align='center'>

i wasn't sure which ways php would let you do a ?:. apparently, it doesn't like it in the middle of an echo. 🙂