Displaying a Catalog

n0dice · 09-16-2005, 02:11 AM

Hey guys,

I'm a designer turned coder and it would seem PHP has finally warmed up to me. One thing I can't figure out is how to display a catalog with multiple columns. Obviously I would need a <tr></tr> every four <td>'s and I can't quite get it working. This is the basic method I've been using thus far.

Code:

	<?
$db = mysql_connect("localhost", "un", "pw"); 
mysql_select_db("db",$db); 
$result = mysql_query("SELECT * FROM catagories ORDER BY od asc",$db); 

while($myrow = mysql_fetch_array($result)) 
{ 

echo "CODE";
 
} 
	
?>

My initial thoughts were that I would need to add something like:

$var = 0 before the while() portion and then $var = $var + 1 at the end, and then throw in the <tr></tr> when $var = multiple of 4 or something to that effect, but again I can't get it to work properly.

Thanks for your time.

**Eric** · 09-16-2005, 02:21 AM

PHP Code:

  <?

$db = mysql_connect("localhost", "un", "pw"); 

mysql_select_db("db", $db); 

 
$result = mysql_query("SELECT * FROM catagories ORDER BY od asc",$db); 

 
while($myrow = mysql_fetch_array($result)) 

{ 

//THe below is what I typically do..

$variable = $myrow["column"];

$variable2 = $myrow["column2"];

 
echo $variable . "<br>";

echo $variable2 . "<br>";

} 

    

?>

dkin69 · 09-16-2005, 02:34 AM

if I understand correctly he wants it laid out in table form

example

row 1 | row 2 | row 3 | row 4 |
row 5 | row 6 | row 7 | row 8 |

etc

**Eric** · 09-16-2005, 03:09 AM

Quote:

Originally Posted by dkin69

if I understand correctly he wants it laid out in table form

example

row 1 | row 2 | row 3 | row 4 |
row 5 | row 6 | row 7 | row 8 |

etc

PHP Code:

  <?

$db = mysql_connect("localhost", "un", "pw");

mysql_select_db("db", $db);

 
$result = mysql_query("SELECT * FROM catagories ORDER BY od asc",$db);

 
while($myrow = mysql_fetch_array($result))

{

//THe below is what I typically do..

$variable = $myrow["column"];

$variable2 = $myrow["column2"];

 
echo "<table>

<tr>

<td>$variable</td>

<td>$variable2</td>

</tr>

</table>";

} //Something like that. Lol :p

    

?>

dkin69 · 09-16-2005, 03:26 AM

HTML Code:

<?
$db = mysql_connect("localhost", "un", "pw");
mysql_select_db("db", $db);

$result = mysql_query("SELECT * FROM catagories ORDER BY od asc limit 8",$db);
echo '<table>';
while($myrow = mysql_fetch_array($result))
{
//THe below is what I typically do..
$variable = $myrow["column"];
$variable2 = $myrow["column2"];
$variable3 = $myrow["column3"];
$variable4 = $myrow["column4"];

echo "<tr><td>$variable</td><td>$variable2</td><td>$variable3</td><td>$variable4</td></tr>";
} //Something like that. Lol :p
echo '
</table>';    
?>

There, that should give you two rows, to get more change limit 8 to 16 32 whatever.

Hope it helps

moondog · 09-16-2005, 05:41 AM

dkin69 · 09-16-2005, 11:28 AM

Quote:

Originally Posted by moondog

.

how helpful! lol.

09-16-2005, 02:11 AM	#1 (permalink)
n0dice NamePros Member Join Date: Dec 2004 Posts: 30 51.00 NP$ (Donate)	Displaying a Catalog Hey guys, I'm a designer turned coder and it would seem PHP has finally warmed up to me. One thing I can't figure out is how to display a catalog with multiple columns. Obviously I would need a <tr></tr> every four <td>'s and I can't quite get it working. This is the basic method I've been using thus far. Code: <? $db = mysql_connect("localhost", "un", "pw"); mysql_select_db("db",$db); $result = mysql_query("SELECT * FROM catagories ORDER BY od asc",$db); while($myrow = mysql_fetch_array($result)) { echo "CODE"; } ?> My initial thoughts were that I would need to add something like: $var = 0 before the while() portion and then $var = $var + 1 at the end, and then throw in the <tr></tr> when $var = multiple of 4 or something to that effect, but again I can't get it to work properly. Thanks for your time.

09-16-2005, 02:21 AM	#2 (permalink)
Eric NPQ's PA, Slave, and On Call Coder Technical Services Join Date: Mar 2005 Posts: 4,545 0.71 NP$ (Donate)	PHP Code: `<? $db = mysql_connect("localhost", "un", "pw"); mysql_select_db("db", $db); $result = mysql_query("SELECT * FROM catagories ORDER BY od asc",$db); while($myrow = mysql_fetch_array($result)) { //THe below is what I typically do.. $variable = $myrow["column"]; $variable2 = $myrow["column2"]; echo $variable . "<br>"; echo $variable2 . "<br>"; } ?>` __________________

09-16-2005, 05:41 AM	#6 (permalink)
moondog NamePros Regular Join Date: Jun 2004 Posts: 476 3,677.00 NP$ (Donate)	. __________________ The mass purge has begun.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Catalog Website	Chanesaw	Website Development	0	08-06-2005 08:14 AM
Displaying Content When A Checkbox Is Checked??	TWM	Programming	6	07-01-2005 07:58 AM
.cgi displaying as raw html in firefox	soloBRIAN	Programming	0	05-18-2005 07:19 PM
Keeps displaying eye-related ads :\|	Ringr	Google Adsense	4	04-19-2005 02:47 PM
displaying colums	adam_uk	Programming	4	07-16-2003 06:43 AM

09-16-2005, 02:34 AM	#3 (permalink)
dkin69 NamePros Regular Join Date: May 2005 Posts: 358 15.75 NP$ (Donate)	if I understand correctly he wants it laid out in table form example row 1 \| row 2 \| row 3 \| row 4 \| row 5 \| row 6 \| row 7 \| row 8 \| etc

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Technical Services

Technical Services