Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
CREATE TABLE zwierzaki1 (
imie VARCHAR(64),
gatunek VARCHAR(64)
);
INSERT INTO zwierzaki1 VALUES
('Kicia', 'kot'),
('Misia', 'pies'),
('Funio', 'kot'),
('Bercik', 'mysz'),
('Bodek', 'kot');
<?php
$query = 'SELECT imie FROM zwierzaki1 WHERE gatunek=? ORDER BY imie ';
$result = $mysqli->execute_query($query, ['kot']);
foreach ($result as $row) {
printf("%s \n", $row["imie"]);
}