Just Stopped Working

Tracer

Very Unusual...I had the below code implemented in a signature capture program we use in house. Everything was working fine. Once we reached 100 records in the "promos" database the code just stopped working. No changes were made. Can anyone see something that I missed? ANy help would be greatly appreciated.

Thanks,

session_start();
session_register(rxs);
session_register(profile);
session_register(signature);
session_register(totalcopay);
session_register(id);
?>
<body bgcolor="#006952">
<?
/* ----------------------------------------------------------------------------- */
//Check to see if a records exists for this patient in the promo database
//USAGE $VAR=check_promo($VAR WITH RX30 Patnbr)
function check_promo($input)
{
	// mysql_close();
	//First lets check to see which promo is active if any are
	//set the $promo_var to the active promotion
	$sqlconx = mysql_connect("localhost");
	mysql_select_db("promo");
	$sql_check_promo="SELECT * FROM config WHERE active = 1";
	$check_active=mysql_query($sql_check_promo, $sqlconx);
	IF (mysql_num_rows($check_active) < 1)
	{   echo "<SCRIPT LANGUAGE=\"JavaScript\">closeWindow();</SCRIPT>";
		$id=$input;
		include('promo_exists.php');	  }
	else 
	{
		$promo_vars=mysql_fetch_array($check_active);
		$promo_var=$promo_vars[promo_var];
		$promo_descr=$promo_vars[descr];
		//Now we see if the records exist
		$sqlpromo = "SELECT rx30id FROM promos WHERE rx30id = $input AND $promo_var = 1 OR $promo_var = 2";
		$check=mysql_query($sqlpromo, $sqlconx); 
	}
	IF (mysql_num_rows($check) < 1)
	{   

		echo "<SCRIPT LANGUAGE=\"JavaScript\">closeWindow();</SCRIPT>";
		echo "<CENTER><br><h2>This patient has not yet recieved the current active promotion</h2><br></CENTER>";
		echo "<CENTER><h1> $promo_descr </h1></CENTER>";
		echo 	"<CENTER><TABLE BORDER=0 WIDTH=100%><TR>";
		echo 	"<TD><FORM name=promo action=\"sql_from_promo.php\" method=post>
				<INPUT TYPE=HIDDEN NAME=\"given\" value=\"1\">
				<INPUT TYPE=HIDDEN NAME=\"promo_var\" value=\"$promo_var\">
				<INPUT TYPE=HIDDEN NAME=\"rx30id\" value=\"$input\">
				<INPUT TYPE=SUBMIT NAME=SUBMIT VALUE=\"Included With Package\">
				</FORM></TD>";  

		echo 	"<TD><FORM name=promo action=\"sql_from_promo.php\" method=post>
				<INPUT TYPE=SUBMIT NAME=SUBMIT VALUE=\"Did Not Give\">
				<INPUT TYPE=HIDDEN NAME=\"promo_var\" value=\"$promo_var\">
				<INPUT TYPE=HIDDEN NAME=\"rx30id\" value=\"$input\">		
				<INPUT TYPE=HIDDEN NAME=\"given\" value=\"0\"></FORM></TD>";  

		echo 	"<TD><FORM name=promo action=\"sql_from_promo.php\" method=post>
				<INPUT TYPE=SUBMIT NAME=SUBMIT VALUE=\"Patient Refused\">
				<INPUT TYPE=HIDDEN NAME=\"promo_var\" value=\"$promo_var\">
				<INPUT TYPE=HIDDEN NAME=\"rx30id\" value=\"$input\">		
				<INPUT TYPE=HIDDEN NAME=\"given\" value=\"2\"></FORM></TD>";  

		echo 	"</TR></TABLE></CENTER></HTML>";
	}
	else 
	{   echo "<SCRIPT LANGUAGE=\"JavaScript\">closeWindow();</SCRIPT>";
		$id=$input;
		include('promo_exists.php');	  }
}
/* ----------------------------------------------------------------------------- */

check_promo($id);

maybl8r03

What were the behavior change prior 100 records and post 100 records - when you mean it no longer works, does it generate any errors as such or does it get trapped at the mysql_num_rows section?

Tracer

Hmm it appears that it is an SQL error.

I changed the OR to <> and all is fine...

Strange that the OR worked until the database hit 100 records, then started returning funky results....

If anyone can explain OR to me better then I am listening, maybe this is normal behaviour?

maybl8r03

If you have a table field with NULL in it that you use as a filter - sometimes it causes logic to fail and you have to do

SELECT * FROM tablename WHERE (fieldname > {$strValue} AND fieldname IS NOT NULL)

or something to that effect.

Be careful when doing math functions on these fields as well (sum, avg, max, min) also gets affected if you have null values in your table.