How to show MySQL query result instead of the whole table?

Tags: #<Tag:0x00007f8b266b9488>
#1

how can I get the MySQL query result instead of the whole table?

I want to run this query

SELECT * FROM cars where manufacture = ‘Honda’ ORDER BY id ASC LIMIT 100

I try to modify the below line and it works to some extent but not working properly?

function &loadCars($db){
$select = $db->prepare(“SELECT * FROM cars ORDER BY id ASC LIMIT 100”);

#2

Hey @yatendra3192

what’s the length of your table? If you do not get all the records they might not have been rendered yet. You can try to add renderAllRows: true and check if the list is complete?

#3

Hi @aleksandra_budnik

Thank you for replying

Rendering all row is not a problem.

The issue I’m facing is how to get only query result instead of the whole table. (i have sent the example file I’m working with on support@handsontable.com)

#4

Thank you. I will then reply on the email.

#5