Need Direct Link to Service

[alinford]

I need to create a direct link to a service, and I am not very mysql literate.

 

This url puts me on the Products page:

clientarea.php?action=products

 

This is what is on the tpl, and works if I am able to feed it a service ID:

clientarea.php?action=productdetails&id={$service.id}

 

So, what I need is a mysql query to find the id of the first service on the logged in account.

Something like this (except that it works):

  $result = mysql_query("SELECT id FROM tblhosting WHERE id=".$ca->getUserID());
  $data = mysql_fetch_array($result);
  $id= $data[0];

  $ca->assign('service.id', $id);

 

Then I need to add it to my url:

clientarea.php?action=productdetails&id={$service.id}

Edited October 5, 2013 by alinford