Есть вот такой вот запрос.
$db_name = "db_oilrus1";
$table_name = "company";
$connection = @mysql_connect("localhost", "oilrus1", "rg0UAL") or die(\'Не могу подключиться к серверу баз данных\');
@mysql_select_db($db_name, $connection)
or die(\'Не могу открыть базу данных\');
$sql ="select id, title, man, tel, city, type from $table_name ";
if ($types == 0 && $city == "Все" ) {$sql .= "order by title";};
if ($types == 0 && $city != "Все" ) {$sql .= " where city = \'$city\' order by title";};
if ($types != 0 && $city == "Все" ) {$sql .= " where type = \'$types\' order by title";};
if ($types != 0 && $city != "Все" ) {$sql .= " where type = \'$types\' and city = \'$city\' order by title";};
//else {$sql = "select id, title, man, tel, city, type from $table_name where type = \'$types\' and city = \'$city\' order by title";};
$result = mysql_query($sql,$connection)
or die("Couldn\'t execute query.");
//
$a_row = mysql_fetch_array ($result);
@$num_rows = mysql_num_rows($result);
while ($a_row = mysql_fetch_array ($result))
{
print "
\\n";
print "\\t$a_row[title] | \\n";
print "\\t$a_row[man] | \\n";
print "\\t$a_row[tel] | \\n";
print "\\t$a_row[city] | \\n";
print "\\t$stat | \\n";
print "\\t
\\n";
}
?>
Он не выводит первую запись таблицы. Может быть дело в (неправильном) использовании mysql_fetch_array?
