Dynamically create table for evry 10 records

[Rajeshswain]

Hi friends,

I am creating a php blog. I want to generate a table for every 10 records. Please someone provide me a code sample. It will be same as shown in forums.

[laserlight]

You are probably going about it the wrong way. Why do you need to limit tables to 10 records?

[djjjozsi]

give us an example what you want to do... You might did not need to create new tables.

table contains fields in the database. You could easily create a field into that table, to define new categories.

Or you can create a select which was edited in the last 30 minutes, or edited today...

ect.

bye.
jjozsi

Rajeshswain;10890193 wrote:

Hi friends,

I am creating a php blog. I want to generate a table for every 10 records. Please someone provide me a code sample. It will be same as shown in forums.

[bpat1434]

Sounds to me like you want to create an HTML table showing the last 10 records (or latest 10 records) from the database.

Depending upon your SQL server (Postgres, MySQL, MS SQL, Firebird, ODBC, sqlite, etc.) you should just be able to add a LIMIT clause to your query so it looks something like:

SELECT * FROM `tablename` LIMIT 10

That will limit the number of results you receive to be just ten records.