MAKE 2 select inside 1 procedure MYSQL with wordpress

Posted in Wordpress Mysql, May 24, 2017

Got 2 tables, 1 include type of cars, one list all cars.

I want to get LIMIT, COUNT and variable to put on the select select to get the good results.

In other words :

1 select returns 200 types, i want ot ge tonly the 20 first types. THEN, I want total rows of all cars including the 20 first types

example : 20 first types includes 50 cars

So it needs to return 50 rows

then next query will return all cars rows from types 21 to 40 ..

If you know the solution of this issue, please leave us a reply in Comment section, to update the question.