RE: [PHP] MySQL question

[.ben]

In brief, and in no way finished (no error trapping, commenting, etc)...

<?
        $db = mysql_connect("localhost", "root");

        mysql_select_db("test",$db);

        $result = mysql_query("SELECT CountryID, CountryName FROM
tblcountries",$db);

        echo "<table border=1>\n";
        echo "  <tr>\n";
        echo "    <td>CatNumber</td>\n";
        echo "    <td>Title</td>\n";
        echo "  </tr>\n";

        while ($myrow = mysql_fetch_row($result))
        {

                echo "<tr>\n";
                echo "  <td>$myrow[0]</td>\n";
                echo "  <td>$myrow[1]</td>\n";
                echo "</tr>\n";

        }

        echo "</table>\n";
?>

hth,

 .ben

> -----Original Message-----
> From: Mantas Kriauciunas [mailto:[EMAIL PROTECTED]]
> Sent: 22 April 2002 01:07
> To: PHP General List
> Subject: [PHP] MySQL question
>
>
> Hey PHP General List,
>
>   Amm... can anybody point me to some good tutorial that talks about
>   SELECT from detabase? what i need is ... like i have table with lots
>   of rows.... and i need to output them all to the page... it goes
>   like most of news sections in the page... thanks for help.
>   (i need to learn more about SELECT'ing things from database)
>
> :------------------------------:
>         Have A Nice Day!
>  Mantas Kriauciunas A.k.A mNTKz
>
> Contacts:
> [EMAIL PROTECTED]
> Http://mntkz-hata.visiems.lt
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php