How to Insert Version Number in Footer

I'm looking into using the version number from one of my projects in the footer. I can cope with phrasing, and know how to edit the template to add what I need, but I'm stuck on how to extract the number from PT that I need.

How can I collect the latest version number, and then add it as a variable to the template?

Thanks for any help in advance...

[PitchouneN64ngc]

You need to use a query like:

SELECT version FROM product WHERE productid = 'vbprojecttools';

[mokonzi]

Thanks for the help. So far, I've been able to get this query to work:

$version = $db->query_first("
  SELECT 'versioname' 
  FROM mytable_pt_projectversion 
  WHERE projectid = 2 AND projectversiongroupid = 1 AND displayorder = 10;
");

vB_Template::preRegister('footer',array('txuversion' => $version));

But all that displays when I include the variable is array.

Am I missing something obvious?

Thanks again for the help, I'm a total noobie when it comes to programming...

[Mosh]

Originally Posted by mokonzi

Thanks for the help. So far, I've been able to get this query to work:

$version = $db->query_first("
  SELECT 'versioname' 
  FROM mytable_pt_projectversion 
  WHERE projectid = 2 AND projectversiongroupid = 1 AND displayorder = 10;
");

vB_Template::preRegister('footer',array('txuversion' => $version));

But all that displays when I include the variable is array.

Am I missing something obvious?

Thanks again for the help, I'm a total noobie when it comes to programming...

It is because it is an array of fields (in this case 1 field) you are getting back from your query.... you need to register the field, not the array, so your register line should probably look something like this:

vB_Template::preRegister('footer',array('txuversion' => $version['versioname']));

[mokonzi]

I got it working by doing this:

$version = $db->query_first("
  SELECT versionname 
  FROM mytable_pt_projectversion 
  WHERE projectid = 2 AND projectversiongroupid = 1 AND displayorder = 10;
");

vB_Template::preRegister('footer',array('version' => $version['versionname']));

I'd made one mistake, that is adding 'versioname' in ' and then versionname was spelt with one n...

Now just to select the right row...

PS, thanks for the help