I need help quickly!

[Bojan86]

I have a problem... Something is wrong with some code that I found online... Anyhow, this code should fetch some data from mysql database that have been previously added to it... And it shows blank table. Why, I have no idea... And here's the code.

 

[attachment deleted by admin]

[Ken2k7]

Just so you know, the chances of someone downloading your PHP attachment is not great. Post it in

tags if you want people to look at this and help.

 

One more thing, if the code is long, post only the relevant bits as most of us don't feel like reading through a book.

[Bojan86]

It's not long, I don't why I posted it in attachment...

Here you go....

 

<table width="400" border="0" align="center" cellpadding="3" cellspacing="0">

<tr>

<td><strong>View Guestbook | <a href="guestbook.php">Sign Guestbook</a> </strong></td>

</tr>

</table>

<br>

 

<?php

 

$host="localhost"; // Host name

$username="root"; // Mysql username

$password=""; // Mysql password

$db_name="test"; // Database name

$tbl_name="guestbook"; // Table name

 

// Connect to server and select database.

mysql_connect("$host", "$username", "$password")or die("cannot connect server");

mysql_select_db("$db_name")or die("cannot select DB");

 

$sql="SELECT * FROM $tbl_name";

$result=mysql_query($sql);

 

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

?>

<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">

<tr>

<td><table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">

<tr>

<td>ID</td>

<td>:</td>

<td><? echo $rows['id']; ?></td>

</tr>

<tr>

<td width="117">Name</td>

<td width="14">:</td>

<td width="357"><? echo $rows['name']; ?></td>

</tr>

<tr>

<td>Email</td>

<td>:</td>

<td><? echo $rows['email']; ?></td>

</tr>

<tr>

<td valign="top">Comment</td>

<td valign="top">:</td>

<td><? echo $rows['comment']; ?></td>

</tr>

<tr>

<td valign="top">Date</td>

<td valign="top">:</td>

<td><? echo $rows['datetime']; ?></td>

</tr>

</table></td>

</tr>

</table>

<BR>

<?php

}

mysql_close(); //close database

?>

[PFMaBiSmAd]

Do a "view source" of your blank table in your browser and tell us or post what you see.

[Bojan86]

OK, this is what it shows...

<table width="400" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td><strong>View Guestbook | <a href="guestbook.php">Sign Guestbook</a> </strong></td>
</tr>
</table>
<br>

<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td><table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td>ID</td>
<td>:</td>
<td><? echo $rows['id']; ?></td>
</tr>
<tr>
<td width="117">Name</td>
<td width="14">:</td>
<td width="357"><? echo $rows['name']; ?></td>
</tr>
<tr>
<td>Email</td>
<td>:</td>
<td><? echo $rows['email']; ?></td>
</tr>
<tr>
<td valign="top">Comment</td>
<td valign="top">:</td>
<td><? echo $rows['comment']; ?></td>
</tr>
<tr>
<td valign="top">Date</td>
<td valign="top">:</td>
<td><? echo $rows['datetime']; ?></td>
</tr>
</table></td>
</tr>
</table>
<BR>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td><table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td>ID</td>
<td>:</td>
<td><? echo $rows['id']; ?></td>
</tr>
<tr>
<td width="117">Name</td>
<td width="14">:</td>
<td width="357"><? echo $rows['name']; ?></td>
</tr>
<tr>
<td>Email</td>
<td>:</td>
<td><? echo $rows['email']; ?></td>
</tr>
<tr>
<td valign="top">Comment</td>
<td valign="top">:</td>
<td><? echo $rows['comment']; ?></td>
</tr>
<tr>
<td valign="top">Date</td>
<td valign="top">:</td>
<td><? echo $rows['datetime']; ?></td>
</tr>
</table></td>
</tr>
</table>
<BR>

[PFMaBiSmAd]

That's because the code is using the lazy-way short open tags <? that don't always work and cannot always be enabled on any particular server.

 

You will need edit the code so that all the php opening tags are <?php

[Bojan86]

It didn't even cross my mind... Thanks! Now it works! Hey, one more thing... Could I make it arrange data by date of entry? If you could give me that code, I would be more than happy...

[Ken2k7]

In your SQL, add "ORDER BY date" or whatever the date field is called.

 

If you want to order by date descendingly, then use "ORDER BY date DESC". By default, it'll order acendingly so you don't have to worry about that case.