problem in split function

whitemoss

hi all,

ive got a problem with the code below that related to split function:

<? <select name="ApplicationCode" id="ApplicationCode">
					 <? $query = "Select ApplicationCode, ServiceName, MOtablename, MTtablename FROM Application order by ApplicationCode;";
						$result = mysql_query($query);
						while ($row = mysql_fetch_array($result)) 
						{ $X = $row["ServiceName"];
						  $Y = $row["ApplicationCode"];
						  $A = $row["MOtablename"]; 
						  $B = $row["MTtablename"];
					 ?>
<option value="<? echo $X; echo $A; echo $B; ?>"> <? echo $X; ?> </option> 
						<? } ?>
					 </select>
?>
----------------------------------------------------------------------------------------> 1st
 if ($ApplicationCode==$ApplicationCode)
		   { $ApplicationCode = $X$A$B;
		   	 $App = explode('', $ApplicationCode); 

			echo $ApplicationCode[];  }

?>
---------------------------------------------------------------------------------------->2nd
<?
$queryMO="SELECT COUNT(*) FROM $A WHERE DAYOFMONTH(DateSend)=DAYOFMONTH('$date') ";
				$queryMO.=" AND MONTH(DateSend)=MONTH('$date') AND YEAR(DateSend)=YEAR('$date')";
				//$queryMO.=" AND ApplicationCode=1 ";
				$resultMO=mysql_result(mysql_query($queryMO),0);
				//$rowMObalance=mysql_fetch_array($resultMObalance);
				$totalMO=$resultMO;
				$grand_totalMO=$grand_totalMO+$totalMO;

			echo "<td><div align=\"center\"><span class=\"style10\"><span class=\"style11\"><span class=\"style11\">$totalMO</span></span></span></div></td>";

			//get total MT for SMS balance

			$queryMT="SELECT COUNT(*) FROM $B WHERE DAYOFMONTH(DateSend)=DAYOFMONTH('$date') ";
			$queryMT.=" AND MONTH(DateSend)=MONTH('$date') AND YEAR(DateSend)=YEAR('$date')";
			//$queryMT.=" AND ApplicationCode=1 ";
			$resultMT=mysql_result(mysql_query($queryMT),0);
			//$rowMTbalance=mysql_fetch_array($resultMTbalance);
			$totalMT=$resultMT;
			$grand_totalMT=$grand_totalMT+$totalMT;

			echo "<td><div align=\"center\"><span class=\"style10\"><span class=\"style11\"><span class=\"style11\">$totalMT</span></span></span></div></td>";
?>
---------------------------------------------------------------------------------------------3rd

As u can see, at 1st , i put the value as <? echo $ServiceName; echo $MOtablename; echo $MTtablename;>... at 2nd, i had to split that value so that, it will display only selected ServiceName...and then the MOtablename and MTtablename, should be used at the 3rd..which is in query statement.

i 've no idea what was the problem because i tried to find it but still didnt work as expected...still got the error...so can anybody help me in finding how to solve this problem

the error: Parse error: parse error, unexpected T_VARIABLE in /home/ujie/public_html/PrepaidSMS/monthlyreport.php on line 159

thanks in advance

bpat1434

Well first things first: which line is 159?

My guess is it's this line:

$ApplicationCode = $X$A$B;

THe problem is you don't concatenate the string properly. It should probably be:
$ApplicationCode = $X.$A.$B;

~Brett

whitemoss

ok..i already modify it but still didnt work and got this error:
Warning: Empty delimiter in /home/ujie/public_html/PrepaidSMS/monthlyreport.php on line 159

line 159: $App = explode('', $ApplicationCode);

...and for the query statement, still got the error which is

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/ujie/public_html/PrepaidSMS/monthlyreport.php on line 304

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/ujie/public_html/PrepaidSMS/monthlyreport.php on line 316

i thought it must be something wrong with my query :

