How do i get around this problem?

include_me

Hi there I have a page which currently displays all the product models that are in the database, but they are all displayed in 1 column down the page making it very large in size,

I used a tutorial found on here to help display the products in a 5 coulmn table but since I have added this nifty bit of code in, it doesnt call the product information from the database anymore..

Can someone point out what I have done wrong? or where I am going wrong for this to happen?

Here is my code:

<?php
$Makeid = $_GET['make'];
require('conn.php');
$m = "SELECT image, imagealt, bundleid, make, model, phoneid FROM table WHERE make = '$Makeid' ORDER BY 'model'";
$result = mysql_query($m); // execute query
$count = 0; // initialize counter
echo "<br>";
echo "<table align='center'>";
// initialize table tag, this string will hold the html output table withe all the records
// loop thru the records
while ($row = mysql_fetch_array($result)) {
$count++;
}
echo "<tr>";
for($x=1; $x<=$count; $x++) {
$row = mysql_fetch_array($result);
echo "<td valign='middle'><a href='phone-{$row['phoneid']}.php'><img src='/_images/" .$row['image'] ."' width='33' height='68' alt='".$row['imagealt'] ."' border='0'></a>" .'      ' . "<a href='phone-".$row['phoneid'].".php' title='" .$row['make'] .' ' .$row['model']." Mobile Phone'>".$row['make'].' '.$row['model'].":</a>".'  '."<script type='text/javascript' src='http://www.phones2udirect.co.uk/_js/bundleprice.asp?BundleID=".$row['bundleid']."'>"."</script>" ."<a href='http://www.phones2udirect.co.uk/shop/action/add/BundleID/".$row['bundleid'] ."' title='Buy Now'>" ."<br>" ."<img src='_images/buy.jpg' border='0' alt='Buy Now'>"."<br>"."<br>"  ."</a>". "</td>"; // add fields if necessary
if($x % 5 == 0) {
echo '</tr><tr>';
}
}
echo '</tr></table>';
mysql_close();
echo "<br>";
echo "  $count $make product(s) found.";
echo "<br>";
echo "<br>";
?>

Any help would be really helpful, Thanks
Chris

halojoy

Hard to say.

Think it is, as usual, a php/mysql interaction problem in your code.
There are 3 programs, .EXE / .BIN, in your computer, that should work together:
apache.exe
php.exe
mysql.exe

You get any notices or error reports?
From php?
From mySQL?

I assume you have error_reporting set to E_ALL ...l

<?php
// top of your page
// debug setting while coding your php
error_reporting( E_ALL );

// rest of your code

?>

include_me

No i dont get any errors, i get the buy buttons and the cells are all laid out correctly but the details in the array which is made from the database query are not being shown..

Chris

halojoy

that is some info
try to dig out more info on what is going on (or not) in your script

have a look at source code of displayed page
might give us a hint

vaaaska

Originally posted by include_me
No i dont get any errors, i get the buy buttons and the cells are all laid out correctly but the details in the array which is made from the database query are not being shown..

Chris

Have you tried viewing the source code as it's rendered on the page. It's possible that the real problem is simply the formatting of your html (table). Another thing to consider...

But yeah, there isn't really enough information for us to tell...

Another thing, just after your query use a print_r to see if it's really giving you results...