How to extract more than one row from MySQL database?

Question

MySQL

I send a query: "SELECT * FROM tbl WHERE something='12'", I get an object, I convert it to an array, but in this array there is only one row of data, although several rows match the query.

Answer 1

where is the code?

Answer 2

Write SELECT * FROM `TABLE`WHERE `Something` LIKE 12;
The query should return all rows where something is equal to 12. And read at the W3C how the Like construct is used in different DBMS.

Answer 3

A guide to overcoming "nothing works" problems:
1) Break the task into steps (large first, then smaller if necessary)
in your case there is 1) a query that "should" (shouldn't) select multiple rows. We go to the console or phpmyadmin and write the request there directly. If the query returns 1 record, let's go learn SQL syntax.
2) If the problem is not in the request - there is a wardump for the result of the output from the function that works with the database, maybe you are using the wrong thing - let's go read about your database adapter and functions from it.
3) We get the object - how and what happens here - a mystery, check what you feed at the input, see where data is lost during the algorithm, what you get at the output.
Hint: var_dump(), print_r();

Answer 4

It looks like you are overwriting the elements of an array. Give the code in which you convert the object to an array, most likely there is an error in it

Answer 5

pissed off =(

Answer 6

pr0l - I meant that you can already determine the problem by the squeak - en.wikipedia.org/wiki/%D0%97%D0%B2%D1%83%D0%BA%D0%...

Answer 7

>> other wires
Disconnect everything, connect one at a time, checking after each step.

Answer 8

As @Rsa97 said, turn off pretty much everything. Pull out video cards, all sorts of modems, peripherals, hard ones - in short, almost everything. Even pull out the entire RAM, without it, first start it. And then connect one by one what he complains about.

Answer 9

If it does not even turn on, then most likely it is in the PSU. Try installing another PSU. If there is no other power supply at hand and there is no one to take it from, then drag your old one to any service and ask it to check for performance.