require 'configuracoes.php';
require 'config/config.php';
// create link string that will be attached to each vehicle link
$linkstring = "&startitem=$startitem&startpage=$startpage&endpage=$endpage&VirtualAutos=$VirtualAutos&categoria=$categoria&marca=$marca&model=$model&condicao=$condicao";
// get info from database
$link = mysql_connect($dbhost, $dbuser, $dbpass);
$query = "SELECT updated FROM $dbvin ORDER BY updated DESC";
$result = mysql_db_query($dbname, $query, $link);
$result = mysql_fetch_array($result);
$date = date(' d \d\e M \d\e Y \à\s g:i a', $result[updated]);
$query = "SELECT COUNT(*) FROM $dbvin";
$result = mysql_db_query($dbname, $query, $link);
$result = mysql_fetch_array($result);
$count = $result[0];
$result = mysql_db_query($dbname, "SELECT email, phone FROM $dbcfg", $link);
$contact = mysql_fetch_array($result);
mysql_close($link);
// build search query string if neccessary
if($categoria || $marca || $model || $condicao) {
// build query string
$query = "SELECT * FROM $dbvin WHERE";
if($categoria) { $query .= " categoria='$categoria' AND"; }
if($marca) { $query .= " marca='$marca' AND"; }
if($model) { $query .= " model LIKE '%$model%' AND"; }
if($condicao) { $query .= " condicao='$condicao'"; }
// trim extra AND if neccessary
if(substr($query, strlen($query)-4, 4) == ' AND') { $query = substr($query, 0, strlen($query)-4); }
} else {
$query = "SELECT * FROM $dbvin";
}
// get number of results
$link = mysql_connect($dbhost, $dbuser, $dbpass);
$result = mysql_db_query($dbname, $query, $link);
if(mysql_num_rows($result)) { $numitems = mysql_num_rows($result); }
else { $numitems = 0; }
mysql_close($link);
?>
SORRISO MOTOS - ESTOQUE
|
|
|
|
|
|
require 'rodape_index.php'; ?> |
|