Jump to content


Photo

Adding additional values to a variable


  • Please log in to reply
No replies to this topic

#1 tristanlee85

tristanlee85
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 04 September 2006 - 04:44 AM

I'm trying to add some modifications to my phpBB site by getting information from a database on one of my other sites. It's pulling information correctly, but I'm having trouble adding more information to a variable. I actually so confused myself that it's going to be hard for me to explain this in propper terms.

Here is the code I have so far:

$query1="SELECT * FROM xcart_products WHERE add_date < '$today_date' && add_date > '$minus_five_days'";
		$result1=mysql_query($query1);
		$numrows1=mysql_numrows($result1);
		//echo $numrows1;
			if ($numrows1 < 2)
				{
				$latest_prod = "Latest product: ";
				}
			else
				{
				$latest_prod = "Latest products: ";
				}
		$count = 0;
		while ($count < $numrows1)
			{
			$product=mysql_result($result1,$count,"product");
			//echo $product." - ";
			$product_id=mysql_result($result1,$count,"productid");
			//The above variables will be included in: <a href="http://store.plastikracing.net/product.php?	productid={PRODUCT_ID}" target="_blank">{PRODUCT}   <img src="http://store.plastikracing.net/product_images/t_{PRODUCT_ID}.jpg" width="50" height="38"></a><br> 
			$count++;
			}

Bascially, in that loop, there is a chance that "numrows1" is going to be greater than 1. Here is what I want to do. Let's say there is 1 row in the database that matches the criteria. The information pulled from that row will be inserted into a variable like so:

$display_product = "<a href='http://store.plastikracing.net/product.php?productid=".$product_id." target='_blank'>".$product."<img src='http://store.plastikracing.net/product_images/t_".$product_id.".jpg' width='50' height='38'></a><br>";

Now, let's assume there are 2 products that match the criteria. I would like the 2nd product to be added to the end of the $display_product like so:

$display_product = "<a href='http://store.plastikracing.net/product.php?productid=".$product_id[0]." target='_blank'>".$product[0]."<img src='http://store.plastikracing.net/product_images/t_".$product_id[0].".jpg' width='50' height='38'></a><br><a href='http://store.plastikracing.net/product.php?productid=".$product_id[1]." target='_blank'>".$product[1]."<img src='http://store.plastikracing.net/product_images/t_".$product_id[1].".jpg' width='50' height='38'></a><br>";

Does anyone have any suggestions? I was looking at using implode(), but I'm no too familiar with arrays.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users