<html>
<head><title>MySQL Test Code</title></head>
<body>
<h1>MySQL Test Code Results</h1>
<p>
<table border="1">
<tr><td>pkID</td><td>username</td><td>password</td></tr>
<?php
/*
* Configuration Information and Definitions
*/
$mysql_host = 'sqlX.sqlsvr.net';
$mysql_user = 'username';
$mysql_pass = 'password';
$mysql_db = 'database';
$query = 'SELECT * from tableX';
mysql_connect($mysql_host, $mysql_user, $mysql_pass) or die("Connection to MySQL-server failed!");
mysql_select_db($mysql_db) or die("Selection of database $mysql_db failed!");
$result = mysql_query($query) or die("Invalid Query, " . mysql_error());
while( list( $pkid, $user, $pass ) = mysql_fetch_row($result) )
{
printf("<tr><td>%d</td><td>%s</td><td>%s</td></tr>", $pkid, $user, $pass);
}
?>
</table>
</p>
<h1>End MySQL Test Code Results</h1>
Article ID: 262, Created: 4/24/2009 at 9:26 AM, Modified: 4/24/2009 at 9:26 AM