[RESOLVED] Difficult nested SELECT within an INSERT statement

[eyeRmonkey]

From everything I've read, I don't think this is possible, but here is the statement I am trying to achieve:

My columns: primary_key, name, name_based_id

INSERT IGNORE INTO artists (primary_key, name, name_based_id) VALUES 
('10:w9ftxqe5ldhe', 'Joe', (SELECT COUNT(*) FROM artists WHERE name='Joe')), 
('11:jifuxqr5ldh', 'Bob', (SELECT COUNT(*) FROM artists WHERE name='Bob')),
('22:a9ftx34gldae', 'Joe', (SELECT COUNT(*) FROM artists WHERE name='Joe')), 
...

Basically, every time I add an artist, I want the name_based_id to be equal to the number of artists already present in the database with that name.

It would result in something like so:
'10:w9ftxqe5ldhe', 'Joe', 0
'11:jifuxqr5ldh', 'Bob', 0
'22:a9ftx34gldae', 'Joe', 1

The third row is "Joe 1" because he was the second joe added to the database.

From what I've read, you can't do a nested SELECT from the same table you're inserting into.

Is there anyone to accomplish this in one query?

I'd even settle for multiple queries, as long as it got the job done.

If I didn't clarify it enough, please let me know. I really need some assistance on this.

Thanks.

Note: I'm using MySQL 5.0. I'm working with an InnoDB engine. I'm writing this all in PHP, but I don't think that matters for this question.