[SOLVED] Multiple ID

[crashmaster]

Hi there,

 

how to make sql query, where I can choos several IDs (primary keys) ??

 

For example:

I have tabel where I have 1000 rows with unique ID each,, Hot can I choose rows with ID (for ex.) 10, 13,22,45,50 by ONE query ??

 

 

    $q = mysql_query("
        SELECT
            id,img_src,copyright
        FROM
            videa
        WHERE
            id = '138'
            AND
            id = '137'

    ");

 

It doesnt work... (((

[Maq]

SELECT id, img_src, copyright FROM videa WHERE id IN (10, 13, 22, 45, 50)

[crashmaster]

SELECT id, img_src, copyright FROM videa WHERE id IN (10, 13, 22, 45, 50)

 

Thank you

[Maq]

Think about this, if you try to get the results where id = 138 and id = 137 there will never be a result because the id is unique...

 

        WHERE id = '138' AND id = '137'

 

Welcome