Queries in Action Hooks

[cyberneticos]

Hello everone,

 

¿What are the correct methods of running mysql queries in a hook function using the existing db connection?

 

For example: a select query, insert query and update query

 

It would be nice to have a guideline of what we can use in both array and non array results.

 

I?m trying to run a simple query such as this:

 

$revisionresult = mysql_query("SELECT revision FROM contract WHERE id = '1' ");

$filas = mysql_fetch_row($revisionresult );

$revisionact = $filas[0];

 

And just not getting any results.

 

Thanks!

[cyberneticos]

Got 'em: http://docs.whmcs.com/SQL_Helper_Functions

 

Thanks Matt!