[SOLVED] loops and MySQL

[hyeteck]

hey guys,

 

i have a piece of code from my program that is not functioning the way i want it to.  It is not going into the "if" statement.

$result = mysql_query("SELECT * from `products` WHERE pID='prodId' ") or die(mysql_error());

	if($row = mysql_fetch_array($result))
	{
		echo "$prodId";
		if($prodMap > 0 || $prodMap!= NULL)
			$prodPrice = $prodMap;
		elseif($prodPrice < 10)
			$prodPrice = $prodPrice + ($prodPrice * .50);
		elseif($prodPrice >= 10 && $prodPrice < 50)
			$prodPrice = $prodPrice + ($prodPrice * .25);
		elseif($prodPrice >= 50 && $prodPrice < 150)
			$prodPrice = $prodPrice + ($prodPrice * .15);
		elseif($prodPrice >= 150 && $prodPrice < 400)
			$prodPrice = $prodPrice + ($prodPrice * .10);
		elseif($prodPrice >= 400 && $prodPrice < 100)
			$prodPrice = $prodPrice + ($prodPrice * .06);
		else
			$prodPrice = $prodPrice + ($prodPrice * .05);

		$prodPrice = floor($prodPrice);
		$prodPrice = $prodPrice + 0.99;

		$result = mysql_query("UPDATE `products` SET `pPrice`='$prodPrice', `pInStock`='$prodQuant' WHERE `pID`='$prodId' ");
	}

basically, i want it to go into the "if" statement if the product id exists in the database already.

 

any ideas

[sspoke]

strange but could work replace

 

if($row = mysql_fetch_array($result))

 

to

 

while($row = mysql_fetch_array($result))

 

[only one]

$result = mysql_query("SELECT * from `products` WHERE pID='prodId' ") or die(mysql_error());

	while($row = mysql_fetch_array($result))
	{
		echo "$prodId";
		if($prodMap > 0 || $prodMap!= NULL)
			$prodPrice = $prodMap;
		elseif($prodPrice < 10)
			$prodPrice = $prodPrice + ($prodPrice * .50);
		elseif($prodPrice >= 10 && $prodPrice < 50)
			$prodPrice = $prodPrice + ($prodPrice * .25);
		elseif($prodPrice >= 50 && $prodPrice < 150)
			$prodPrice = $prodPrice + ($prodPrice * .15);
		elseif($prodPrice >= 150 && $prodPrice < 400)
			$prodPrice = $prodPrice + ($prodPrice * .10);
		elseif($prodPrice >= 400 && $prodPrice < 100)
			$prodPrice = $prodPrice + ($prodPrice * .06);
		else
			$prodPrice = $prodPrice + ($prodPrice * .05);

		$prodPrice = floor($prodPrice);
		$prodPrice = $prodPrice + 0.99;

		$result = mysql_query("UPDATE `products` SET `pPrice`='$prodPrice', `pInStock`='$prodQuant' WHERE `pID`='$prodId' ");
	}

 

use a while loop not an if...

[hyeteck]

i have an "else" clause with the "if" so i need an if there....any other way of checking if the product ID exists in the database?

[sspoke]

if it exists in the loop it will go there if it doenst exist it wont even go anywhere

 

to make it simple everytime inside that while loop exists  nothing that doesnt exist never goes in that loop

plus i dont see any else  other than the nested one

[JJohnsenDK]

<?php
$result = mysql_query("SELECT * from `products` WHERE pID='prodId' ") or die(mysql_error());
if(!$result){
echo "product key doesnt exist";
}else{	
	while($row = mysql_fetch_array($result))
	{
		echo "$prodId";
		if($prodMap > 0 || $prodMap!= NULL)
			$prodPrice = $prodMap;
		elseif($prodPrice < 10)
			$prodPrice = $prodPrice + ($prodPrice * .50);
		elseif($prodPrice >= 10 && $prodPrice < 50)
			$prodPrice = $prodPrice + ($prodPrice * .25);
		elseif($prodPrice >= 50 && $prodPrice < 150)
			$prodPrice = $prodPrice + ($prodPrice * .15);
		elseif($prodPrice >= 150 && $prodPrice < 400)
			$prodPrice = $prodPrice + ($prodPrice * .10);
		elseif($prodPrice >= 400 && $prodPrice < 100)
			$prodPrice = $prodPrice + ($prodPrice * .06);
		else
			$prodPrice = $prodPrice + ($prodPrice * .05);

		$prodPrice = floor($prodPrice);
		$prodPrice = $prodPrice + 0.99;

		$result = mysql_query("UPDATE `products` SET `pPrice`='$prodPrice', `pInStock`='$prodQuant' WHERE `pID`='$prodId' ");
	}
}
?>

[hyeteck]

