[Vtigercrm-developers] Can't we pass two parameters for a select query?

kiran kiranraju.jakka at gmail.com
Sat Oct 1 10:01:07 GMT 2016


Hi

I'm trying to pass two parameters for a select query like below..

$adb = PearDatabase::getInstance();

    	$data = $adb->pquery("select startdate from vtiger_projecttask where
projectid = ? and projecttaskid = ?", array($projectid), array($stage));

    	$num_rows = $adb->num_rows($data);

		for($i=0; $i<$num_rows; $i++) {
			$col3[$i] = $adb->query_result($data, $i,'startdate');		
		}

But it is not allowing me to execute this query in vtiger. 
Previously i met this issue instead of finding solution i compromised with
passing single value as a parameter. Can anyone suggest me the correct way
of passing two parameters to a mysql select query?

Thanks and Regards.



--
View this message in context: http://vtiger-crm.2324883.n4.nabble.com/Can-t-we-pass-two-parameters-for-a-select-query-tp19938.html
Sent from the vtigercrm-developers mailing list archive at Nabble.com.


More information about the vtigercrm-developers mailing list