Dropping Data into 2 columns of and HTML

[Anon]

I have done a few searches on this and can not seem to come up with anything that is an answer to what I am trying to do.

I need data from a MySql db to populate the left then the right column of a single HTML table and repeat this until the entire contents of the MySql table have been displayed --- and I want to have this only display in 10 row incriments -- then put thos little numbers at the bottom for "pages".

This ithe the table that I have working but it is only a single column:

$i = 0;

while ($i < mysql_num_rows($mysql_result)) 

{







$name = mysql_result($mysql_result,$i,"name");	

$company_name = mysql_result($mysql_result,$i,"company_name");

$address = mysql_result($mysql_result,$i,"address");

$city = mysql_result($mysql_result,$i,"city");

$state = mysql_result($mysql_result,$i,"state");

$zip = mysql_result($mysql_result,$i,"zip");

$a_c = mysql_result($mysql_result,$i,"a_c");

$prefix = mysql_result($mysql_result,$i,"prefix");

$suffix = mysql_result($mysql_result,$i,"suffix");

$email = mysql_result($mysql_result,$i,"email");

print("<TABLE WIDTH=\"100%\" CELLSPACING=\"1\">\n");

	print("<TR>\n");

	  print("<TD COLSPAN=\"3\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$name</TD>\n");

	print("</TR>\n");

	print("<TR>\n");

	  print("<TD COLSPAN=\"3\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$company_name</TD>\n");

	print("</TR>\n");

	print("<TR>\n");

	  print("<TD COLSPAN=\"3\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$address</TD>\n");

	print("</TR>\n");

	print("<TR>\n");

	  print("<TD COLSPAN=\"3\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$city</TD>\n");

	print("</TR>\n");

	print("<TR>\n");

	  print("<TD COLSPAN=\"3\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$state</TD>\n");

	print("</TR>\n");

	print("<TR>\n");

	  print("<TD COLSPAN=\"3\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$zip</TD>\n");

	print("</TR>\n");

	print("<TR>\n");

	  print("<TD COLSPAN=\"3\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">($a_c) $prefix - $suffix</TD>\n");

	print("</TR>\n");

	print("<TR>\n");

	  print("<TD COLSPAN=\"3\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\"><A HREF=\"mailto:$email\">$email</A></TD>\n");

	print("</TR>\n");

	print("<TR>\n");

	  print("<TD>&nbsp;</TD>\n");

	print("</TR>\n");

 print("</TABLE>\n");

$i ++;

}

I am a newbie at this so any help would be appreciated

[ccgorman]

//start by positioning the query
$limit=10;
if (!$start) {
$start=0;
}

$table="your_table";
$query="SELECT * FROM $table";

//get the total rows
$result=MYSQL_QUERY($result);
$total_rows=mysql_num_rows($result);

//now limit to ten
$query.=" LIMIT ".$start.", ".$limit."";
$result=MYSQL_QUERY($result);

while ($details=mysql_fetch_array($result)) {
//save yourself a bit of server load here
$name=$details["name"];
//and the rest
$email=$details["email"];

//print table as you do

}

//Now display the next, back, or whatever else and pass the start variable

<table width="100%"><tr><td width="33%"><?
if ($start>=$limit) {
PRINT"<a href=\"index.php?start=".($start-$limit)."\">Back</a>";
}
?></td>
<td width="34%" align="center"><?
if ($limit<$num_rows) {
//ok you can do this bit
}
?></td>
<td width="33%" align="right"><?
if (($start+$limit)<$num_rows) {
PRINT"<a href=\"index.php?start=".($start+$limit)."\">Next</a>";
}
?></td></tr></table>

[wit77]

Thanks for the limit 10 ---

I figurted out how to make the two columns bit work --- I just incrimented my while loop by 2 added another <TD> with i+1 data --- then dropped in a little if else statement to determine if it the rows were odd or even -- and it actually works ---

I suck as a programmer so I am sure there is a faster way to do this ---- but like I said ---

It WORKS!

Thanks for the posts -----

<PRE>

<?

// connect to server 
$mysql_link = mysql_connect("whatever", "whatever", "");

// select the 'some_db' database
mysql_select_db("some_db", $mysql_link);

// get zip code listing from decorator table
$query = "SELECT * FROM from_form WHERE zip >= '$zc'-10 ORDER BY zip";
$mysql_result = mysql_query($query, $mysql_link);

$i = 0;

while ($i < mysql_num_rows($mysql_result))
{



if ( ($i+1) < mysql_num_rows($mysql_result))



{

$name = mysql_result($mysql_result,$i,"name");
$company_name = mysql_result($mysql_result,$i,"company_name");
$address = mysql_result($mysql_result,$i,"address");
$city = mysql_result($mysql_result,$i,"city");
$state = mysql_result($mysql_result,$i,"state");
$zip = mysql_result($mysql_result,$i,"zip");
$a_c = mysql_result($mysql_result,$i,"a_c");
$prefix = mysql_result($mysql_result,$i,"prefix");
$suffix = mysql_result($mysql_result,$i,"suffix");
$email = mysql_result($mysql_result,$i,"email");






$name2 = mysql_result($mysql_result,$i+1,"name");
$company_name2 = mysql_result($mysql_result,$i+1,"company_name");
$address2 = mysql_result($mysql_result,$i+1,"address");
$city2 = mysql_result($mysql_result,$i+1,"city");
$state2 = mysql_result($mysql_result,$i+1,"state");
$zip2 = mysql_result($mysql_result,$i+1,"zip");
$a_c2 = mysql_result($mysql_result,$i+1,"a_c");
$prefix2 = mysql_result($mysql_result,$i+1,"prefix");
$suffix2 = mysql_result($mysql_result,$i+1,"suffix");
$email2 = mysql_result($mysql_result,$i+1,"email");



//table	

print("<TABLE WIDTH=\"500\" CELLSPACING=\"1\">\n");
	print("<TR>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$name</TD>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$name2</TD>\n");
	print("</TR>\n");
	print("<TR>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$company_name</TD>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$company_name2</TD>\n");
	print("</TR>\n");
	print("<TR>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$address</TD>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$address2</TD>\n");
	print("</TR>\n");
	print("<TR>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$city</TD>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$city2</TD>\n");
	print("</TR>\n");
	print("<TR>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$state</TD>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$state2</TD>\n");
	print("</TR>\n");
	print("<TR>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$zip</TD>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$zip2</TD>\n");
	print("</TR>\n");
	print("<TR>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">($a_c) $prefix - $suffix</TD>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">($a_c) $prefix - $suffix2</TD>\n");
	print("</TR>\n");
	print("<TR>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\"><A HREF=\"mailto:$email\">$email</A></TD>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\"><A HREF=\"mailto:$email\">$email2</A></TD>\n");
	print("</TR>\n");
	print("<TR>\n");
	  print("<TD><IMG SRC=\"/images2/shim.gif\" WIDTH=\"250\" HEIGHT=\"1\" BORDER=\"0\"></TD>\n");
	  print("<TD><IMG SRC=\"/images2/shim.gif\" WIDTH=\"250\" HEIGHT=\"1\" BORDER=\"0\"></TD>\n");
	print("</TR>\n");
 print("</TABLE>\n");

}



else

{

$name = mysql_result($mysql_result,$i,"name");
$company_name = mysql_result($mysql_result,$i,"company_name");
$address = mysql_result($mysql_result,$i,"address");
$city = mysql_result($mysql_result,$i,"city");
$state = mysql_result($mysql_result,$i,"state");
$zip = mysql_result($mysql_result,$i,"zip");
$a_c = mysql_result($mysql_result,$i,"a_c");
$prefix = mysql_result($mysql_result,$i,"prefix");
$suffix = mysql_result($mysql_result,$i,"suffix");
$email = mysql_result($mysql_result,$i,"email");




//table
print("<TABLE WIDTH=\"500\" CELLSPACING=\"1\">\n");
	print("<TR>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$name</TD>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">&nbsp;</TD>\n");
	print("</TR>\n");
	print("<TR>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$company_name</TD>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">&nbsp;</TD>\n");
	print("</TR>\n");
	print("<TR>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$address</TD>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">&nbsp;</TD>\n");
	print("</TR>\n");
	print("<TR>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$city</TD>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">&nbsp;</TD>\n");
	print("</TR>\n");
	print("<TR>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$state</TD>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">&nbsp;</TD>\n");
	print("</TR>\n");
	print("<TR>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$zip</TD>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">&nbsp;</TD>\n");
	print("</TR>\n");
	print("<TR>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">($a_c) $prefix - $suffix</TD>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">&nbsp;</TD>\n");
	print("</TR>\n");
	print("<TR>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\"><A HREF=\"mailto:$email\">$email</A></TD>\n");
	  print("<TD WIDTH=\250\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">&nbsp;</TD>\n");
	print("</TR>\n");
	print("<TR>\n");
	  print("<TD><IMG SRC=\"/images2/shim.gif\" WIDTH=\"250\" HEIGHT=\"1\" BORDER=\"0\"></TD>\n");
	  print("<TD><IMG SRC=\"/images2/shim.gif\" WIDTH=\"250\" HEIGHT=\"1\" BORDER=\"0\"></TD>\n");
	print("</TR>\n");

print("</TABLE>\n");



}

$i ++;
$i ++;

}

?>

</PRE>