[RESOLVED] Limitations in php and sql?

[storyboo]

Is there a limit to number of if statements you can have in a php file which queries the database?

I've been using a script for a year and all of a sudden the last if statement wont work:

<?php
$order = $db->select("SELECT * FROM ".$glob['dbprefix']."CubeCart_order_sum INNER JOIN ".$glob['dbprefix']."CubeCart_customer ON ".$glob['dbprefix']."CubeCart_order_sum.customer_id = ".$glob['dbprefix']."CubeCart_customer.customer_id WHERE ".$glob['dbprefix']."CubeCart_order_sum.cart_order_id = ".$db->mySQLSafe($_GET['cart_order_id'])." AND ".$glob['dbprefix']."CubeCart_order_sum.customer_id=".$db->mySQLsafe($ccUserData[0]['customer_id']));

$prod_total = $order[0]['prod_total'];
$time = $order[0]['time'];
$status = $order[0]['status'];



//////////may10-17///////////
if ($prod_total > '4.90' && $time > '1305085559' && $time < '1305863500' && $status > '1') { 
        $view_order->assign("FREEBIE_LINK",$glob['storeURL'].'/2We5t86aCq35iGmfLI1iI/pages/5may201110.html');
        $view_order->assign("FREEBIE_NAME",'FREEBIES');
	$view_order->parse("view_order.session_true.order_true.freebies");
}

if ($prod_total > '9.90' && $time > '1305085559' && $time < '1305863500' && $status > '1') {
        $view_order->assign("FREEBIE_LINK",$glob['storeURL'].'/2We5t86aCq35iGmfLI1iI/pages/may20111010.html');
        $view_order->assign("FREEBIE_NAME",'FREEBIES');
	$view_order->parse("view_order.session_true.order_true.freebies");
}

//////////may19-26///////////
if ($prod_total > '4.90' && $time > '1305864001' && $time < '1306814400' && $status > '1') { 
        $view_order->assign("FREEBIE_LINK",$glob['storeURL'].'/2We5t86aCq35iGmfLI1iI/pages/may20201105.html');
        $view_order->assign("FREEBIE_NAME",'FREEBIES');
	$view_order->parse("view_order.session_true.order_true.freebies");
}

if ($prod_total > '9.90' && $time > '13058640001' && $time < '1306814400' && $status > '1') {
        $view_order->assign("FREEBIE_LINK",$glob['storeURL'].'/2We5t86aCq35iGmfLI1iI/pages/10may202011.html');
        $view_order->assign("FREEBIE_NAME",'FREEBIES');
	$view_order->parse("view_order.session_true.order_true.freebies");
}

?>

[bradgrafelman]

storyboo wrote:

Is there a limit to number of if statements you can have in a php file which queries the database?

Nope.

storyboo wrote:

I've been using a script for a year and all of a sudden the last if statement wont work:

Well for one, you're lucky (or perhaps unlucky, in this case?) that PHP is a loosely-typed language; otherwise, you'd be getting complaints about comparisons with strings.

'9.90' is a string of 4 characters; 9.90 is a floating point number. Is 'cat' less than 'dog' ? My question doesn't make sense because I'm trying to compare two strings in a (traditionally) numeric way, which is exactly what you're doing.

As for the if() statement, if by "not working" you actually mean "doesn't evaluate to true as expected", then have you tried examining the values to make sure they are as you expect them to be?

If so, show us the values of the variables involved in that if() statement.

[storyboo]

I'm not the smoothest php coder hehe. I'm actually downright chaotic at time lol. I understand about your comment and trust me..its embarrassing as hell to share this insane code with public 🙂

that aside...As i have said that the code in this format has worked for over a year and I shortened the php code I posted becuase it is much longer and wouldnt fit. The if statement next to the last is working. But the very last 9.90 if statement does not work.

Basically I ask the script to look in the database and find all orders NOT pending that also occured within a time frame and also was for 4.90 or more or 9.90 or more and then attach a button to the order detail page to present the customer with free product if all the above is true.

What happens during a test transaction is tht even though my test order is for $20.00, im only getting the $5 freebie and not the $10 freebie at all. Never had this happen under these circumstances...usually when it doesnt work its because I had the wrong unix time stamp going on. But in this case thats not it. Its a mystery..I am getting HAMMERED with emails from customers looking for the $10 freebie item. Like 600 email in less than one hour o.O

[bradgrafelman]

Do a [man]var_dump/man on the three variables involved in that if() statement and post the output here for us to see.

[storyboo]

found out my problem was from an EXTRA 0 in the unix time stamp...god ima idiot. Yet ID10T error fo sho.

Thanks nonetheless for letting me bounce my stress around in here 🙂 Off I got to answer all of those emails!!