Well, I gave a SELECT, to pull my data, only I wanted to do the following: If $ category is 1, it would be called World, and if $ category equals 2, it would be called Moon, how can I do that?
Code:
<?php
$conect = mysql_query("SELECT * FROM news ORDER BY ID DESC") or die(mysql_error());
?>
Pulling SELECT:
<?php echo $conect['categoria']; ?>
Using the command if :
<?php
if ($conect['categoria'] == 1){
echo "Mundo";
}else if($conect['categoria'] == 2){
echo "Lua";
}else{
echo "Outros";
};
?>
Using the command case :
<?php
switch ($conect['categoria']) {
case 1:
echo "Mundo"; break;
case 2:
echo "Lua"; break;
default:
echo "Outros";
}
?>
First you make the query:
$connection = mysql_connect("localhost", "user", "pass");
$selectbase = mysql_select_db("base", $connection );
$slectdados = mysql_query("SELECT * FROM news ORDER BY ID DESC") or die(mysql_error());
while ($linha = mysql_fetch_array($slectdados){
if( $linha['categoria'] == "Mundo" ){
echo "Mundo<br>";
} elseif ( $linha['categoria'] == "Lua" ){
echo "Lua<br>";
} else {
echo "Outros<br>";
}
It may be that within a loop where you select all the results you can then print line by line according to the value of each record but the question is very vague.