[SOLVED] i think my where clause is wrong

[deansaddigh]

im getting an error and i think its my where clause

basically i want to perform an sql query based on my where clause which is the product id passed from the previous page.

 

any help would be wicked.

 

	//get the product id
          		$_GET['productid'];
          		
//**************************************************************************
			//sql statement to join tables to get products 
			$query = "select product.ProductID, product.ProductName, product.ProductCategory, product.ProductPrice, product.ProductQuantity, product.ProductDescription, image.ImageID, image.ImagePath, image.ImageName, product_image.ImageID, product_image.ProductID
			FROM product
			WHERE ProductID='productid');
			JOIN product_image
			ON product.ProductID = product_image.ProductID
			JOIN image
			ON image.ImageID = product_image.ImageID";

			//execute query or die		  
			$result = mysql_query($query, $conn)
				or die ("Unable join tables");

[rajivgonsalves]

this

//sql statement to join tables to get products
            $query = "select product.ProductID, product.ProductName, product.ProductCategory, product.ProductPrice, product.ProductQuantity, product.ProductDescription, image.ImageID, image.ImagePath, image.ImageName, product_image.ImageID, product_image.ProductID
            FROM product
            WHERE ProductID='productid');

 

 

should be

 

//sql statement to join tables to get products
            $query = "select product.ProductID, product.ProductName, product.ProductCategory, product.ProductPrice, product.ProductQuantity, product.ProductDescription, image.ImageID, image.ImagePath, image.ImageName, product_image.ImageID, product_image.ProductID
            FROM product
            WHERE ProductID='".mysql_real_escape_string($_GET['productid'])."'");

[deansaddigh]

God you help everyone, thanks again man 

 

 

[deansaddigh]

does this look correct cause its chaning everything under the line you wrote to different colours

 

//sql statement to join tables to get products 
			$query = "select product.ProductID, product.ProductName, product.ProductCategory, product.ProductPrice, product.ProductQuantity, product.ProductDescription, image.ImageID, image.ImagePath, image.ImageName, product_image.ImageID, product_image.ProductID
			FROM product
			WHERE ProductID='".mysql_real_escape_string($_GET['productid'])."'")
			JOIN product_image
			ON product.ProductID = product_image.ProductID
			JOIN image
			ON image.ImageID = product_image.ImageID";

[rajivgonsalves]

It should have been this however I don't know the syntax not to good at joins

 

//sql statement to join tables to get products
            $query = "select product.ProductID, product.ProductName, product.ProductCategory, product.ProductPrice, product.ProductQuantity, product.ProductDescription, image.ImageID, image.ImagePath, image.ImageName, product_image.ImageID, product_image.ProductID
            FROM product
            WHERE ProductID='".mysql_real_escape_string($_GET['productid'])."'"
            JOIN product_image
            ON product.ProductID = product_image.ProductID
            JOIN image
            ON image.ImageID = product_image.ImageID";
            

[deansaddigh]

Thanks man