asked on

PHP and tables

In the code below I have a table with 1 row and 3 colums. How is the best way to place the 3 echo statements into the table, such as the first statement in the first column, etc.
Thanks,
Michael

ASKER CERTIFIED SOLUTION

StormyWaters

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mhoggatt1

ASKER

Well that was easy enough. I thought it would be more difficult.
Thanks

jcw20

Ok here is my code :

My question is how do i change it for each record to in a separte row in a table format.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<html>
<head>
<title>Joke CMS: Manage Authors</title>
<meta http-equiv="content-type"
content="text/html; charset=iso-8859-1" />
</head>
<body>


<?php
include'header.inc.php';
$dbcnx = @mysql_connect('10.10.10.4', 'root','fireman');
if (!$dbcnx) {
exit('Unable to connect to the ' .
'database server at this time.');
}

if (!@mysql_select_db('guest')) {
exit('Unable to locate the joke ' .
'database at this time.');
}

$authors = @mysql_query('SELECT id, firstname,lastname,email,Comment FROM guest');
if (!$authors) {
exit('Error retrieving authors from database! '.
'Error: ' . mysql_error() . '');
}

while ($author = mysql_fetch_array($authors)) {
$id = $author['id'];
$firstname = htmlspecialchars($author['firstname']);
$lastname = htmlspecialchars($author['lastname']);
 $Comment = htmlspecialchars($author['Comment']);
$email = htmlspecialchars($author['email']);

echo "firstname: ".$author["firstname"]." \n";
echo "Last Name: ".$author["lastname"]." \n";
echo "email: ".$author["email"]." \n";
echo "Comment: ".$author["Comment"]." \n";
"<a href='editauthor.php?id=$id'>Edit</a> ".
"<a href='deleteauthor.php?id=$id'>Delete</a></li>";



}
?>
</ul>
<a href="newauthor.php">Add new author</a>
<a href="index.html">Return to front page</a>
</body>
</html>

StormyWaters

Shouldn't you open your own question?

jcw20

i do have my own questionopen at https://www.experts-exchange.com/questions/21444013/Php-Guest-Book-table-format-trouble.html

no anser