php in html - not showing

chimp · #1 (**permalink**) Dec 6th, 2005, 21:54

i am trying to display a mysql table in my html page have managed to round up the code to display the table data, i have saved that into a file called "mysq.php"

i have then created a very simple page just to test whether/how i get this into html....

here is what i have:

Code: Select all

<html>
<body>
This is a test to show this can be done
<?php
include(mysql.php);
</body>
</html>

however my mysql data is not displayed........the text saying test is there but nothing else...

here is my data from the "mysql.php" file

Code: Select all

<html>
<head>
<title>PHP/MySQL example</title>
</head>
<body bgcolor="white">
<center>
<table border="1">
<tr><th>Reg_No</th><th>DOB</th></tr>
<?php
$host="hostname";
$user="username";
$password="password";
# Connect to MySQL server
$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());
# Select the database
mysql_select_db("uxellaleague", $conn)
   or die(mysql_error());
# Send SQL query
$sql = "SELECT players_200506.reg_no, players_200506.dob
FROM players_200506
WHERE (((players_200506.reg_no)>0))
ORDER BY players_200506.reg_no;";
$result = mysql_query($sql)
   or die(mysql_error());
# Fetch table rows, one by one, and display as HTML table rows
while ($row = mysql_fetch_assoc($result)) {
   echo "<tr><td>", $row['reg_no'], "</td><td>", $row['dob'],
      "</td></tr>\n";
}
?>
</table>
</center>
</body>
</html>

please advise

Andy

Pheonix · #2 (**permalink**) Dec 6th, 2005, 23:14

You forgot to close your php...

PHP: Select all


<html>
<body>
This is a test to show this can be done
<?php
include(mysql.php);
?>
</body>
</html>

chimp · #3 (**permalink**) Dec 7th, 2005, 07:16

whoops!!!!! silly beginners

many thanks

sypher · #4 (**permalink**) Dec 7th, 2005, 11:36

I think we all make these mistakes at beginning. Usually from tiredness.

benbramz · #5 (**permalink**) Dec 7th, 2005, 22:43

or in my case, stupidity...lmao

Tim356 · #6 (**permalink**) Dec 9th, 2005, 00:13

That's why I find it really helpful to use colour-coding editors like dreamweaver. If you leave the tage out, you can easily tell that way.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Nav bar not showing	kaz	Web Page Design	7	Jan 25th, 2008 07:12
Photos not showing?	xkatx21x	Web Page Design	4	Oct 22nd, 2007 00:34
Why my signature is not showing???	alance	Webforumz Cafe	5	May 5th, 2006 15:52
Preload flash file in one html and start showing in other	vikaspa	Introduce Yourself	1	Apr 19th, 2006 15:36
background image not showing up in Firefox but showing in other browsers!	eskymo	Web Page Design	21	Jan 19th, 2006 23:10

		Webforumz.com > Main Forums > Design Your Website > Web Page Design
php in html - not showing