product retrieval

[Anon]

I am trying to figure out how to retrieve products from the database so they would come up 3 or 4 in a row and then continue processing in this format until there where now more products? I can get it to work if I use include pages, but then I have to have a page for each row and know there has to be a better way to accomplish this.

ex.

1, 2, 3, 4
5, 6, 7, 8. so on...

Can anyone help me with this??

Thank you,

Brett Taylor

[paulblo]

Yes I see, you will want to use a for loop.
what I usually do is get the number of products query with "mysql_affected_rows();" then decide how many columns you would like "$col" do a little math wich will divide the products evenly and start your for statment.

$query = "SELECT id, name, image, price FROM products ORDER BY name";
$result = mysql_query($query);

$num = mysql_affected_rows();
$col = 3;
$total = $num / $col;

for($count=1; $count<=$col; $count++){

print"<TD NOWRAP WIDTH=\"33%\">";

for($count2=0; $count2<=$total; $count2++){
	$fun = mysql_fetch_object($result);
	print"<a href=\"$CF->wwwroot/products/details.php?id=$fun->id\"> $fun->name</a><br>"; 

}

print"</TD>";

}

I hope this helped.

Paul

[Anon]

Paul,
Thanks for replying so quickly. I tried implimenting this and got it to work somewhat. The problem I am having is that it only grabs one product in the database where there are six. It also queries for 9 spaces with something in each space, but I am assuming that it probably will try to put something in an empty space if the query doesn't come out even?

Here is what I did, maybe you can look to see what maybe I did wrong? Thanks for your help.

There was one line:
$fun = mysql_fetch_object($result);
I couldn't figure out what this would be referencing? Maybe this is the problem?

Brett

<?
$db_name = "madewithcare_ws";
$table_A = "Baskets";

$connection = @mysql_connect("localhost", "crafts", "8kksDR4t") or die("Couldn't connect");
$db = @mysql_select_db($db_name, $connection) or die("couldn't select database");

$sql = "SELECT BasketID,
BasketName,
BasketPrice,
BasketImageThumbnail
FROM $table_A
ORDER BY BasketName
";

$result = @($sql);

while ($row = mysql_fetch_array($result)) {
$BasketID = $row['BasketID'];
$BasketName = $row['BasketName'];
$BasketPrice = $row['BasketPrice'];
$BasketImageThumbnail = $row['BasketImageThumbnail'];
}

$num=mysql_affected_rows();
$col=3;
$total=$num/$col;

for($count=1; $count<=$col; $count++) {
print("<td nowrap width=\"33%\" align=center class=\"new\">");

for($count2=0; $count2<=$total; $count2++) {
	$fun = mysql_fetch_object($result);
	print("<img src=\"graphics/$BasketImageThumbnail\" border=0>
		<br><a href=\"basket_info.php?BasketID=$BasketID\">$BasketName</a>
		<br>\$$BasketPrice
		<hr size=1 width=\"90%\" color=\"silver\">");
	}
	print("</td>");
}

?>

[paulblo]

Let me guess the "1" product that it is pulling out is accually the last one.? right?

The problem is you loop through the products from the Mysql table first than the PHP engine goes down from ther to the for loop. But because the $array: BasketID = $row etc..
will only contain the value of the last product. Do you understand now what is happening?

The actual for loop should contain the $row = mysql_fetch_array($result) so it can loop through all of the products.

Hope this helps.

good luck Paul

[paulblo]

for($count=1; $count<=$col; $count++){

print"<TD NOWRAP WIDTH=\"33%\">";

for($count2=0; $count2<=$total; $count2++){
	$row = mysql_fetch_array($result)) 		print("<img src=\"graphics/$BasketImageThumbnail\" border=0> 

<br><a href=\"basket_info.php?BasketID=$BasketID\">$BasketName</a>
<br>\$$BasketPrice
<hr size=1 width=\"90%\" color=\"silver\">");

}



print"</TD>";

}

Here is what it should look like...

Paul

[btaylor]

Thank you for all your help. I finally got it to work. There is one more thing. Currently it queries 3 items pr column. Since there are only 6 products, the first two columns fill up, with three each and then it leave the 3rd column empty with missing information tags. Is there a way to to have only two rows with three items in each row:
1 2 3
4 5 6

instead of:

1 4 ?
2 5 ?
3 6 ?

again, thanks for your help.

Brett

[paulblo]

Yes there is... Show me the code and we will make some ajustments to it..

For faster response feel free to email me at [e-mail]. Feel free to atach a text/HTML file to the email. We can get you up and running.

The rows can be done any way really.

email me with the code,

Paul