Mega Code Archive
While loop and mysql_fetch_array() function
<![CDATA[
<html>
<head>
<title>Get data</title>
</head>
<body>
<?php
$conn = @mysql_connect( "localhost", "userName", "password" ) or die( "Err:Conn" );
$rs = @mysql_select_db( "my_database", $conn ) or die( "Err:Db" );
$sql = "select id,first_name from my_table order by first_name";
$rs = mysql_query( $sql, $conn );
while( $row = mysql_fetch_array( $rs ) )
{
echo( "ID: " . $row["id"] );
echo( " - FIRST NAME: " . $row["first_name"] . "<br>" );
}
?>
</body>
</html>
]]>