DEV Community

Discussion on: React first row missing on mysql search

 
Sloan, the sloth mascot
Comment deleted
 
jamesrweb profile image
James Robb

This looks like you're executing 2 different queries. The first is retrieving a list of something and the other is returning the same user multiple times for some reason.

Can you share your queries? I bet you anything there is either middleware causing the issue or the query is just wrong.

Thread Thread
 
Sloan, the sloth mascot
Comment deleted
 
jamesrweb profile image
James Robb

Honesty not sure what’s happening here, have you got your project in a GitHub repo perhaps with a link to the files you run this in?

Thread Thread
 
admindatafinder profile image
admindatafinder

James, I found out.
It was on a LIMIT at the final:
Working: LIMIT ${pagina}, 50;,callback);
not working: LIMIT ${pagina} ,50;
;

I did removed the LIMIT from not working portion and now is doing what's it supposed to do..
Thanks for your help!