Newbie-Need help w/ $list & mysql_fetch_array

ethanlee1

I am a newbie that thinks this is easy, but I can't figure it out. Basically I have a shopping cart that displays images when you click on what categories you want. The images are fetched from mysql and displayed from top to bottom instead of left to right like I would like them.........please help..........here is the current code::::

<?php if($result[count]>0){ ?>
<?php
$x = 0;
while($list = mysql_fetch_array($result[result])){
?>

			<tr>
				<td colspan=3>
				<img src="images/hr.gif" width=424 height=3 border=0><br>
				</td>
			</tr>

			<?php $array = $list[pPhoto] ? $db->scalePhoto($list[pPhotoWidth], $list[pPhotoHeight]) : array("width" => "75", "height" => "75"); ?>
				<tr>
					<td valign="top" width=85>
					<a href="<?php print $PHP_SELF; ?>?m=product_detail&p=<?php print $list[pID]; ?>"><img src="<?php print $db->productIMGurl; ?>/<?php $list[pPhoto] ? print $list[pPhoto] : print "na.gif"; ?>" width=<?php print $array[width]; ?> height=<?php print $array[height]; ?> border=0></a><br>
					</td>
					<td valign="top">
					<font face="arial,verdana,helvetica" size=2>
					<b><a href="<?php print $PHP_SELF; ?>?m=product_detail&p=<?php print $list[pID]; ?>" class="link"><?php print stripslashes($list[pName]); ?></a></b><br>
							</td>
				</tr>


	<?php
			$x++;
		}
	?>

</table>

<?php } ?>

Here is the link to show what it looks like.........

http://www.backslashdesigns.com/aprelstyle/cart.php?m=product_list&c=1

THANKS IN ADVANCE FOR THE ASSISTANCE.

rachel2004

I didn't look over your code in great depth, but it seems you are missing the quotation marks for your width and heigh attributes among other things:

width=<?php print $array[width]; ?> height=<?php print $array[height]; ?>

Should be changed to:

width="<?php print $array[width]; ?>" height="<?php print $array[height]; ?>"

You may have other errors since I'm not entirely sure what is going on with the first two lines of your code where you are opening and closing PHP blocks, but I don't see the reason for it with what you've shown us.

ethanlee1

I was trying to condense the code, but here is the full version....

Thanks again for any help......I hope you understand the question though.

<?php if($result[count]>0){ ?>

<table width=700 border=0 align="center" cellpadding=2 cellspacing=0>
	<tr>
		<td colspan=2 valign="bottom">
		<font face="arial,verdana,helvetica" size=4>
		Products > <?php print stripslashes($detail[catName]); ?>
		</font>
		<br><br>
		<font face="arial,verdana,helvetica" size=2>
		Displaying <b><?php print $db->begin; ?> - <?php print $db->end; ?></b> of <b><?php print $db->count; ?></b> Products:</font>
		</font>
		</td>
		<td align="right" valign="bottom">
		<font face="arial,verdana,helvetica" size=2>
		<?php print $result[next]; ?>
		</font>
		</td>
	</tr>

	<?php
		$x = 0;
		while($list = mysql_fetch_array($result[result])){
	?>



			<tr>
				<td colspan=3>
				<img src="images/hr.gif" width=424 height=3 border=0><br>
				</td>
			</tr>

			<?php $array = $list[pPhoto] ? $db->scalePhoto($list[pPhotoWidth], $list[pPhotoHeight]) : array("width" => "75", "height" => "75"); ?>
				<tr>
					<td valign="top" width=85>
					<a href="<?php print $PHP_SELF; ?>?m=product_detail&p=<?php print $list[pID]; ?>"><img src="<?php print $db->productIMGurl; ?>/<?php $list[pPhoto] ? print $list[pPhoto] : print "na.gif"; ?>" width=<?php print $array[width]; ?> height=<?php print $array[height]; ?> border=0></a><br>
					</td>
					<td valign="top">
					<font face="arial,verdana,helvetica" size=2>
					<b><a href="<?php print $PHP_SELF; ?>?m=product_detail&p=<?php print $list[pID]; ?>" class="link"><?php print stripslashes($list[pName]); ?></a></b><br>
					<?php $list[pTeaser] ? print $db->formatText($list[pTeaser])."<br>" : print ""; ?>
					</font>
					</td>
					<td valign="top" width=100 align="right">
					<font face="arial,verdana,helvetica" size=2>
					<?php $list[pSalesPrice]>'0' && $list[pSale]=="Y" ? print " <b>Was:</b> <strike>\$$list[pPrice]</strike><br><b>Now:</b> \$$list[pSalesPrice]</font> " : print "<b>Now:</b> \$$list[pPrice]"; ?>
					</font>
					</td>
				</tr>


	<?php
			$x++;
		}
	?>

</table>

<?php } else { ?>

<table border=0 width=700 align="center">
	<tr>
		<td>
		<font face="arial,verdana,helvetica" size=2>
		<b>Sorry, there are no products found.</b>
		</font>
		</td>
	</tr>
</table>

<?php } ?>

rachel2004

Originally posted by ethanlee1
The images are fetched from mysql and displayed from top to bottom instead of left to right like I would like them.........

After your <img src... > tags, I noticed you're using <br> which will create a new line after the image is displayed. If you wish to display your graphics in a row instead of going to a new line, you just need to remove the <br> tags.

Hopefully I understood you in what you're trying to do... let me know if that fixes your problem.

ethanlee1

That makes alot of sense, but it didn't work.

I did see the line below that says

<?php $list[pTeaser] ? print $db->formatText($list[pTeaser])."<br>" : print ""; ?>

Is it possible to use <td> instead of <br> to move the pictures to across instead of down. Just a thought...I'm really don't know.

Thanks again.