Re: Mysql Rows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Well it seems you output it via PHP so count it extern in PHP.
And changing ID values is a "no-go!"
You will never have any relation possibilities if you alter the ID fields.

In short. You mess everthing up with it.

There are count functions in MySQL that gives you the counted rows or output it counted.

You can look at the manuals in mysql.com

Good luck
	Barry

Barry:

I realize that relational dB's are out if one does this -- and -- I fully understand why.

That's the reason when I started this thread I made it clear that I was NOT talking about a relational dB but rather a simple flat file.

What I find interesting in all of this exchange -- however -- is that everyone agree's renumbering the "id" of a dB is something you don't do, but no one can come up with a concrete (other than relational) reason why.

But your suggestion to look-up the MySQL count function, is a good one, thank you.

tedd

--
--------------------------------------------------------------------------------
http://sperling.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux