how to display only 4 records from a table based on a
condition
for ex
i have a table called products
in that nid,prodname are fields
i want to display only any 4 records of perticular product
plz tell me
Answer Posted / vigneshram
select nid, prodname from products limit 0,4
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
Can we rename database in mysql?
How to get data from mysql in php?
How to insert dynamic values in mysql using php?
What are views in mysql?
Tell us something about heap tables?
What is bdb (berkeleydb)?
How many types of indexes are there in mysql?
Why we use mysql workbench?
What does innodb stand for?
What is the full meaning of mysql?
What is a string in mysql?
What is the usage of "i-am-a-dummy" flag in mysql?
Is mysql same as sql?
How many columns is too many mysql?
How can you take the backup and restore a mysql database using php?