I NEED HELP BAD

[madmindz]

Hi Guys,

I am doing a project dont know php much sO i copied this code and and it seems to work for me, the only problem is its displaying the query results vertically. What I want to achieve is an image with the model info under it , but with each image and info displayed (up to a max of 4 per each row) it should be horizontal. here is my code please help me.

<!--thumbnails of models-->
	<?php
		$sql = "SELECT * FROM MD_models ORDER BY name";
			$recordset = mysql_query( $sql ) or die (mysql_error());
				function pic_for_models($model_id) {
					$sql  ="SELECT * FROM Pictures WHERE model_id='$model_id' LIMIT 1;";
						$recordset = mysql_query ( $sql ) or die (mysql_error());
							$row = mysql_fetch_assoc( $recordset );
							return $row ['image'];
							}
							?>

							<!--the list-->

							<?php
								while ( $row=mysql_fetch_assoc ($recordset) ) {
									$image = pic_for_models( $row["id"]);
									print '<tr><td><a href="model_detail.php?id='. $row['id'].
										'"><img src="'.$image.'" width="150" border="0"><br></td>';
											print '<td><strong><a href="model_detail.php?id='
											.$row["id"].'">'
											.$row ["name"].'</a></strong><br>'.
											$row ["phone"] ."<br><a href=\"mailto:\"".
											$row["email"] ."\" >". $row["email"]."</a>\n";
											print "</td></tr>\n";
										}
										?>
										</table>

[mania]

This is the script I use. There's a chunk of the page to give you the idea. I was beating myself up and had to ask for help also.

$result= mysql_query("SELECT DISTINCT
products.company,
products.id,
pix.image,
category.cat_number,
COUNT(products.id) AS NUM
FROM category, pix, products
WHERE category.cat_number = '$array'
AND category.id = products.id
AND category.id = pix.id
GROUP BY products.id
ORDER BY products.id ASC
LIMIT ".$from.",".$result1) or die ('result error');

$count = mysql_num_rows($result);
$rows = mysql_fetch_array($result)or die (' array error');
?>
<table border="0" cellpadding="10">
<tr>
<?php

$i = 1;

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

?>
<td><a href='<?php echo $rows['company']."_".$rows['id'].".html"; ?>'><img src="<?php echo $rows['image']; ?>"width="150"></td>

<?php
if ($i%3) {
} else {
if ($i >= $count) {
} else {
echo "</tr><tr>";
}
}
$i++;
}
?>
</tr>
</table>

<?php
include 'pagebottom.html';
?>

[madmindz]

Your code seem to make a lot of sense. The trouble Is I dont know that much to incorporate it in what I already have, so I was looking more of a little modification of the code i have before I get totally confused. But reading up on the horizontal display it seems I have to use the same count method you use, the thing is How do I implement it in what I already have?

[coderWil]

If you take a look at the code I have below. It creates a new 'td' for every 'row' in the query. This is 'seperated' by a closing html row (TR) when the count for each row reaches 4. This will allow 4 products per row. I also took out the extra (TD) that seperated the image from the text, putting the text below.

Hope this helps

<?php
$sql = "SELECT FROM MD_models ORDER BY name";
$recordset = mysql_query( $sql ) or die (mysql_error());
function pic_for_models($model_id) {
$sql ="SELECT FROM Pictures WHERE model_id='$model_id' LIMIT 1;";
$recordset = mysql_query ( $sql ) or die (mysql_error());
$row = mysql_fetch_assoc( $recordset );
return $row ['image'];
}
?>

<!--the list-->
<table>
<tr>
<?php
$colcount = 0;
while ( $row=mysql_fetch_assoc ($recordset) ) {
$colcount++;
$image = pic_for_models( $row["id"]);
print '<td><a href="model_detail.php?id='. $row['id'].
'"><img src="'.$image.'" width="150" border="0"><br>';
print '<strong><a href="model_detail.php?id='
.$row["id"].'">'
.$row ["name"].'</a></strong><br>'.
$row ["phone"] ."<br><a href=\"mailto:\"".
$row["email"] ."\" >". $row["email"]."</a>\n";
print "</td>\n";
if($colcount > "4") {
print "</tr><tr>\n";
$colcount = 0;
}
}
?>
</tr>
</table>

[mania]

I'm new at PHP myself (only my 2nd post). Been looking at the forum for a while, but I joined today so that I could send you this code... I just got it last night and worked though it.

Let's see how close I can get to the code for you...
cut from your script and 'moved around some':

return $row ['image'];
}
?>

<!--the list-->

<?php
$count = mysql_num_rows($resultset); //holds the # of results to loop through
$image = pic_for_models( $row["id"]); //doesn't need to be inside the while loop

while ( $row=mysql_fetch_assoc ($recordset) ) {

?>

<tr><td><a href="model_detail.php?id='. $row['id'].
'"><img src="'.$image.'" width="150" border="0"><br></td>';
print '<td><strong><a href="model_detail.php?id='
.$row["id"].'">'
.$row ["name"].'</a></strong><br>'.
$row ["phone"] ."<br><a href=\"mailto:\"".
$row["email"] ."\" >". $row["email"]."</a>\n";

<?php

if ($i%3) {
} else {
if ($i >= $count) {
} else {
echo "</tr><tr>";
}
}
$i++;
}
?>
</tr>
</table>

[madmindz]

Thanks will it didn't work it seem well coded too, what it does now is center the results in the center instead of in a horizontal line.

coderWil wrote:

If you take a look at the code I have below. It creates a new 'td' for every 'row' in the query. This is 'seperated' by a closing html row (TR) when the count for each row reaches 4. This will allow 4 products per row. I also took out the extra (TD) that seperated the image from the text, putting the text below.

Hope this helps

[madmindz]

Thanks mania but it didn't work. :-(

mania wrote:

I'm new at PHP myself (only my 2nd post). Been looking at the forum for a while, but I joined today so that I could send you this code... I just got it last night and worked though it.

Let's see how close I can get to the code for you...
cut from your script and 'moved around some':

return $row ['image'];
}
?>

<!--the list-->

<?php
$count = mysql_num_rows($resultset); //holds the # of results to loop through
$image = pic_for_models( $row["id"]); //doesn't need to be inside the while loop

while ( $row=mysql_fetch_assoc ($recordset) ) {

?>

<tr><td><a href="model_detail.php?id='. $row['id'].
'"><img src="'.$image.'" width="150" border="0"><br></td>';
print '<td><strong><a href="model_detail.php?id='
.$row["id"].'">'
.$row ["name"].'</a></strong><br>'.
$row ["phone"] ."<br><a href=\"mailto:\"".
$row["email"] ."\" >". $row["email"]."</a>\n";

<?php

if ($i%3) {
} else {
if ($i >= $count) {
} else {
echo "</tr><tr>";
}
}
$i++;
}
?>
</tr>
</table>