Comments by santa_oscuro (Top 1 by date)

here i put the code that works. I know how use Like, but im saying that code works when i tried on database query but on php, on change:

Hide   Copy Code

IN ( SELECT id_book_genre FROM Book b1, Genres_book g1 WHERE b1.id_book = g1.id_genre_book AND [b]b1.id_book LIKE ?[/b])AND NOT ([b]b.id_book Like ?[/b]) GROUP BY b.name ORDER BY duplicated DESC");$result->bind_param('ii', $book,$book);

I tried without "AND NOT (b.id_book Like ?)" and only bind 1 parameter but both returns 0 results... but if i try at database directly change "?" for the numbers, works perfectly.