if/else problem

[New_Coder]

im really new coder 🙂
i have any problem with if/else .

<?//mysql database 
$test = date('Y-d-m', time(), $timezone );
$sql = "SELECT  * FROM table WHERE  date = '$test'" ;
$results = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error());
$table  = mysql_num_rows($results); ?>
Date : <? echo $test ?>
<?  if ( $suspension == 1 ) {
	echo "today suspension";
} else {
	echo "today normal";
}?> 

but not work if/else . mysql table is : id | suspension | date

[dagon]

after mysql_query you need to get the results with mysql_fetch_assoc()

<?
//mysql database
$test = date('Y-d-m', time(), $timezone );
$sql = "SELECT  * FROM table WHERE  date = '$test'" ;
$results = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error());
$row=mysql_fetch_assoc($results);
$table  = mysql_num_rows($results); 
echo 'Date: '  $test;
  if ( $row['suspension'] == 1 ) {
    echo "today suspension";
} else {
    echo "today normal";
}
?> 

[Weedpacket]

And I suggest you use <?php to start PHP blocks. If you get into the habit of using <? now you'll only have to kick it later.

[New_Coder]

dagon;10904633 wrote:

after mysql_query you need to get the results with mysql_fetch_assoc()

<?
//mysql database
$test = date('Y-d-m', time(), $timezone );
$sql = "SELECT  * FROM table WHERE  date = '$test'" ;
$results = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error());
$row=mysql_fetch_assoc($results);
$table  = mysql_num_rows($results); 
echo 'Date: '  $test;
  if ( $row['suspension'] == 1 ) {
    echo "today suspension";
} else {
    echo "today normal";
}
?> 

this worked but another problem . i have this line :

<?php
       while ($row = mysql_fetch_array($results)) {
       ?>
<tr>
      <td  class="test"><li><?php echo $row['desc']
 // this line list for each date all desc with id  ?> </li></td></tr>
       <?php } ?>

this not worked when add this line : $row=mysql_fetch_assoc($results); and show only one desc . before add this line show all desc !!!!

Weedpacket: And I suggest you use <?php to start PHP blocks. If you get into the habit of using <? now you'll only have to kick it later.

this true !! thanks

[dagon]

you can start and stop php inside the loop, use echo for the output

<?php
       while ($row = mysql_fetch_array($results)) {
       echo'<tr>      <td  class="test"><li>'.$row['desc'].'</li></td></tr>';
} 
?> 

[New_Coder]

dagon

Not Worked ! this's strange 😕
all code last edit :

<?php 
//mysql database 
$test = date('Y-d-m', time(), $timezone ); 
$sql = "SELECT  * FROM table WHERE  date = '$test'" ; 
$results = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error()); 
$table  = mysql_num_rows($results);
$row = mysql_fetch_array($results);
switch ($row['suspension']) {
        case 0: echo "bad"; break; 
        case 1: echo "good"; break; 
        case 2: echo "normal"; }
 while ($row = mysql_fetch_array($results)) {
       echo'<tr>      <td  class="test"><li>'.$row['desc'].'</li></td></tr>';
} 

Mysql table :

---- id -------- date ------- desc ------- suspension
-----  1  --- 02-02-2009-- any desc ---- 1
-----  2  --- 02-03-2009-- any desc ---- 0
-----  3  --- 02-05-2009-- any desc ---- 2
-----  4  --- 02-02-2009-- any desc ---- 1
-----  5  --- 02-02-2009-- any desc ---- 1
 

see id ( 1 , 4 , 5 ) have a date . ( for while list )
and suspension ( switch ) .
but not worked 🙁

[Weedpacket]

switch ($row['suspension']) {
        case 0: echo "bad"; break;
        case 1: echo "good"; break;
        case 2: echo "normal"; } 

This should be inside the loop, otherwise it won't be part of the loop.

       <tr>      <td  class="test"><li>any desc</li></td></tr>

This is just bad HTML: is it supposed to be a list or a table? Also, it has nowhere for the "bad/good/normal" thing to go.

while ($row = mysql_fetch_array($results)) {
switch ($row['suspension']) {
        case 0: $suspension = "bad"; break;
        case 1: $suspension = "good"; break;
        case 2: $suspension = "normal"; break; }
       echo'<tr>      <td  class="test">'.$row['desc'].'</td><td>'.$suspension.'</td></tr>';
}

Huh, $row['suspension is always 0, 1, or 2....

$suspensions = array("bad", "good", "normal");

while ($row = mysql_fetch_array($results)) {
       echo'<tr>      <td  class="test">'.$row['desc'].'</td><td>'.$suspensions[$row['suspension']].'</td></tr>';
}