Using tables to display restults

ragrim

Hi,

ive just started working with PHP and mysql trying to learn it so i can have a database on my website.

ive got my php getting info from my database but i want to format it a bit to put it in tables, ive done alot of google searching and found lots of results but none of which work for me, also they dont explain what the code they provide is for.

i was hoping someone could show me or point me in the direction of a web site that will teach me how to display the following code in a 2x2 table.

while ($row = mysql_fetch_array($result)) {
echo '<p>' . $row['MonsterName']  . $row['Attack'] . '</p>';
}

Thanks in advance 🙂

kkobashi

$hostname = "Your hostname here";
$username = "Your username here";
$password = "Your password here";
$dbName = "Your database name here";

$dbId = mysql_connect($hostname, $username, $password);
$ret = mysql_select_db($dbName, $dbId);
$sql = "Your SQL Query Here";
$queryResult = mysql_query($sql, $dbId);
$numRecs = mysql_num_rows($queryResult);

if ($numRecs > 0) {

echo "<table class="MonsterTable">";
while ($row = mysql_fetch_array($queryResult)) {
echo "<tr>";
echo "<td>" . $row['MonsterName'] . "</td>";
echo "<td>" . $row['Attack'] . "</td>";
echo "</tr>";
}
echo "</table>";
}

ragrim

Thanks for the reply!

I tried using that code and changing a few things but im getting errors, so i must be missing something here cause i dont understand what the problem is.

im getting.

Parse error: syntax error, unexpected T_STRING, expecting ',' or ';'

the line it refered to is

echo "<table class="MonsterTable">";

kkobashi

change it to:

echo "<table class='MonsterTable'>";

ragrim

Cool, that works!

Why did i get that error? is it my PHP version?

kkobashi

I typed the code in wrong - it has nothing to do with the PHP version or compiler.

The entire string is:
"<table class='MonsterTable'>"

Double quotes are used to mark the beginning and end of a variable string. The compiler coughed up an error (which it should have) on my typo.

ragrim

ah ok, ive been following alot of guides and tend to run into errors alot even when i copy paste, so i was wondering if i was using a diff php version or something, i guess people just make alot of typos hehe.

thanks again,

now i have to work out how to add a heading for each column :S