About mysql query

[amol.karande]

$sql = 'SELECT `userid` FROM `tblorders` WHERE `id` = $vars["OrderID"] LIMIT 0, 30 ';

 

$sql = 'SELECT * FROM `tblclients` WHERE `id` = `$userid` LIMIT 0, 30 ';

 

I am trying to run these two queries in actionhooks.php but I am not able to run those.But same queries with hardcodes values for $ordervar`,`$userid` respectively runs perfectly .Also I have tested those variable with various combination of coates but not getting please give the the solution over it

 

thank you

[RPS]

Change "OrderID" to "OrderNumber"

 

If that doesn't work...:

 

What function within actionhooks are you using?

 

Here's the code I use to look up the reference id and client id based on invoice:

	$invoiceID = $vars['InvoiceID'];

// lookup relid & userid from the invoiceid, we will use the clientid later to send out an email
$result = mysql_query("SELECT relid,userid FROM tblinvoiceitems WHERE type='Hosting' AND invoiceid='".$invoiceID."'");

$grab_relid = mysql_fetch_row($result);
$relid = $grab_relid[0];
$clientid = $grab_relid[1];

 

Also, why specify a limit in the SQL if you should only ever return 1 client via userid?

[amol.karande]

Thank you sir I was makingmistake in where clause variable I got correct way to give it from your query as (WHERE `id` ='".$userid."'"). So now I am able to run query as my expectation.

 

Thank you