QUERY :

[at_rcc]

$num_stud = nuRunQuery("SELECT count(customer_id)FROM tbl_batch_stud WHERE customer_id='$cust_id' and batch_id= '$my_batch'");

Hi the variable $num_stud is not storing the value integer it should get?
any idea ?

[admin]

nuRunQuery wont directly give you count(customer_id).

Code: Select all

$t                 = nuRunQuery("SELECT count(customer_id) FROM tbl_batch_stud WHERE customer_id='$cust_id' and batch_id= '$my_batch'");
$r                 = db_fetch_row($t);
$num_stud          = $r[0];

Steven

[at_rcc]

THANK YOU VERY MUCH mr Steven , you are really a Geek