Only display the rows I need

[Anon]

Hi,

at icosmoss.com I have separated our projects into "completed" and "pending". I already have made the script loading the data but how do I display the results now?

I'm thinking of the echo tag...

[Anon]

$result = mysql_query(SELECT * FROM $dbtable WHERE whatever = '$whatever');
while($row = mysql_fetch_row($result))
{
//get columns
$whatever1 = $row[0];
$whatever2 = $row[1];

print ("<table>");
print ("<tr>\n<td>$whatever1</td>\n");
print ("<td>$whatever2</td>\n</tr>\n");
print ("</table>");
}