$sql = "SELECT
books.id,
books.name,
books.pages,
books.`date`,
books.url,
books.tetx_book,
autor.name AS `autor.name`,
autor.patronymic,
autor.surname,
publish.name
FROM
autor
INNER JOIN book_aut ON (autor.id = book_aut.autor_id)
INNER JOIN books ON (book_aut.book_id = books.id)
INNER JOIN publish ON (books.pub_id = publish.id)";
if(!empty($_GET['sort']))
{
$sort = $_GET['sort'];
}
echo "1. sort=$sort<br>";
switch($sort){
case "name":
$sql+= "ORDER BY
books.name";
break;
case "autor":
$sql+= "ORDER BY
books.autor";
break;
case "publish":
$sql+= "ORDER BY
books.books_id";
break;
case "date":
$sql+= "ORDER BY
books.date";
break;
case page:
$sql+= "ORDER BY
books.pages";
break;
default:
echo "щось не те!<br>";
}
Но вызов
while($row = mysql_fetch_array($rez))Выдает предупреждение:
{
( ! ) Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\OpenServer\domains\sunduk\index.php on line 71
В чем моя ошибка?