HTML Help

crazyben21 · Joined: 17 Jul 2009 Posts: 21

Hello again I'm back. In my php code together with mysqli, it's causing firefox to show "The connection was reset" error. The problem starts in the while loop in my code. Can't manage to find what I'm doing wrong wrong or what I'm missing.

Code:
<?php
//sql connecting

$iscon = mysqli_connect('localhost','root','password');
if(!$iscon)
{
die('Could not connect to mySQL: ' . mysqli_connect_errno($iscon) . ' ' . mysqli_connect_error($iscon) . ' ');
}

?>

<?php

if ( !mysqli_select_db($iscon,'juniblog') )
{
echo 'Database doesn\'t excist: ' . mysqli_error($iscon) . ' ';
echo "Creating new database.... ";
if( mysqli_query($iscon, 'CREATE DATABASE juniblog') )
echo 'Database has been created successfully..';
else
echo die('An error has occured creating database: ' . mysqli_error($iscon));
}
else
echo "Database excist and is selected.";
?>

<?php
$junitable = mysqli_query($iscon, "select * from messageblog");

echo "Hello Milena! ";

while($row = mysqli_fetch_array($junitable))
{
echo "<div style=\"border:thin black solid\">";

echo '' . 'Titlte:' . $row['title'] . '';
echo '' . 'Message:' . $row['postmessage'] . '';
echo '' . 'Author:' . $row['author'] . '';
echo '' . 'Date:' . $row['date'] . '';

echo "</div>";
}

?>

<?php mysqli_close($iscon); ?>

This the part that cause the problem:
Code:
while($row = mysqli_fetch_array($junitable))
{
echo "<div style=\"border:thin black solid\">";

echo '' . 'Titlte:' . $row['title'] . '';
echo '' . 'Message:' . $row['postmessage'] . '';
echo '' . 'Author:' . $row['author'] . '';
echo '' . 'Date:' . $row['date'] . '';

echo "</div>";
}
[/code]

crazyben21 · Joined: 17 Jul 2009 Posts: 21

Just a Note: I created the table, with all the attributes, with MySql Query Browser.

crazyben21 · Joined: 17 Jul 2009 Posts: 21

Anybody. Any ideas? Just say something so I could feel your reading my problem at least.

crazyben21 · Joined: 17 Jul 2009 Posts: 21

I solve my "Page Can't be display" problem when I remove apavhe64 and php64bit and installed 32bit apache and php. Last time I'm using unofficial 64bit php and apache from http://www.elxis.org/guides/developers-guides/64bit-apache-php-mysql-windows.html. Now The thing I'm running is MySqL 64bit Official from mysql website.