Random Number, if duplicate?

[Red Blaze]

I wouldn't want to run into a problem if two albums have the same key.

[Paul M]

What problem exactly ?

[Red Blaze]

What I want is to filter the albums by a key. I just want one album per key. If two albums is to have the same key, both albums would be displayed. I do not want that. I want them to be displayed individually.

[Paul M]

Prefix it with the userid then.

[Marco van Herwaarden]

Use an autoincrement albumid as identification, the random key as password.

[Red Blaze]

Is it really THAT difficult to do? I'm not trying to find short cuts. I'm trying to learn more PHP.

[Marco van Herwaarden]

Well it is not difficult to do, just generate a number, check in the database if it is already used, and generate another number if it was in use.

We only trying to help you find the best solution to your problem.

[Red Blaze]

Well, Im trying to find out how to create that loop. Which I'd like to learn how it's done. Thanks for trying to help. -_-'

[Marco van Herwaarden]

Something like (not tested):

PHP Code:

while (!$newid)
{
    $newid = rand();
    $existingid = $vbulletin->db->query_read("SELECT albumid FROM " . TABLE_PREFIX . "myalbumtable
            WHERE albumid = $newid");
    
    // Those the generated key already exist?
    if ($existingid['albumid'] == $newid)
    {
        unset $newid;
    }
} 


[Paul M]

Originally Posted by Sonikku

Is it really THAT difficult to do? I'm not trying to find short cuts. I'm trying to learn more PHP.

It's not difficult, just pointless. If you want to learn then learn that you don't need to do some things.