using html to position results

[patrick_woflian]

Hey, i have set up a website which allows users to search for other
members. This code is in php and works fine, however.. to make the
layout more attractive i was thinking of using html code segments to
position the results in a table for example. Here is the php code, any
ideas how to make the layout more attractive????

<?php
$connection = mysql_connect("sentinel.cs.cf.ac.uk","scm5sjc",
"MyPasswordGoesHere");

mysql_select_db("sjcdb",$connection) or die("failed!");

$result = mysql_query("SELECT * FROM info", $connection);

while($row = mysql_fetch_row($result)) {

$title = $row[1];
$first = $row[2];
$last = $row[3];
$age = $row[4];
$subject = $row[5];
$initial=$row[6];
$email=$row[7];

for ($i=0; $i<mysql_num_fields($result); $i++) print $row[$i]." ";
echo "\n";
print $title." ";
print $first_name." ";
print $last_name ." ";
print $age ." ";
print $subject." ";
print $initial." ";
print $email." ";

}

mysql_close($connection);
?>

Cheers
Steven

 

[Jim Moe]

Hey, i have set up a website which allows users to search for other
members. This code is in php and works fine, however.. to make the
layout more attractive i was thinking of using html code segments to
position the results in a table for example. Here is the php code, any
ideas how to make the layout more attractive????

You're just kidding, right???? How are we to view this table without
PHP???? Or Mysql???? Or database access???? Or the data in the database????
Post an URL showing your test case.

 

[Toby Inkster]

Hey, i have set up a website which allows users to search for other
members. This code is in php and works fine, however.. to make the
layout more attractive i was thinking of using html code segments to
position the results in a table for example.

How about something like this?

print "<table>\n";
while ($row = mysql_fetch_row($result))
{
$class = ($class=='a')?'b':'a';
$line = implode('</td><td>', $row);
$line = "<tr class=\"$class\"><td>$line</td></tr>\n";
}
print "</table>\n";

with this:

<style type="text/css">
TABLE { border: 2px solid; border-collpase: collapse; }
TR.a TD { color: black; background: #eee; border: 1px solid; }
TR.c TD { color: black; background: #ffd; border: 1px solid; }
</style>

 

[Toby Inkster]

TR.c TD

^^^ b

 

[Jonathan N. Little]

Toby Inkster wrote:

How about something like this?

print "<table>\n";
while ($row = mysql_fetch_row($result))
{
$class = ($class=='a')?'b':'a';
$line = implode('</td><td>', $row);
$line = "<tr class=\"$class\"><td>$line</td></tr>\n"; print $line;
}
print "</table>\n";

with this:

<style type="text/css">
TABLE { border: 2px solid; border-collpase: collapse; }
TR.a TD { color: black; background: #eee; border: 1px solid; }

<strike> TR.c TD { color: black; background: #ffd; border: 1px solid;

</style>

Small tweaks ;-)