Jump to content

Archived

This topic is now archived and is closed to further replies.

alarik149

how to echo from database

Recommended Posts

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

Share this post


Link to post
Share on other sites
[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]

Share this post


Link to post
Share on other sites
:) thanks a lot,it worked:).with some little change in the code:).big thanks.I am amazed how helpful you guys are..

Share this post


Link to post
Share on other sites
Yea, and all the REALLY smart people aren't even online yet! (No offence if you smart guys are lurking about LOL)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.