how to echo from database

[alarik149]

hi guys,I have a question.I see the internet is quite low on information on this matter or is just me that dosen`t know how to search.
So i have a database named championships that contains 2 fields 'username' and 'status'.I connect to the databse,it's all ok,but next i'm stuck.
How can I echo into a webpace all the usernames?and second how can I echo into a webpage only the usernames with the status "test".
thanks for your time

[AV1611]

[code]<?php
    $user="";
    $host="localhost";
    $password="";
    $database = "championships";
    mysql_connect($host,$user,$password);
    mysql_select_db($database);



echo "<table border='1'><tr><td>Username</td><td>Status</td></tr>";
$result = mysql_query("SELECT * from championships where status like 'test' order by username asc ");
while($row=mysql_fetch_array($result)){
     echo "<tr><td>".$row['username']."</td><td>".$row['status']."</td></tr>";
     }
echo </table>
?>[/code]

[alarik149]

:) thanks a lot,it worked:).with some little change in the code:).big thanks.I am amazed how helpful you guys are..

[AV1611]

Yea, and all the REALLY smart people aren't even online yet! (No offence if you smart guys are lurking about LOL)