Total Airlines

[CorporateVirtual]

Hello,

Is there any code I can use to display how many airlines we have?

Regards.

Daniel Cormack

Website : http://www.corporateva.co.uk/index.php

Email : ceo@corporateva.co.uk

[josh90]

Hello,

Perhaps you could use something like:

<?php
$querydb ="SELECT count(name) AS total FROM phpvms_airlines";
$dbrow = DB::get_row($querydb);
echo $dbrow->total;
?>

Just checks how many rows are in your phpvms_airlines table, each airline has their own row, so just counts them up.

Hope it helps

Josh

[CorporateVirtual]

Hello,

Perhaps you could use something like:

<?php
$querydb ="SELECT count(name) AS total FROM phpvms_airlines";
$dbrow = DB::get_row($querydb);
echo $dbrow->total;
?>

Just checks how many rows are in your phpvms_airlines table, each airline has their own row, so just counts them up.

Hope it helps

Josh

Thanks very much for your help, works perfect!

Regards.

Daniel Cormack

Website : http://www.corporateva.co.uk/index.php

Email : ceo@corporateva.co.uk