Dlaczego to nie działa? wrrr.. Kolumna 'signals_state' sklada sie z z cyfr od 0 do 5, w kazdym wierszu moze byc oczywiscie tylko jedna cyfra.

[PHP] pobierz, plaintext 
<?php
require_once('mysql_connect.php');
$query='SELECT Signals_state from crossing';
$result=mysql_query($query) or die ('blad:' . mysql_error());;
while(list($Signals_state)=mysql_fetch_row($result)){
echo'<br>';
If ($Signals_state=&#092;"0\"){ echo('unknown'); }
If ($Signals_state=&#092;"1\"){ echo('startup'); }
If ($Signals_state=&#092;"2\"){ echo('dark'); }
If ($Signals_state=&#092;"3\"){ echo('flash'); }
If ($Signals_state=&#092;"4\"){ echo('allred'); }
If ($Signals_state=&#092;"5\"){ echo('color'); }
}
?>
[PHP] pobierz, plaintext 

oto wynik mojego mega skryptu

"startupdarkflashallredcolor5"

[PHP] pobierz, plaintext 
<?php
require_once('mysql_connect.php');
$query='SELECT Signals_state from crossing';
$result=mysql_query($query) or die ('blad:' . mysql_error());;
while(list($Signals_state)=mysql_fetch_row($result)){
echo'<br>';
If ($Signals_state==&#092;"0\"){ echo('unknown'); }
If ($Signals_state==&#092;"1\"){ echo('startup'); }
If ($Signals_state==&#092;"2\"){ echo('dark'); }
If ($Signals_state==&#092;"3\"){ echo('flash'); }
If ($Signals_state==&#092;"4\"){ echo('allred'); }
If ($Signals_state==&#092;"5\"){ echo('color'); }
}
?>
[PHP] pobierz, plaintext 

Dziękuję, nie wpadłbym na to