Mysql/php script problem - please help!

kingrick04 · May 6, 2007

Hello,

I am trying to display the contents of a database on a webpage, this code is currently in a .htm file (is this wrong?)

<html>

<head>

<title>The Friends Of Ulley Country Park</title>

</head>

<body>

<p><center>Nature Collection</center></p>

<?php

// Make a MySQL Connection

mysql_connect("ulley@localhost", "ulley_ulley", "passwordhere") or die(mysql_error());

mysql_select_db("ulley_wildlife") or die(mysql_error());

// Get all the data from the "example" table

$result = mysql_query("SELECT * FROM Creature")

or die(print ($result));

echo "<table border='1'>";

echo "<tr> <th>CreatureID</th> <th>CreatureEngName</th> </tr>";

// keeps getting the next row until there are no more to get

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

// Print out the contents of each row into a table

echo "<tr><td>";

echo $row['CreatureID'];

echo "</td><td>";

echo $row['CreatureEngName'];

echo "</td></tr>";

}

echo "</table>";

?>

<script type="text/javascript" src="/i.js"></script></body>

</html>

Nothing is displayed on the page, please help, i am new to this!

Thanks

paul2463 · May 6, 2007

yes for php script to run it has to be a php page

Recommended Posts