sorry, i should have posted a bit more of my code

 

		$approved_chunks = explode("	", $approved_string);
	$prodId = $approved_chunks[0];
	$prodPrice = $approved_chunks[1];
	$prodMap = $approved_chunks[2];
	$prodQuant = $approved_chunks[3];

	$result = mysql_query("SELECT * from `products` WHERE pID='prodId' ") or die(mysql_error());

	if($row = mysql_fetch_array($result))
	{
		echo "$prodId";
		if($prodMap > 0 || $prodMap!= NULL)
			$prodPrice = $prodMap;
		elseif($prodPrice < 10)
			$prodPrice = $prodPrice + ($prodPrice * .50);
		elseif($prodPrice >= 10 && $prodPrice < 50)
			$prodPrice = $prodPrice + ($prodPrice * .25);
		elseif($prodPrice >= 50 && $prodPrice < 150)
			$prodPrice = $prodPrice + ($prodPrice * .15);
		elseif($prodPrice >= 150 && $prodPrice < 400)
			$prodPrice = $prodPrice + ($prodPrice * .10);
		elseif($prodPrice >= 400 && $prodPrice < 100)
			$prodPrice = $prodPrice + ($prodPrice * .06);
		else
			$prodPrice = $prodPrice + ($prodPrice * .05);

		$prodPrice = floor($prodPrice);
		$prodPrice = $prodPrice + 0.99;

		$result = mysql_query("UPDATE `products` SET `pPrice`='$prodPrice', `pInStock`='$prodQuant' WHERE `pID`='$prodId' ");
	}
	else
	{

 

there is my else clause in the end.  Basically if the prodID is not in there, it goes in to the else clause where it is created...otherwise it just updates the price and quantity for that product id.

[JJohnsenDK]

hmm... just swicth the code then:

 

<?php
$result = mysql_query("SELECT * from `products` WHERE pID='prodId' ") or die(mysql_error());
if($result){
	while($row = mysql_fetch_array($result))
	{
		echo "$prodId";
		if($prodMap > 0 || $prodMap!= NULL)
			$prodPrice = $prodMap;
		elseif($prodPrice < 10)
			$prodPrice = $prodPrice + ($prodPrice * .50);
		elseif($prodPrice >= 10 && $prodPrice < 50)
			$prodPrice = $prodPrice + ($prodPrice * .25);
		elseif($prodPrice >= 50 && $prodPrice < 150)
			$prodPrice = $prodPrice + ($prodPrice * .15);
		elseif($prodPrice >= 150 && $prodPrice < 400)
			$prodPrice = $prodPrice + ($prodPrice * .10);
		elseif($prodPrice >= 400 && $prodPrice < 100)
			$prodPrice = $prodPrice + ($prodPrice * .06);
		else
			$prodPrice = $prodPrice + ($prodPrice * .05);

		$prodPrice = floor($prodPrice);
		$prodPrice = $prodPrice + 0.99;

		$result = mysql_query("UPDATE `products` SET `pPrice`='$prodPrice', `pInStock`='$prodQuant' WHERE `pID`='$prodId' ");
	}
}else {
create blabla...
}
?>

 

 

[hyeteck]

that doesn't work either.  That just makes it go in the "if" every single time no matter if the product id is in there or not and never goes into the while loop.

		$prodId = $approved_chunks[0];
	$prodPrice = $approved_chunks[1];
	$prodMap = $approved_chunks[2];
	$prodQuant = $approved_chunks[3];

	$result = mysql_query("SELECT * from `products` WHERE pID='prodId' ") or die(mysql_error());

	if($result)
	{
		echo "$prodId<br>";
		while($row = mysql_fetch_array($result))
		{
		echo "Boom!, I'm Innnnnnnnn";
		if($prodMap > 0 || $prodMap!= NULL)
			$prodPrice = $prodMap;
		elseif($prodPrice < 10)
			$prodPrice = $prodPrice + ($prodPrice * .50);
		elseif($prodPrice >= 10 && $prodPrice < 50)
			$prodPrice = $prodPrice + ($prodPrice * .25);
		elseif($prodPrice >= 50 && $prodPrice < 150)
			$prodPrice = $prodPrice + ($prodPrice * .15);
		elseif($prodPrice >= 150 && $prodPrice < 400)
			$prodPrice = $prodPrice + ($prodPrice * .10);
		elseif($prodPrice >= 400 && $prodPrice < 1000)
			$prodPrice = $prodPrice + ($prodPrice * .06);
		else
			$prodPrice = $prodPrice + ($prodPrice * .05);

		$prodPrice = floor($prodPrice);
		$prodPrice = $prodPrice + 0.99;

		$result = mysql_query("UPDATE `products` SET `pPrice`='$prodPrice', `pInStock`='$prodQuant' WHERE `pID`='$prodId' ");
		}
	}
	else
	{

[sspoke]

ok listen your while loop mysql_fetch_array($result)

 

only returns the product ids and everything that exists.. nothing that doesn't exist in database wont be put in the while loop sounds like you need to work more with SQL problem then PHP

[hyeteck]

hmm...still confused..ok so i broke down the code into pieces.

		$result = mysql_query("SELECT * from `products` WHERE pID='prodId' ") or die(mysql_error());
	$row = mysql_fetch_array($result);
	echo "testing<br>".$row['pID'];

 

that only prints the word "testing" without the product id next to it.  why?

[sspoke]

I believe  WHERE pID='prodId'

 

thats the productID?? so there is only 1 product id  replace maybe 'prodID'  with    '$prodID'

[hyeteck]

WOWOWOWOW...i can't believe...finally works.  The entire time my problem was a stupid dollar sign.

 

thanks!

[sspoke]

haha