Need a SQL query to get the start and end date within custom module

[WebTigers]

I have a custom module that I've written and I need to get the order service start date and end date from the within the module's CreateAccount function. I know this is probably a trivial query for someone with knowledge of the DB schema, but for me it will take a while. I'll pay someone $25 to correctly show me how to get this and write me the query.

 

-Beau, WebTigers

[sentq]

function xxxx_CreateAccount($vars){
 
# Get Service Information
$serviceinfo = full_query("SELECT * FROM `tblhosting` WHERE `id`='" . $vars['serviceid'] . "'");
$serviceinfo = mysql_fetch_array($serviceinfo);
$startdate = $serviceinfo['regdate'];
$enddate = $serviceinfo['nextduedate'];
 
}
[php]