Add Perctage to Query

Anon

Hi,

I'm new to php, and I was wonder if someone could help me with the following situation. I have a function that add a percentage to the database price and sets the two decimal format to that new price. But I can't implement it with the below Query - A WHILE Query. Any help will be greatly appreciated.

Here is the function:

//Add Percentage & Round
//Note: percent is a Global Var
function add_percent ($price, $percent) {
$newprice = $price * (1 + ($percent/100));
return number_format($newprice,2);

Call this function by:

.add_percent($cost)

Here is the Query

case 0:
$query = "SELECT descr, cost, part_num, manu_part FROM products WHERE UPPER(descr) LIKE '%$input%'";

if ($result = mysql_query ("$query")) {
while ($row = mysql_fetch_array ($result))
{
echo "Description: ".$row[descr]." ".$row[cost]." \n";
}
}
break;

Thanks!
Sac Town

ruttiger

are you sure it's getting to the while loop? I don't see any glaring problems with the query, but might wanna put a debug print statement inside the IF block to see if the while is being called - also, try printing $query, and running it from the terminal to make sure the query is valid

lemme know if this helps - if not, i'll suggest somethin else (unless someone else gets this workin for ya)

[deleted]

Why not just let the database do it, especially if you have a while loop...
$percent=(1+($percent/100))

$query = "SELECT descr,
cost,
part_num,
manu_part,
cost*$percent as newcost
FROM products
WHERE UPPER(descr) LIKE '%$input%'";

Anon

Vincent Thanks For Your Help!

I just came back from my Spring Vacation, and I didn't get a chance to check the forum or my e-mail until today. Can you or someone else help me with one more piece of the coding - using number_format($charge,2); to set the decimal places to only 2 values (###.12).

Here is what I got now (Take a look at the //// comment statements below:

case 0:
$charge=(1 + ($percent/100));

//// How can I set the decimal places to 2, right now I //// get the price and four decimal values after the price (###.1234) I've use //// 'number_format($cost,2);' to fix this problem but I can't use it with the //// current setup.

//// This is one of the things I've Tried and It Does Not Seem To Work:
//// $charge=number_format((1 + ($percent/100)),2);

//Set Add Percentage & Round
$query = "SELECT descr, cost*$charge as newcost, part_num, vend_code, manu_part FROM products WHERE UPPER(descr) LIKE '%$input%'";
if ($result = mysql_query ("$query")) {
while ($row = mysql_fetch_array ($result))
{
echo "Product Description: ".$row[descr]." Manufactuer: ".$row[vend_code]." Manufactuer Part Number: ".$row[manu_part]." Our Part Number: ".$row[part_num]." Our Price: ".$row[newcost]." ";
}
}
break;