Entry

How to load data from my phpMyAdmin Databse

Oct 9th, 2006 09:56
Matthew Wilkinson, Naz Khan,

If you are using PHPMyAdmin, you need the MySQL functions. You would
usually use them in this order:
mysql_connect('server', 'username', 'password');
mysql_select_db('database');
$result = mysql_query('SELECT * FROM table');
$n = 1;
while ($n <= mysql_num_rows($result))
{
list ($col1, $col2, $col3) = mysql_fetch_row($result);
//do something with data
$n++;
}