PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
-- Hint: use Ctrl+Enter for SQL autocomplete create table country ( id int, name varchar(64), city varchar(64) ); insert into country values (1, 'Россия', 'Москва');
Copy Clear
Copy Format Clear
<?php $conn = &$mysqli; $result = mysqli_query($conn, "SELECT * FROM `country` WHERE `city`='Москва'"); $row = mysqli_fetch_assoc($result); printf('Country ID is: %s', $row['id']);
Show:  
Copy Clear