Loop or different way?

Hi all,
I post on MySQL forum but no one answer
http://forums.devshed.com/mysql-help-4/loop-or-different-way-590979.html
 nha khoa. com/showthread.php?t=23423
I'm quite unsore how to proceed with following task:
Lets assume I generated array with numbers (3456, 3333, 1234, 1114).

Now I would like to ask DBA by sql what names are attached for IDs mentioned in array.

The question is how gid data form DBA. Should I insert the Select statement into FOR loop? = 4x select .... where id=$number[$i]???

or

just select all records from DBA and compare the IDs by php code?

Regards and thx for help

ctytrungloi wrote: Hi all, I post on MySQL forum but no one answer http://forums.devshed.com/mysql-help-4/loop-or-different-way-590979. - http://forums.devshed.com/mysql-help-4/loop-or-different-way-590979.html nha khoa. com/showthread.php?t=23423 I'm quite unsore how to proceed with following task: Lets assume I generated array with numbers (3456, 3333, 1234, 1114). Now I would like to ask DBA by sql what names are attached for IDs mentioned in array. The question is how gid data form DBA. Should I insert the Select statement into FOR loop? = 4x select .... where id=$number[$i]??? or just select all records from DBA and compare the IDs by php code? Regards and thx for help

Well, you can go to SQL and adjust the IDs. Then it will be ok


Edited by louis2609 - 01 September 2011 at 5:00am