Two Column Listing/Directory

[murraywl]

I'm working with a MySQL database using PHP and I have come across a requirement to display data in two column rows like:

Record 1 Record 5
Record 2 Record 6
Record 3 Record 7
Record 4

Each record has 5 fields to display in the following format:
1-title 2-firstname 3-lastname 4-telephone
5-email address

What is the proper syntax to display?

I have taken a look at similar threads, but they do not seem to address this requirement.

[[deleted]]

Something like this should do it (it works for me):

<table border=0>
<tr><td valign=top><ul>
<?
$sqlcount = mysql_query("SELECT id FROM sometable");
$tcount = mysql_num_rows($sqlcount);
$rcount = $tcount/2;
$rcount = sprintf("%.0f", $rcount);
//echo $tcount."<br>";
//echo $rcount;
$cresult = mysql_query("SELECT fields FROM sometable");
global $i;
while ($cdata=mysql_fetch_array($cresult)) {
    	printf("<li>yourdata</li>\n");
	$i++;
	if ($i==$rcount) { echo "</ul></td><td valign=top><ul>"; }
}
?>
</ul></td></tr></table>

YMMV.

[murraywl]

I placed the code in it's space, and it's counting the proper number of records for the recordset, but the display is either blank or filled with regular text. Here is the code used:

<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td valign="top" width="50%"><ul>
<?
$sqlcount = mysql_query("SELECT section, title, firstname, lastname, telephone FROM smmbc_directory WHERE section = '1'");
$tcount = mysql_num_rows($sqlcount);
$rcount = $tcount/2;
$rcount = sprintf("%.0f", $rcount);
//echo $tcount."<br />";
//echo $rcount;
$cresult = mysql_query("SELECT section, title, firstname, lastname, telephone FROM smmbc_directory WHERE section = '1'");
global $i;
while ($cdata=mysql_fetch_array($cresult)) {
printf("<li>$cdata['title'] $cdata['firstname'] $cdata['lastname']<br /> $cdata['telephone'] $cdata['email']</li>\n");
$i++;
if ($i==$rcount) { echo "</ul></td><td valign=top><ul>"; }
}
?>
</ul>
</td>
</tr>
</table>

What have I missed?

Thanks!!!!

[[deleted]]

Show me a sample of the output. Preferably the one with regular text in it. I think it is likely something in your printf statement.

[murraywl]

http://www.smmbcnet.org/html/contactusNew.php

The data above the listing is what needs to be displayed.

Thanks for your help!!!

warren l

[kevinsequeira]

could u post the php code u have written

reg
kevin

[murraywl]

<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td valign="top" width="50%"><ul>
<?
$sqlcount = mysql_query("SELECT section, title, firstname, lastname, telephone FROM smmbc_directory WHERE section = '1'");
$tcount = mysql_num_rows($sqlcount);
$rcount = $tcount/2;
$rcount = sprintf("%.0f", $rcount);
//echo $tcount."<br />";
//echo $rcount;
$cresult = mysql_query("SELECT section, title, firstname, lastname, telephone FROM smmbc_directory WHERE section = '1'");
global $i;
while ($cdata=mysql_fetch_array($cresult)) {
printf("<li>$cdata['title'] $cdata['firstname'] $cdata['lastname']<br /> $cdata['telephone'] $cdata['email']</li>\n");
$i++;
if ($i==$rcount) { echo "</ul></td><td valign=top><ul>"; }
}
?>
</ul>
</td>
</tr>
</table>

[kevinsequeira]

instead of
printf("<li>$cdata['title'] $cdata['firstname'] $cdata['lastname']<br /> $cdata['telephone'] $cdata['email']</li>\n");

try this

print("<li>".$cdata['title'] ." ".$cdata['firstname'] ." ".$cdata['lastname']."<br/>".$cdata['telephone']." ".$cdata['email']."</li>\n");

reg
kevin

[murraywl]

It works and sweet it is. If you have a moment, please if you could explain what the quotation marks and periods are doing.

Thanks!!!

Warren L

[kevinsequeira]

well its pretty simple, u were using printf() instead of using print()

u can look up the manual to see the differance

http://ca.php.net/manual/en/function.print.php

printf

http://ca.php.net/manual/en/function.printf.php

the " and . is just used to add the strings together

eg

$var = "world";
print ("hello".$world);

so im joining "hello" and $var using .

reg
kevin