MYSQL/PHP Farbanje redova

[ srdjan_kg @ 23.02.2009. 20:22 ] @

Da li moze neko da malcice pomogne, ili uputi.....

Imam mysql bazu, u kojoj imam pored ostalih npr. polje "karakter"...
u koje samo se unosi "ozbiljan" i "neozbiljan" npr....

kada izlistam podatke iz pomenute tabele
hteo bih, naravno ako to moze da sve gde je "neozbiljan" u polju "karakter"
da oboji taj red u neku odredjenu boju...

p.s. postojeca tabela mi vec ima boje za parne i neparne redove
ukoliko to smeta da bi ovo funkcionisalo, sklonicu.....

trazio sam po net-u, slaba vajda sem ovog koda sa linka: http://www.phpfreaks.com/forums/index.php?topic=158877

<?php
error_reporting(7);

$db = mysql_connect("localhost","......",".....") or die("Problem connecting");
mysql_select_db(".....") or die("Problem selecting database");
$query = "SELECT * FROM rules ORDER BY username";
$result = mysql_query($query) or die ("Query failed");
//let's get the number of rows in our result so we can use it in a for loop
$numofrows = mysql_num_rows($result);
echo "<TABLE BORDER=\"1\">\n";
echo "<TR bgcolor=\"lightblue\"><TD>UserID</TD><TD>UserName</TD><TD>Agreed?</TD><TD>Date Agreed</TD></TR>\n";
for($i = 0; $i < $numofrows; $i++) {
$row = mysql_fetch_array($result); //get a row from our result set
if($i % 2) { //this means if there is a remainder
echo "<TR bgcolor=\"yellow\">\n";
} else { //if there isn't a remainder we will do the else
echo "<TR bgcolor=\"white\">\n";
}
echo "<TD>".$row['userid']."</TD><TD>".$row['username']."</TD><TD>".$row['diduseragree']."</TD><TD>".$row['dateagreed']."</TD>\n";
echo "</TR>\n";
}
//now let's close the table and be done with it
echo "</TABLE>\n";
?>

ukoliko je neko voljan da mi pomogne
HVALA UNAPRED

[ kazil @ 23.02.2009. 20:30 ] @

Proveru za ovo treba da ubacis isto kao proveru za par/nepar:

Code:

for($i = 0; $i < $numofrows; $i++) {
    $row = mysql_fetch_array($result); //get a row from our result set
    if ($row['karakter'] == 'neozbiljan') {
         echo "<tr bgcolor='red'>";
    } elseif ($i % 2) { //this means if there is a remainder
        echo "<TR bgcolor=\"yellow\">\n";
    } else { //if there isn't a remainder we will do the else
        echo "<TR bgcolor=\"white\">\n";
    }
    echo "<TD>".$row['userid']."</TD><TD>".$row['username']."</TD><TD>".$row['diduseragree']."</TD><TD>".$row['dateagreed']."</TD>\n";
    echo "</TR>\n";
}

[ srdjan_kg @ 23.02.2009. 20:40 ] @

hvala ti punoooooooo

sad idem da probam valjda ce sve biti u redu

H V A L A

[ srdjan_kg @ 23.02.2009. 20:50 ] @

Kazil, hvala tu jos jednom...ali smrc, smrc, nece da radi ......

ustvari na onom primeru hoce, ekstra je, ali gde ja to da ubacim konkretno na mom primeru:

<table width="730" border="0" align="center" cellpadding="0" cellspacing="0" id="table2">

