I dont suppose anybody can spot my error?

[jontyjonty]

If I hide the "while" function code it prints the first row of the table - but if I unhide it I just get a blank white screen. I dont suppose anybody knows what Im doing wrong? Is the image causing an issue maybe? Thanks v much in advance
Jonty

<?php
$user_name = "Jonty";
$password = "xxxx";
$database = "Addressbook";
$server = "localhost";
$db_handle = mysql_connect($server, $user_name, $password);
if (!$db_handle)
{
die('Could not connect: ' . mysql_error());
}
$db_found = mysql_select_db($database, $db_handle);
$result = mysql_query("SELECT * FROM tbl_address_book");
if (!$result)
{
die('Could not select: ' . mysql_error());
}

echo "<table border='1'>
<tr>
<th>Category</th>
<th>City</th>
<th>Title</th>
<th>DateAv</th>
<th>Photo1</th>
</tr>";

while($row = mysql_fetch_array($result MYSQL_ASSOC))
{
echo "<tr>";
echo "<td>" . $row['Category'] . "</td>";
echo "<td>" . $row['City'] . "</td>";
echo "<td>" . $row['Title'] . "</td>";
echo "<td>" . $row['DateAv'] . "</td>";
echo "<td>" . $row['Photo1'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($db_handle);
?>

[laserlight]

This:

while($row = mysql_fetch_array($result MYSQL_ASSOC))

should be:

while($row = mysql_fetch_array($result, MYSQL_ASSOC))

[jontyjonty]

Thats clever! Thank you v much.

Now the screen goes blank and I have to end task. I think its to do with the photo. When Im uploading the picture Ive tested the file size with $fileSize = $_FILES['photo1']['size']; echo $fileSize; and it returms 13m. But the photo is just 1.3mb. Bit strange?

And if thats not the problem, is it possible to echo a picture straight out of a database like I am doing? Or could that be causing the crash?

I know I can google this and eventually find the answer, but if you know and its an easy answer that would be great!

Thanks very much again
Jonty

[Sxooter]

You should set up a development environment with error reporting turned on. The blank screen usually means there's some simple syntax error in your php and you can't see it on a production server with error reporting turned off.

[jontyjonty]

Great, thanks. Ill try that and let you know how i get on.
Jonty