[snip]
You must have a column that is sequential in some way. An
auto-incremented column, timestamp, or some other device that will
allow
you to step through regardless of gaps in sequence. If you do not have
such a column then you could add one.
You see, now that's the problem. If you have a
As such, if you don't renumber, then the only thing left is to use a
timestamp, I guess.
[/snip]
No, if you have gaps you can still step through sequentially, like 14,
15, 18, 19, 20...
It's the gaps that are the problem.
I have no problem understanding why there are gaps in a dB and
dealing
On Monday 06 March 2006 07:56, tedd wrote:
So, I'm still trying to find a simple way around this problem. Either
I renumber the id field OR provide an external counter to present
to the user. I don't see any other solutions, does anyone?
Thanks.
tedd
I haven't followed this thread very
tedd wrote:
As such, if you don't renumber, then the only thing left is to use a
timestamp, I guess.
[/snip]
No, if you have gaps you can still step through sequentially, like 14,
15, 18, 19, 20...
It's the gaps that are the problem.
I have no problem understanding why there are gaps in a
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
Miles Thompson wrote:
I hope the following will be helpful, and it is a bit of a rant ..
thank god someone ranted on this already :-)
I wasn't feeling up to it but it's also one of those cases that you can't
help but speak out. ;-)
--
PHP General Mailing List (http://www.php.net/)
To
[snip]
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
tedd wrote:
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
Another point to consider, is that Tedds method of renumbering the rows,
*may* not preserve the original sequence. I have not checked the mysql
source, but if some delete activity has occurred in the table, then
there will be holes in the data, in some circumstances, inserting
further records to
On 3/6/06, Dusty Bin [EMAIL PROTECTED] wrote:
Another point to consider, is that Tedds method of renumbering the rows,
*may* not preserve the original sequence. I have not checked the mysql
source, but if some delete activity has occurred in the table, then
there will be holes in the data, in
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.
If you don't care that a given record may have a different,
At 10:56 AM 3/6/2006, tedd wrote:
As such, if you don't renumber, then the only thing left is to use a
timestamp, I guess.
[/snip]
No, if you have gaps you can still step through sequentially, like 14,
15, 18, 19, 20...
It's the gaps that are the problem.
I have no problem understanding why
On 3/6/06, Jim Moseby [EMAIL PROTECTED] wrote:
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.
If you don't care
At 08:57 AM 3/6/2006, tedd wrote:
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.
It's simply -- concretely -- inefficient
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 --
Hi gang:
?php
echo str_repeat(Okay, I give up! , 100);
?
Miles said:
Why are we still chasing this thread?
No need to pursue this thread anymore -- I'll just address the
statements put to me.
Why does he even have to see gaps? Just present the info, unless he
wants to see the ID.
R O B said:
That Rod guy, he's such a card! I'd add something, but Jay has already
covered my list in a more recent email than this one to which I'm
responding :)
jblanchard (who I think is Rod) said:
A SQL question on a PHP mailing list usually gets more than ribbing. ;)
No harm done --
On 3/6/06, tedd [EMAIL PROTECTED] wrote:
R O B said:
That Rod guy, he's such a card! I'd add something, but Jay has already
covered my list in a more recent email than this one to which I'm
responding :)
jblanchard (who I think is Rod) said:
A SQL question on a PHP mailing list usually
[snip]
R O B said:
That Rod guy, he's such a card! I'd add something, but Jay has already
covered my list in a more recent email than this one to which I'm
responding :)
jblanchard (who I think is Rod) said:
[/snip]
I am definitely not Rod.
[snip]
For sake of argument, let's agree that
On Sun, Mar 05, 2006 at 08:01:07AM -0500, tedd wrote:
R O B said:
That Rod guy, he's such a card! I'd add something, but Jay has already
covered my list in a more recent email than this one to which I'm
responding :)
jblanchard (who I think is Rod) said:
A SQL question on a PHP mailing
- Original Message -
From: tedd [EMAIL PROTECTED]
To: php-general@lists.php.net
Cc: Gustav Wiberg [EMAIL PROTECTED]; Robert Cummings
[EMAIL PROTECTED]
Sent: Sunday, March 05, 2006 12:58 AM
Subject: Re: [PHP] Mysql Rows
Hi:
Gustav said:
No, maybe not when it's a small db, but when
I hope the following will be helpful, and it is a bit of a rant ..
rant
The row number DOES NOT MATTER and is absolutely irrelevant. MySQL is a
relational database from which information is gathered by means of
comparing fields to key values. Even if you are using an auto-incremented
primary
planetthoughtful wrote:
But, too often I've seen people new to database design not liking
'gaps' because 'user1' will have a unique id of '1', while 'user2'
will have a unique id of '6' because the records associated with
unique ids '2' through '5' were deleted during testing, and so on.
- Original Message -
From: tedd [EMAIL PROTECTED]
To: php-general@lists.php.net
Cc: benifactor [EMAIL PROTECTED]; Murray @ PlanetThoughtful
[EMAIL PROTECTED]; Anthony Ettinger [EMAIL PROTECTED]
Sent: Saturday, March 04, 2006 3:14 PM
Subject: Re: [PHP] Mysql Rows
planetthoughtful
On Sat, 2006-03-04 at 09:14, tedd wrote:
planetthoughtful wrote:
But, too often I've seen people new to database design not liking
'gaps' because 'user1' will have a unique id of '1', while 'user2'
will have a unique id of '6' because the records associated with
unique ids '2' through
: Re: [PHP] Mysql Rows
On Sat, 2006-03-04 at 09:14, tedd wrote:
planetthoughtful wrote:
But, too often I've seen people new to database design not liking
'gaps' because 'user1' will have a unique id of '1', while 'user2'
will have a unique id of '6' because the records associated
: Re: [PHP] Mysql Rows
- Original Message -
From: Robert Cummings [EMAIL PROTECTED]
To: tedd [EMAIL PROTECTED]
Cc: PHP-General php-general@lists.php.net; benifactor
[EMAIL PROTECTED]; Murray @ PlanetThoughtful [EMAIL PROTECTED];
Anthony Ettinger [EMAIL PROTECTED]
Sent: Saturday
Hi:
Gustav said:
No, maybe not when it's a small db, but when you try to delete
50.000 posts I have a strong feeling this would be very much slower
then if you don't alter table after each deletion.
First, I'm not deleting 50,000 records -- I dropping a table and
renumbering it.
In any
PROTECTED]
Sent: Saturday, March 04, 2006 2:29 PM
Subject: Re: [PHP] Mysql Rows
- Original Message -
From: Robert Cummings [EMAIL PROTECTED]
To: tedd [EMAIL PROTECTED]
Cc: PHP-General php-general@lists.php.net; benifactor
[EMAIL PROTECTED]; Murray @ PlanetThoughtful [EMAIL
[snip]
my reasoning for needing the users number in a database is this...
i am going to be doing a lottery type thing where i grab a random number
between 1 and the result of mysql_num_rows($result)... that is the
reason
the gaps matter. the while loop didn't work for me so if anyone could
help
On Sat, 2006-03-04 at 18:58, tedd wrote:
Hi:
Rod said:
*LOL* I knew those MySQL people shouldn't have made the ALTER TABLE
syntax available to just anyone. Gun -- foot -- *BLAM*. I hope to God
you never get your hands on a real database with millions of entries.
I'm glad that you were
i need to find a way to find out what number of a row is in a database...
for example:
//this is the database
Username: Chuck Password: adsasa
Username: jimmy Password: adsf
Username: stewart Password: dfds
the information i need is what row jimmy resides on..
this is what i tried:
function
define $1 = 0 outside your loop.
i'm curious why you are relying on row-order in the database?
Typically you'd have a PRIMARY KEY auto_increment for something like
this.
On 3/3/06, benifactor [EMAIL PROTECTED] wrote:
i need to find a way to find out what number of a row is in a database...
Ettinger [EMAIL PROTECTED]
To: benifactor [EMAIL PROTECTED]
Cc: php php-general@lists.php.net
Sent: Friday, March 03, 2006 3:52 PM
Subject: Re: [PHP] Mysql Rows
define $1 = 0 outside your loop.
i'm curious why you are relying on row-order in the database?
Typically you'd have a PRIMARY KEY
it.
- Original Message -
From: Anthony Ettinger [EMAIL PROTECTED]
To: benifactor [EMAIL PROTECTED]
Cc: php php-general@lists.php.net
Sent: Friday, March 03, 2006 3:52 PM
Subject: Re: [PHP] Mysql Rows
define $1 = 0 outside your loop.
i'm curious why you are relying on row-order in the database
. thank you for you help. simple fix. i
should have caught it.
- Original Message -
From: Anthony Ettinger [EMAIL PROTECTED]
To: benifactor [EMAIL PROTECTED]
Cc: php php-general@lists.php.net
Sent: Friday, March 03, 2006 3:52 PM
Subject: Re: [PHP] Mysql Rows
define $1 = 0
I have to agree with Anthony - why are you using row order to determine
something relating to users? I couldn't follow your brief explanation
above, and the fact that you're doing it sets off some soft alarm bells
about the design of your application. Why is it important that there
shouldn't be
On 3/3/06, Murray @ PlanetThoughtful [EMAIL PROTECTED] wrote:
I have to agree with Anthony - why are you using row order to determine
something relating to users? I couldn't follow your brief explanation
above, and the fact that you're doing it sets off some soft alarm bells
about the
On 4/03/2006 5:36 PM, Anthony Ettinger wrote:
Yep, that's one good reason among many for using unique ids.
Thinking a
little about the OP's question, I could understand row order being
relevant in certain situations where you wanted to display something
like, You were the
I know this is more of a mySQL question but, how do I delete and add rows
and columns?
--
- Zavaboy
[EMAIL PROTECTED]
www.zavaboy.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
] mySQL: Rows and columns
I know this is more of a mySQL question but, how do I delete and add rows
and columns?
--
- Zavaboy
[EMAIL PROTECTED]
www.zavaboy.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List
http://www.mysql.com/doc/en/ALTER_TABLE.html
I know this is more of a mySQL question but, how do I delete and add rows
and columns?
--
- Zavaboy
[EMAIL PROTECTED]
www.zavaboy.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
On Wed, 2003-06-18 at 10:03, zavaboy wrote:
I know this is more of a mySQL question but, how do I delete and add rows
and columns?
--
- Zavaboy
[EMAIL PROTECTED]
www.zavaboy.com
Using the mysql_*() function and the SQL language. The mysql_*()
functions are documented here:
you tomorrow.
-Original Message-
From: zavaboy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 7:03 PM
To: [EMAIL PROTECTED]
Subject: [PHP] mySQL: Rows and columns
I know this is more of a mySQL question but, how do I delete and add
rows and columns?
--
- Zavaboy
[EMAIL
On Wed, 18 Jun 2003, zavaboy wrote:
I know this is more of a mySQL question but, how do I delete and add rows
and columns?
Before you touch MySQL or attempt to access it through
PHP, you really should learn basic SQL:
http://www.sqlcourse.com/
http://www.w3schools.com/sql/
45 matches
Mail list logo
