base_functions.php

<?php
function getCountries()
{
include ('db_connect.php');
$query="SELECT sa FROM sa ORDER BY sa";
$result = mysql_query($query);
// Lets loop through the result:
while($row = mysql_fetch_object($result)) {
    echo "<option value=\"$row->sa\">$row->sa</option>";
}
}

function getAIDplusone()
{
include ('db_connect.php');
$rowSQL = mysql_query("SELECT MAX(A_ID) AS max FROM coin_bases");
$row = mysql_fetch_array( $rowSQL );
$largestNumber = $row['max'];
echo $largestNumber+1;
mysql_close();
}

function getAIDplusoneroll()
{
include ('db_connect.php');
$rowSQLs = mysql_query("SELECT MAX(A_ID) AS max FROM coin_bases WHERE is_roll=1");
$row = mysql_fetch_array( $rowSQLs );
$largestNumbers = $row['max'];
echo $largestNumbers+1;
mysql_close();
}

?>