[RESOLVED] another Problem

eddjc

Hi there,

Another problem I'm having is longer scripts seem to stop loading as scripts and start loading on the page. E.g the output of this:

<?php
// open connection to MySQL server
$connection = mysql_connect('localhost', 'user', 'pass') or die ('Unable to connect!');
// select database for use
mysql_select_db('orders') or die ('Unable to select database!');

// create and execte query
$query = 'SELECT * FROM items';
$result = mysql_query($query)
or die ('Error in query: $query. ' . mysql_error());

// check if record were returned
if (mysql_num_rows($result) > 0)
{
// print HTML table
echo '<table width=100% cellpadding=10 cellspacing=0 border=1>';
echo '<tr><td>ID</td><td>Name</td><td>Price</td></tr>';

// iterate over record set
// print each field
while($row = mysql_fetch_row($result))
{
	echo '<tr>';
	echo '<td>' . $row[0] . '</td>';
	echo '<td>' . $row[1] . '</td>';
	echo '<td>' . $row[2] . '</td>';
	echo '</tr>';
}
echo '</table>';

}
else
{
// print error message
echo 'No rows found!';
}

// once processing is complete
// free result set
mysql_free_result($result);

// close connection to MySQL server
mysql_close($connection);
?>

</body>
</html>

comes out as this on the web browser:

0) { // print HTML table echo ''; // iterate over record set // print each field while($row = mysql_fetch_row($result)) { echo ''; echo ''; echo ''; echo ''; echo ''; } echo '
'; echo '
ID Name Price
' . $row[0] . ' ' . $row[1] . ' ' . $row[2] . '
'; } else { // print error message echo 'No rows found!'; } // once processing is complete // free result set mysql_free_result($result); // close connection to MySQL server mysql_close($connection); ?>

If anybody has any ideas atall - please help!

Thanks
Edd

sid

(repeated for readability)

<html>
<head></head>
<body>

<?php
// open connection to MySQL server
$connection = mysql_connect('localhost', 'user', 'pass') or die ('Unable to connect!');
// select database for use
mysql_select_db('orders') or die ('Unable to select database!');

// create and execte query
$query = 'SELECT * FROM items';
$result = mysql_query($query)
or die ('Error in query: $query. ' . mysql_error());

// check if record were returned
if (mysql_num_rows($result) > 0)
{
// print HTML table
echo '<table width=100% cellpadding=10 cellspacing=0 border=1>';
echo '<tr><td><b>ID</b></td><td><b>Name</b></td><td><b>Price</b></td></tr>';

// iterate over record set
// print each field
while($row = mysql_fetch_row($result))
{
echo '<tr>';
echo '<td>' . $row[0] . '</td>';
echo '<td>' . $row[1] . '</td>';
echo '<td>' . $row[2] . '</td>';
echo '</tr>';
}
echo '</table>';
}
else
{
// print error message
echo 'No rows found!';
}

// once processing is complete
// free result set
mysql_free_result($result);

// close connection to MySQL server
mysql_close($connection);
?>

</body>
</html>

0) { // print HTML table echo ''; // iterate over record set // print each field while($row = mysql_fetch_row($result)) { echo ''; echo ''; echo ''; echo ''; echo ''; } echo '
'; echo '
ID Name Price
' . $row[0] . ' ' . $row[1] . ' ' . $row[2] . '
'; } else { // print error message echo 'No rows found!'; } // once processing is complete // free result set mysql_free_result($result); // close connection to MySQL server mysql_close($connection); ?>

are you sure, that you dont have a "?", that slipped into this line

if (mysql_num_rows($result) > 0)

, to make it look like this:

if (mysql_num_rows($result) ?> 0)

What does the HTML-source code output?

eddjc

Yes I'm sure - I've checked again, it's not there.

Edd😕

bradgrafelman

Can you view the HTML source of the page in your browser, save it as a .txt file, and attach it to a post?

EDIT: Also, it's not wise to post login credentials; I've removed them in case what you posted were valid login credentials for your MySQL server.

EDIT2: Make sure this page has a .php file extension as well.

eddjc

Hi There,

I've worked out my problem - it was because I used an .html suffix instead of a .php one. It now says it's unable to connect to my MySQL server (I kept the user and pass in my copy - thank you for editing it off the site - I'd forgotten about that!) but that's another prob I'll have to work out.

Thanks!

Edd