Formating php output result

dhossai · #1 (**permalink**) Oct 26th, 2007, 20:18

Hi All,

Thanks to all who helped me with my past problem. But Currently I am having trouble with formating the output result. The line spacing between line is too high. I want to keep minimum height. You can look at my current file at http://www.bangladeshilivingabroad.c...n/U_number.php it is an example. How can I minimize the line space between county name? Here is my curret code..

PHP: Select all


<?
include "include/z_db.php"; 
?>
<!doctype html public "-//w3c//dtd html 3.2//en">
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>
<center>
<table>
<body bgcolor="#60B773">
<p align="center">
<object classid="clsid:D27CDB6E-AE6D-11CF-96B8-444553540000" id="obj1" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" border="0" width="90" height="215">
<param name="movie" value="1.swf">
<param name="quality" value="High">
<embed src="1.swf" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" name="obj1" width="90" height="215"></object>
</p>
<p align="center">
</p>
<span><center>User Stat</center></span>
<?
// At this point, the connection to the database is already made (mysql_connect...)
// get all countries of the database, order by countryname
$allc_query = mysql_query("SELECT DISTINCT country FROM tbl_login ORDER BY country");
while($allc_row = mysql_fetch_array($allc_query)){ 
// get the number of users from this country 
$thisc_query = mysql_query("SELECT id FROM tbl_login WHERE country LIKE '".$allc_row['country']."'"); 
$thisc_num = mysql_num_rows($thisc_query); 
// Print that! 
echo("<tr><th><font face='Times New Roman' size='2'>".$allc_row['country']."</font></th><td><font face='Times New Roman' size='2'>".$thisc_num."</font><td><tr>");
}
?>
</table>
</body>
</center>
</html>

AdRock · #2 (**permalink**) Oct 26th, 2007, 20:20

No connection to database and includes missing

dhossai · #3 (**permalink**) Oct 26th, 2007, 22:19

Hi AdRock,
Thank you for your reply but I don't have problem connnecting database, pls read my postings and check the link so you can understand what I am looking for? I want below user stat, all those country name in streched line. Thanks

AdRock · #4 (**permalink**) Oct 26th, 2007, 23:08

I noticed that you have used a table for the data.

Can you not add come css to the table so the table cells are a set height?

The other way would be to use an unordered list and style that with css to remove the bullet points. With that you could set the margins to minimise the spacing between countries.

I think the easier option for you would to try and set the <td> height using CSS

I don't use tables but a guess would be

Code: Select all

 
td {
   height: 20px; //or whatever height you want
}

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
two tables in one database, different result	ntgcmlfu	Classic ASP	5	Apr 20th, 2006 23:59
Result = 100000. How to add comma so reads: 100,000	Andy K	Flash & Multimedia Forum	0	Jan 16th, 2006 13:58
Returning result from db as a hyperlink	lobster1983	PHP Forum	2	Sep 18th, 2005 19:59
Delete All Record in a search result page?	Monie	Classic ASP	3	Nov 11th, 2004 03:27
ASP Result Field	djaccess	Classic ASP	6	Aug 28th, 2003 16:17

		Webforumz.com > Main Forums > Program Your Website > PHP Forum
Formating php output result