[Resolved] [Resolved] Displaying data from a database. Please help me

[hsob]

I am having trouble with displaying data from my database on my php page. I want to display the data from the database on the left hand side of a table and put buttons on the right hand side of it.I cant seem to get it working. I would really appreciate some help, please .

[zhabala]

Post here your code, which is not working.

Probably you can use CSS or in worse case TABLE layout.

Zdenek

[hsob]

<?php

$db = mysql_connect("host", "username", "password");
mysql_select_db("database",$db);

/* Performing SQL query */
$query = "SELECT * FROM ComingSoon";
$result = mysql_query($query) or die("Query failed : " . mysql_error());

/* Printing results in HTML */
while ($myrow = mysql_fetch_row($result))
	{

?>

<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<?php
echo("<br><B>Film Name:</b> $myrow[0] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ");
echo("<B>Age Rate:</b> $myrow[4]&nbsp; <br>");
echo("<B>Date Begin:</b> $myrow[1]<br>");
echo("<B>Offical Url:</b><br>$myrow[2]<br>");
echo("<B>Film Image:</b> $myrow[3]</td> <hr>");
?>
<td width="15%">
<p class="MsoNormal" align="center">
<applet code="fphover.class" codebase="./" width="68" height="24">
<param name="text" value="ADD">
<param name="url" valuetype="ref" value="comingsoon_Add.php">
<param name="effect" value="glow">
<param name="color" value="#000000">
<param name="textcolor" value="#FF0000">
<param name="font" value="Dialog">
<param name="fontstyle" value="bold">
<param name="fontsize" value="14">
<param name="hovercolor" value="#FFFFFF">
</applet></p>
<p class="MsoNormal" align="center">
<applet code="fphover.class" codebase="./" width="68" height="24">
<param name="textcolor" value="#FFFFFF">
<param name="color" value="#AABBDD">
<param name="url" valuetype="ref" value="comingsoon_Add.php">
<param name="hovercolor" value="#0000FF">
<param name="effect" value="glow">
<param name="text" value="EDIT">
</applet></p>
</td>
</tr>
</table>

	}

<?php / Free resultset /
mysql_free_result($result);

/* Closing connection */
mysql_close($db);

?>

[zhabala]

There is a starting <TD> tag missing in the following code I think:

<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1"> 
<tr> 
<?php 
echo("<br><B>Film Name:</b> $myrow[0]        "); 
echo("<B>Age Rate:</b> $myrow[4]  <br>"); 
echo("<B>Date Begin:</b> $myrow[1]<br>"); 
echo("<B>Offical Url:</b><br>$myrow[2]<br>"); 
echo("<B>Film Image:</b> $myrow[3]</td> <hr>"); 
?> 

Zdnek

[hsob]

Great thanks I just added in the <td> tag there but it didnt make any changes. The page just displays a Parse error

[zhabala]

Post it here again, the corrected one.

[zhabala]

last combined bracket should be after the <?php tag, not before.

Zdenek

[hsob]

Thats great its working now. Thank you