Member Avatar for oteheddy

Hello,

Pls i developed a php application and i would like to limit the number of row entries into a table in my database and the number of rows displayed from that table. i am a beginner:$

  • 2 Contributors
  • 1 Reply
  • 116 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for smantscheff

What for would you like to limit the number of rows in the database?
If you really want, you can check the number of rows in PHP with a construct like

$count = mysql_num_rows( mysql( 'select * from mytable', $connection ));

and disable the insertion of new entries if count exceeds your limit.
If you want to have the limit for display purposes, use the LIMIT clause in mysql instead. Example:

select * from mytable LIMIT 10, 10;
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.