WHy is this script bringing up a blank page?

damanic

Im baffed... what have I done wrong?

<?php
	$host="localhost";
	$user="m";
	$password="m"
    $connection = mysql_connect($host,$user,$password)
    or die("Could'nt connect to server";

mysql_select_db('m') or die('Could not select database');

// Performing SQL query
$query = "SELECT * FROM cmir_news";
$result = mysql_query($query) 
or die("Couldnt Execute Query.");

while ( $row = mysql_fetch_array($result))
{
  extract($row);
  echo "$header: $content<br>";
}

?>

thorpe

maybe youve got error reporting off and there is an error. you are missing a ; after you define your $password variable.

damanic

Ok I added the ;

My entire page looks like this

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<?php 
    $host="localhost"; 
    $user="m"; 
    $password="m"; 
    $connection = mysql_connect($host,$user,$password) 
    or die("Could'nt connect to server"; 

mysql_select_db('m') or die('Could not select database'); 

// Performing SQL query 
$query = "SELECT * FROM cmir_news"; 
$result = mysql_query($query)  

or die("Couldnt Execute Query."); 

while ( $row = mysql_fetch_array($result)) 
{ 
  extract($row); 
  echo "$header: $content<br>"; 
} 

?> 
</body>
</html>

Still Blank!

damanic

How do I turn on error reporting?

Weedpacket

In php.ini and/or with the [man]error_reporting[/man] function.

Rodney_H_

I am not sure about the usage of extract in your while loop, as I have read somewhere it is not a good idea (can't remember my source, so take it with a grain of salt). So, maybe try this:

<?php
$host='localhost';
$user='username';
$password='password';
$database = 'database';
$table = 'cmir_news';

$connect = mysql_connect($host,$user,$password)
         or die('Could not connect: ' . mysql_error());

$db = mysql_select_db($database,$connect)
         or die('Could not select database');

$query = "SELECT * FROM $table";

$result = mysql_query($query)
         or die('Could not Execute Query: ' . mysql_error());

// while results:
while ($row = mysql_fetch_array($result)){
	$header = $row['header'];
	$content = $row['content'];
	echo "$header: $content<br />";
}
?>

damanic

Ah Thanks Rodney,

Your one works a treat.