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&revendauto=$revendauto&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); ?>
|
|||