While Mysql result add if into the print

[josephicon]

How do I within a

WHILE

  then print "this if msql get-›result =1"

 

"this if msql get-›result =2"

 

"this if msql get-›result =1"

[clarke78]

You can use the switch statement in php to get certain statements to show up while performing your "while" loop.

 

<?php
$result = @mysql_query("SELECT * FROM table");

while($row = mysql_fetch_array($result)) {
        extract($row);

switch ($row_name){
case "1":
	echo "Test 1";
	break;	
case "2":
	echo "Test 2";
	break;	
case "3":
	echo "Test 3";
	break;	
}
}
?>		

[josephicon]

cheers thanks for that, so a If cannot be added into  a while only a switch will work why exactly is this?