Simple Question

[tpatterson1]

I know this is probably really simple, but I can't figure it out.

I'm trying to select information from my database and display certain information based on the query

For example:
[code]$bareQuery = "select * from XXXXX ";
$queryall = $bareQuery.$sorted;
$resultall = MYSQL_QUERY($queryall);
$numberall = mysql_Numrows($resultall);

if ($numberall==0) {

    echo "No Records Found !";

}
else if ($numberall>1)[/code]
And then that would list whatever

But I want to display items when a certain number is reached.
I guess it's kind of hard to explain.

I'm going to have the numbers 1-5 in a database field.

If the field has a number 1 in it, i want it to pull certain information, if it has a number 2, different information, and etc.

I hope this makes sense.

Can someone please help me?

[taith]

i think you're looking for something like this...
[code]
$result = mysql_query("select * from XXXXX ");
if(mysql_num_rows($result)==0){
echo "No Records Found !";
}else{
while($row = mysql_fetch_array($result)){
  echo $row['name']. " - ". $row['age'];
}
}
[/code]