<tr>
<td width="62" height="34" bgcolor="#DDDDDD" class="tahoma_bold_13_bledozuto"><div align="center">Šifra </div></td>
<td width="205" bgcolor="#DDDDDD" class="tahoma_bold_13_bledozuto"><div align="left">    Lokacija nekretnine </div></td>
<td width="137" bgcolor="#DDDDDD" class="tahoma_bold_13_bledozuto"><div align="center">Površina</div></td>
<td width="142" bgcolor="#DDDDDD" class="tahoma_bold_13_bledozuto"><div align="center">Struktura</div></td>
<td width="146" bgcolor="#DDDDDD" class="tahoma_bold_13_bledozuto"><div align="center">Spratnost</div></td>
<td width="108" bgcolor="#DDDDDD" class="tahoma_bold_13_bledozuto"><div align="center">  Cena</div></td>
</tr>
<?php do { ?>
<tr>
<td height="23"><div align="center" class="menu01"><a href="kuce_detaljno.php?id=<? echo $row_kuce['id']; ?>" target="_blank"><?php echo $row_kuce['id']; ?></a></div></td>
<td class="menu01"><div align="left">      <span class="px"><?php echo $row_kuce['lokacija']; ?></span></div></td>
<td class="px"><div align="center"><?php echo $row_kuce['povrsina']; ?></div></td>
<td class="px"><div align="center"><?php echo $row_kuce['struktura']; ?></div></td>
<td class="px"><div align="center"><?php echo $row_kuce['spratnost']; ?></div></td>
<td class="menu01"><div align="right" class="px5"><?php echo $row_kuce['cena']; ?> €</div></td>

</tr>
<?php } while ($row_kuce = mysql_fetch_assoc($kuce)); ?>
</table>

hvala unapred

[ kazil @ 23.02.2009. 20:56 ] @

Pogledaj gde sam ja ubacio proveru. Tamo gde ispisujem <tr> tag. Ti isto tamo treba da ubacis, istu proveru.

[ srdjan_kg @ 23.02.2009. 21:07 ] @

ok hvala u svakom slucaju kazil

ipak nemogu da se snadjem u ovom mom primeru
pokusah sve, al nece

sta sa se radi, kada sam pocetnik,
vise muka, nije na odmet

pozdrav i hvala jos jednom

[ kazil @ 23.02.2009. 21:13 ] @

Code:

