hello gurus,

i have a webserver running using apache and php (works fine). i'm trying to integrate and use mysql to my system. i copied a php script from a book to test my php-apache-mysql connection but its not giving me the expected output.

below is the code. you will notice that i placed "echo" before and after mysql_connect. it showed "connecting" on the browser, but seemed to hang because it does not show "after connection". the fields are manually entered in mysql.

here's the code:

///// database_connection.php
<?php
$dbUser = 'test_user';
$dbPass = 'test_pass';
$dbName = 'my_test';
$dbHost = 'localhost';

echo "Connecting";

$sql = mysql_connect($dbHost, $dbUser, $dbPass)
or die (mysql_error());

echo "After Connection";

mysql_select_db($dbName, $sql) or die (mysql_error());
?>

///// database_insert.php
<?php
include ('database_connection.php');

for ($i = 0; $i <= 50; $i++)
{
if($i % 2)
{
$data = $i.' -Odd Result';
}
else {
$data = $i.' -Even Result';
}

mysql_query("INSERT INTO my_table (my_value, my_date)
VALUES ('$data', now())") or die (mysql_error());
echo "Inserting: $data<br />";
}
echo "Done<br />";
?>

where does mysql put its errors by the way?

thanks guys!

jun

The way PHP reports errors is controlled by the ini file. The file does quite a good job of explaining it. The options are errors can be sent to the screen, errors can be sent to stderr, stderr can be overridden by a named file (ensure that apache has write access to that file). Also you can control the level of errors that are reported. The best thing is to look at the ini file for more info.

graeme.

You may want to consider changing your code as follows, for a chance of a little more information:

graeme