$queryMO="SELECT COUNT(*) FROM $App[1] WHERE DAYOFMONTH(DateSend)=DAYOFMONTH('$date') ";
				$queryMO.=" AND MONTH(DateSend)=MONTH('$date') AND YEAR(DateSend)=YEAR('$date')";
				//$queryMO.=" AND ApplicationCode=1 ";
				$resultMO=mysql_result(mysql_query($queryMO),0);
				//$rowMObalance=mysql_fetch_array($resultMObalance);
				$totalMO=$resultMO;
				$grand_totalMO=$grand_totalMO+$totalMO;

			echo "<td><div align=\"center\"><span class=\"style10\"><span class=\"style11\"><span class=\"style11\">$totalMO</span></span></span></div></td>";

			//get total MT for SMS balance

			$queryMT="SELECT COUNT(*) FROM $App[2] WHERE DAYOFMONTH(DateSend)=DAYOFMONTH('$date') ";
			$queryMT.=" AND MONTH(DateSend)=MONTH('$date') AND YEAR(DateSend)=YEAR('$date')";
			//$queryMT.=" AND ApplicationCode=1 ";
			$resultMT=mysql_result(mysql_query($queryMT),0);
			//$rowMTbalance=mysql_fetch_array($resultMTbalance);
			$totalMT=$resultMT;
			$grand_totalMT=$grand_totalMT+$totalMT;

			echo "<td><div align=\"center\"><span class=\"style10\"><span class=\"style11\"><span class=\"style11\">$totalMT</span></span></span></div></td>";

dnast

The first argument in explode() has to be a character. You can't use NULL there. You'll probably just have to set $App "manually".

$App = array($X,$A,$B);

whitemoss

ok..i already set the $App manually and it works which is displaying only $X value..but still got the problems because, wherever user select any of the services listed in the drop down menu, it just displayed the last value of $X...for example, in my drop down menu, there were 3 items which were SMS Balance, SMS Recharge and SMS Roaming.so, if user select SMS Recharge from the drop down list, so, the page should display SMS Recharge to show that, it was being selected but right now, it just displayed SMS Roaming only no matter which service being selected..and so that with the query..it just query the SMS Roaming's database which is MOroaming table and MTroaming table..

hope u understand what i'm explaining just now....

thanks so much in advance....

whitemoss

hi all,

i tried to modify my code yesterday and almost got what i wanted from my application...as u can see my coding below, in order to list the $X @ ServiceName, i have to used 'while' function but if used that, i didnt get the expected result which is as i mentioned in the previous post but if i terminated the 'while', i got the result as expected but, it just only for 1 service which is SMS Balance..means that, in the drop down menu, it only displayed SMS Balance...so, what should i do in order to solve this problem..i tried to use 'for function, but it also didnt work..
below is my edited code:

<select name="ApplicationCode" id="ApplicationCode">
<? $query = "Select ApplicationCode, ServiceName, MOtablename, MTtablename FROM Application order by ApplicationCode;";

$result = mysql_query($query);
$row = mysql_fetch_array($result); 

	$X = $row["ServiceName"];
	$Y = $row["ApplicationCode"];
	$A = $row["MOtablename"]; 
	$B = $row["MTtablename"];
?>
<option value="<? echo $X; echo $A; echo $B; ?>"> <? echo $X; ?> </option> 
</select>


-----------some coding here--------------------------------------

<?php
if ($ApplicationCode==true && $ApplicationCode==$ApplicationCode)
{ 
	$App = array($X,$A,$B); 
	echo $App[0]; }
else {
	echo "-- Please Select Service --"; }  

?>

-------------some coding here------------------------------------
<? 
//get total MO
$queryMO="SELECT COUNT(*) FROM " . $App[1] . " WHERE DAYOFMONTH(DateSend)=DAYOFMONTH('$date') ";
$queryMO.=" AND MONTH(DateSend)=MONTH('$date') AND YEAR(DateSend)=YEAR('$date')";
$resultMO=mysql_result(mysql_query($queryMO),0);
//$rowMObalance=mysql_fetch_array($resultMObalance);
$totalMO=$resultMO;
$grand_totalMO=$grand_totalMO+$totalMO;

echo "<td><div align=\"center\"><span class=\"style10\"><span class=\"style11\"><span class=\"style11\">$totalMO</span></span></span></div></td>";

//get total MT
$queryMT="SELECT COUNT(*) FROM " . $App[2] . " WHERE DAYOFMONTH(DateSend)=DAYOFMONTH('$date') ";
$queryMT.=" AND MONTH(DateSend)=MONTH('$date') AND YEAR(DateSend)=YEAR('$date')";
$resultMT=mysql_result(mysql_query($queryMT),0);
//$rowMTbalance=mysql_fetch_array($resultMTbalance);
$totalMT=$resultMT;
$grand_totalMT=$grand_totalMT+$totalMT;

echo "<td><div align=\"center\"><span class=\"style10\"><span class=\"style11\"><span class=\"style11\">$totalMT</span></span></span></div></td>";
?>