<?php do {
if ($row['karakter'] == 'neozbiljan') {
echo "<tr bgcolor='red'>";
}
?>

[ srdjan_kg @ 23.02.2009. 21:28 ] @

nece da farba nista

nemam srece u ovoj noci

[ kazil @ 23.02.2009. 21:29 ] @

Ae daj taj kod sto nece da radi. I molim te da kod smestis izmedju code tagova, da bude lakse za citanje.

[ srdjan_kg @ 23.02.2009. 21:38 ] @

Code:

<?php require_once('../Connections/tas034.php'); ?>
<?php
$maxRows_kuce = 15;
$pageNum_kuce = 0;
if (isset($_GET['pageNum_kuce'])) {
  $pageNum_kuce = $_GET['pageNum_kuce'];
}
$startRow_kuce = $pageNum_kuce * $maxRows_kuce;

mysql_select_db($database_tas034, $tas034);
$query_kuce = "SELECT * FROM stankuca WHERE vrstanekretnine = 'Kuća'  AND arhiva ='Ne' ORDER BY cena DESC";
$query_limit_kuce = sprintf("%s LIMIT %d, %d", $query_kuce, $startRow_kuce, $maxRows_kuce);
$kuce = mysql_query($query_limit_kuce, $tas034) or die(mysql_error());
$row_kuce = mysql_fetch_assoc($kuce);

if (isset($_GET['totalRows_kuce'])) {
  $totalRows_kuce = $_GET['totalRows_kuce'];
} else {
  $all_kuce = mysql_query($query_kuce);
  $totalRows_kuce = mysql_num_rows($all_kuce);
}
$totalPages_kuce = ceil($totalRows_kuce/$maxRows_kuce)-1;
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250" />
<title>TAŠ NEKRETNINE osnovano 1990 KRAGUJEVAC</title>
<link rel="shortcut icon" href="ikona.ico" />

<script language="javascript" type="text/javascript" src="filter/actb.js"></script>
<script language="javascript" type="text/javascript" src="filter/tablefilter.js"></script>

<link href="filter/filtergrid.css" rel="stylesheet" type="text/css" />
<link href="style.css" rel="stylesheet" type="text/css" />
</head>

<body>

<?php include('logo.php'); ?>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td> </td>
  </tr>
  <tr>
    <td><fieldset>
    <legend class="tahoma_zeleno_18">PREGLED PONUDA - <span class="plava"><?php echo $row_kuce['vrstanekretnine']; ?> </span><span class="tahoma_zeleno_18">- </span></legend>
        <p> </p>
        <table width="750" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td><table width="730" border="0" align="center" cellpadding="0" cellspacing="0" id="table2">

                <tr>
                  <td width="62" height="34" bgcolor="#DDDDDD" class="tahoma_bold_13_bledozuto"><div align="center">Šifra </div></td>
                  <td width="205" bgcolor="#DDDDDD" class="tahoma_bold_13_bledozuto"><div align="left">    Lokacija nekretnine </div></td>
                  <td width="137" bgcolor="#DDDDDD" class="tahoma_bold_13_bledozuto"><div align="center">Površina</div></td>
                  <td width="142" bgcolor="#DDDDDD" class="tahoma_bold_13_bledozuto"><div align="center">Struktura</div></td>
                  <td width="146" bgcolor="#DDDDDD" class="tahoma_bold_13_bledozuto"><div align="center">Spratnost</div></td>
                  <td width="108" bgcolor="#DDDDDD" class="tahoma_bold_13_bledozuto"><div align="center">  Karakter</div></td>
                </tr>
                <?php do { ?>
                <tr>
                  <td height="23"><div align="center" class="menu01"><a href="kuce_detaljno.php?id=<? echo $row_kuce['id']; ?>" target="_blank"><?php echo $row_kuce['id']; ?></a></div></td>
                  <td class="menu01"><div align="left">      <span class="px"><?php echo $row_kuce['lokacija']; ?></span></div></td>
                  <td class="px"><div align="center"><?php echo $row_kuce['povrsina']; ?></div></td>
                  <td class="px"><div align="center"><?php echo $row_kuce['struktura']; ?></div></td>
                  <td class="px"><div align="center"><?php echo $row_kuce['spratnost']; ?></div></td>
                  <td class="menu01"><div align="right" class="px5"><?php echo $row_kuce['karakter']; ?> €</div></td>
                  
                </tr>
                <?php } while ($row_kuce = mysql_fetch_assoc($kuce)); ?>
              </table>
                <script language="JavaScript" type="text/javascript">
//<![CDATA[
    var table2_Props =     {
                    loader: true,
                    alternate_rows: true,
                    loader_text: "Sacekaj malo...",
                    col_1: "select",
                    col_6: "none",
                    display_all_text: "[Prikaži sve lokacije]",
                    rows_counter: true,
                    rows_counter_text: "Ukupno ponuda: ",
                    btn_reset: true,
                    bnt_reset_text: "Ponisti filter",
                    sort_select: true
                };
    setFilterGrid( "table2",table2_Props );
//]]>
          </script></td>
          </tr>
        </table>
    </fieldset> </td>
  </tr>
</table>
</body>
</html>
<?php
mysql_free_result($kuce);
?>

[ kazil @ 23.02.2009. 21:43 ] @

Pa nisi ni ubacio tu proveru koju sam ti rekao.

Code:

<?php do {
    if($row['karakter'] == 'neozbiljan'){ echo "<tr bgcolor='red'>";}
    else{ echo "<tr>";}
?>
                  <td height="23"><div align="center" class="menu01"><a href="kuce_detaljno.php?id=<? echo $row_kuce['id']; ?>" target="_blank"><?php echo $row_kuce['id']; ?></a></div></td>
                  <td class="menu01"><div align="left">      <span class="px"><?php echo $row_kuce['lokacija']; ?></span></div></td>
                  <td class="px"><div align="center"><?php echo $row_kuce['povrsina']; ?></div></td>
                  <td class="px"><div align="center"><?php echo $row_kuce['struktura']; ?></div></td>
                  <td class="px"><div align="center"><?php echo $row_kuce['spratnost']; ?></div></td>
                  <td class="menu01"><div align="right" class="px5"><?php echo $row_kuce['karakter']; ?> €</div></td>
                  
                </tr>
                <?php } while ($row_kuce = mysql_fetch_assoc($kuce)); ?>

[ srdjan_kg @ 23.02.2009. 21:51 ] @

ok radi, al samo kad izbrisem ovaj kod pri kraju::

<script language="JavaScript" type="text/javascript">
//<![CDATA[
var table2_Props = {
loader: true,
alternate_rows: true,
loader_text: "Sacekaj malo...",
col_1: "select",
col_6: "none",
display_all_text: "[Prikaži sve lokacije]",
rows_counter: true,
rows_counter_text: "Ukupno ponuda: ",
btn_reset: true,
bnt_reset_text: "Ponisti filter",
sort_select: true
};
setFilterGrid( "table2",table2_Props );
//]]>
</script>