$query = "SELECT COUNT(*) FROM (SELECT COUNT(id_los) FROM liczby WHERE liczba IN (" . implode(',', $lop) . ") GROUP BY id_los HAVING COUNT(id_los) = {$wielkosc_tablicy})"; $ount = current($conn->query($query)->fetch());
// wyświetlenie treści zapytania
// wyświetlenie błędu SQL
i to samo nie wiem co tu jest grane
Error: Call to a member function fetch() on boolean in C:\xampp\htdocs\suzo\los.php on line 33
A teraz robię coś takiego-cały kod i pokazuje
$wielkosc_tablicy = sizeof($lop);
$db = "SELECT COUNT(*) FROM (SELECT COUNT(id_los) FROM ado.liczby WHERE liczba IN (" . implode(',', $lop) . ") GROUP BY id_los HAVING COUNT(id_los) = {$wielkosc_tablicy}) t"; $query = current($conn->query($db)) ; try {
} catch (Exception $e) {
}
// wyświetlenie treści zapytania
( ! ) Warning: current() expects parameter 1 to be array, boolean given in C:\xampp\htdocs\suzo\los.php on line 36
Call Stack
# Time Memory Function Location
1 0.0007 357208 {main}( ) ...\los.php:0
2 0.0090 371456 current ( ) ...\los.php:36
SELECT COUNT(*) FROM (SELECT COUNT(id_los) FROM ado.liczby WHERE liczba IN (21,67) GROUP BY id_los HAVING COUNT(id_los) = 2) t
C:\xampp\htdocs\suzo\los.php:43:
array (size=3)
0 => string '42S02' (length=5)
1 => int 1146
2 => string 'Table 'ado.liczby' doesn't exist' (length=32)