<?php
include '../../db/db.php';
$query = " SELECT ('login','password') from 'users' WHERE ('login','password') = ('$login','$password') ";
$result = $connection->query($query);
if (!$result) die($connection->error);
if ($result->num_rows == 0) exit('Ошибка');
//Одна строка
$myrow = $result->fetch_array(MYSQLI_ASSOC);
$test=$myrow['login'];
//Перебор значений
while ($myrow = $result->fetch_array(MYSQLI_ASSOC)) {
$test=$myrow['login']; }
//Вторая строка
$myrow = $result->fetch_array(MYSQLI_ASSOC);
$test=$myrow['password'];
//Перебор значений
while ($myrow = $result->fetch_array(MYSQLI_ASSOC)) {
$test=$myrow['password']; }
?>
Выдает ошибку:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''users' WHERE ('login','password') = ('','')' at line 1.
Продвижение своими сайтами как стратегия роста и независимости