Hope you are all happy and doing well!

I've chosen a piece of chunk of code from a movie browser script known as mysqli_query and mysqli-fetch-array for testing. It's possble a reason preventing it's execution. See any bugs in the following

I'm using APACHE 2.2, PHP 5.2.6 and MySQL 5.1

<?php

// ***** browse_movies.php *****

// Connect to MySQL and select the database:

$dbc = mysqli_connect('localhost', 'xxxx', 'xxxxxxxx','movies') or die ('Could not connect to MySQL: ' . mysqli_connect_error());

// Define the query:

$q = "SELECT first_name, last_name FROM directors";

// Run the query:

$r = mysqli_query($dbc, $q)or die("Error: ".mysqli_error($dbc));


// Display all of the records:

while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {

echo "{$row['first_name']} <i>{$row['last_name']}</i><br />\n";

}

// Clean up:

mysqli_free_result ($r);

mysqli_close($dbc);

?>


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to