Why does sql query with Like output an empty string?

Question

PHP

Guys tell me please, such a problem
I make a request to the database of the form:
SELECT * FROM `streets` WHERE name like '%Катук%'
Everything works I write php

$q = "SELECT * FROM `streets` WHERE name like '%$b%'";
$result =mysql_fetch_array(mysql_query($q));
echo $result['name']";

It prints an empty string, what am I doing wrong?

Answer 1

MySQL does not have a FIRST() function. Instead, you can use
And move away from using mysql_ in php. use mysqli or PDO.

Answer 2

interesting: one request works. another request does not work. What is the question is not clear.
requests are different, there is no first() function.

Answer 3

en2.php.net/mysql_fetch_array

Answer 4

What if so

echo $b;
$q = "SELECT * FROM `streets` WHERE name like '%$b%'";
$result =mysql_fetch_array(mysql_query($q));
var_dump($result);

Answer 5

Try to copy the query without pasting the variable and execute it i.e.

$q = "SELECT * FROM `streets` WHERE name like '%Катук%'"

Answer 6

What does var_dump($result) output?
Use mysql_fetch_assoc if you are only using associative arrays. Or switch to pdo.
Remove the extra quotes at the end of the example.
Execute the query without substituting the value of the variable.
Make sure $b is not empty.