$fetch_style php values code example
Example 1: php fetch
while ($row = mysqli_fetch_assoc( $result)) {}
Example 2: php pdo fetch from db
$dbhost = @mysql_connect($host, $user, $pass) or die('Unable to connect to server');
@mysql_select_db('divebay') or die('Unable to select database');
$search = $_GET['searchdivebay'];
$query = trim($search);
$sql = "SELECT * FROM auction WHERE name LIKE '%" . $query . "%'";
if(!isset($query)){
echo 'Your search was invalid';
exit;
}
$result = mysql_query($trim);
$numrows = mysql_num_rows($result);
mysql_close($dbhost);