display table..!!!

avvishnu

hai.. friends... i need some helps from you people..
i tried the code

<html>
<head><title>Display Table</title></head>
<body>
<?php
$database="temp"; /* DB name */
$host="localhost";
$user="root"; /* Set DB Username */
$pass=""; /* Set DB password*/
mysql_pconnect($host,$user,$pass); /* DB connect....*/

mysql_connect ($host,$user,$pass);
@mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query( "SELECT Username,Primaryid FROM registration" )
or die("SELECT Error: ".mysql_error());
$num_rows = mysql_num_rows($result);
//print "There are $num_rows records.<P>";
print "<table width=500 border=1>\n";
while ($get_info = mysql_fetch_row($result)){
print "<tr>\n";
foreach ($get_info as $field)
print "\t<td><font face=Copperplate Gothic size=4/>$field</font></td>\n";
print "</tr>\n";
}
print "</table>\n";
?>
</body>
</html>

i need to display the table in the exact postion in the webpage. for that what i need to add.
and also i need to give some different colours for the border and rows

please help me...!!
Any assistance is much appreciated.

a v vishnu

rulian

well, what do you mean exact position? exact x,y coordinates or specific positions relative to other dynamically generated tables?

the color thing is easy

handle color switching however you like, switches, elseifs or even array manipulation, example

$colorsarray[]="#392823";
$colorsarray[]="#353453";
$colorsarray[]="#334344";
$colorsarray[]="#365665";

if (!isset($color)) $color=current($colorarray);
elseif (next($colorarray) !== false) $color=current($colorarray);
else {reset($colorarray); $color=current($colorarray);

avvishnu

hi friend...i need the specific positions relative to other dynamically generated tables?
for that what should i do..???
i need to print a school's details when i give a search condition. so it should be display in a specific location relative to other tables.