|
|
Posted by c.wrinn@gmail.com on 05/18/06 05:10
changed it to:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
<html>
<head>
</head>
<body>
<?
$mysql = mysql_connect("localhost","cwrinn","cw5324") or die('Unable
to Authenticate to ODBC'.mysql_error());
mysql_select_db(snapon_dev, $mysql) or die('Error Selecting
Database'.mysql_error());
$result = mysql_query("select * from branch limit 0,30", $mysql) or
die('Error querying database'.mysql_error());
$num = mysql_num_fields($result;
while ($row = mysql_fetch_row($result))
{
// for ($i=0; $i<$num); $i++)
// echo $row[$i] . " ";
print_r($row);
echo "\n";
}
mysql_close($connection);
?>
</body>
</html>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
still no output, btw. and yes, "select * from branch limit 0, 30" works
in MySQL fine.
btw, I have 3 tables, employee branch and region. Employee is large,
branch is small, region has nothing in it yet. So I'm using branch as a
test. They are setup on InnoDB.
Navigation:
[Reply to this message]
|