Displaying item by brand?

[include_me]

Hi there, I am designing a review site and im still learning PHP, I have been able to make my own mini CMS system to keep it up to date and each product is displayed by querying a database like: review.php?reviewid=34

What i want to do is make a page like called brand.php which when given a query such as brand.php?brandid=1 would return a page with a table of all products which are made by the same brand?

But what i really want to do is make them all appear in a table which is say 4 products across and just keeps going down the page? Could anyone give me a few hints of how i would get them to display in a table/div table with 4 products across?

Or if anywhere knows of any tutorials where i can learn to do it i would be really thankful!

Thanks
Chris!

[edcellgavin]

perhaps this can help

<?php
// brand.php
$brandID = addslashed($_GET['brandid']);
$db = mysql_connect(...); // open db connections
$query = "SELECT field1, field2 from Products WHERE BrandID = '$brandID'"; // build query string
$result = mysql_query($query, $db); // execute query
if (mysql_num_rows($result) > 0) { // check if recordset has at least 1 record
$count = 0; // initialize counter
$string = "<table>"; // initialize table tag, this string will hold the html output table withe all the records
// loop thru the records
while ($row = mysql_fetch_object($result)) {
$string .= "<tr>";
$string .= "<td>" . $row['field1'] . "</td>"; // add fields if necessary
$string .= "<td>" . $row['field2'] . "</td>";
$string .= "</tr>";
$count++;
}
$string .= "</table>"; // close table tag
echo "$count product(s) of brandid '$brandID' found.";
echo $string;
}
?>

[include_me]

Thanks edcellgavin, that has worked as far as displaying how many products are contained within that makeid but for some reason it doesnt show a table with all the contents that i want displayed...

Can you see a problem with my code?

<?php
$Makeid = $_GET['make']; 
require('conn.php'); 
$m = "SELECT * FROM table1 WHERE make = '$Makeid'";
$result = mysql_query($m); // execute query  

$count = 0; // initialize counter 
$string = "<table>"; // initialize table tag, this string will hold the html output table withe all the records 
// loop thru the records
mysql_close(); 
while ($row = mysql_fetch_object($result)) { 
$string .= "<tr>"; 
$string .= "<td>" . $row['make'] . "</td>"; // add fields if necessary 
$string .= "<td>" . $row['model'] . "</td>"; 
$string .= "</tr>"; 
$count++; 
} 
$string .= "</table>"; // close table tag 
echo "$count product(s) found."; 
echo $string;
?>

This is really annoying me i have been trying all morning :S

Thanks,
Chris

[edcellgavin]

why'd you close the db connection all of a sudden? try moving it after you have fetched the records. also, try try to print your query on the screen to countercheck if the executed query was valid or checking the number of rows of your recordset with:
print mysql_num_rows($result);

[include_me]

I have closed the database towards the end, but it still does not show any details.. It all looks perfect though..

<?php 
$Makeid = $_GET['make'];  

require('conn.php');  

$m = "SELECT * FROM table1 WHERE make = '$Makeid'"; 
$result = mysql_query($m); // execute query   

$count = 0; // initialize counter 
$string = "<table>"; // initialize table tag, this string will hold the html output table withe all the records 
// loop thru the records   

while ($row = mysql_fetch_object($result)) {  

$string .= "<tr>";  

$string .= "<td>" . $row['make'] . "</td>"; // add fields if necessary 
$string .= "<td>" . $row['model'] . "</td>";  

$string .= "</tr>";  

$count++;  

}  

$string .= "</table>"; // close table tag 
mysql_close();
echo "$count product(s) found.";  

echo $string; 
?> 

Any Ideas?

Thanks,
Chris

[include_me]

Ok I looked at the source code of the generated page and it has put all of the table in the page but it just hasnt filled in the data from the database...

The database already had an ID called productid but im doing the search with a different field... the "make" field.. is this why it is not working?

i tried doing a print "Hello" and that showed a loop of hellos...

im just dam confused now!

Thanks,
Chris

[Weedpacket]

 mysql_fetch_object($result))

Since you're using array access, you'd want to use mysql_fetch_array/i. (Or mysql_fetch_assoc(). I never could understand why there's one to return an object.)

[include_me]

Ahh there we go! Thanks for that one, its all working nicely now, cheers!!!

kneels down hehe