kyder -

i used MySQL Query Browser to run this against my DB:

Code:
SELECT cid FROM computers

and then...
Code:
SELECT TOP 1 cid FROM computers


and got results on the first 1 but a SQL error on the second one. Do you know that "TOP 1" is a valid SQL syntax?

Also, the reason when I query, I'm querying for the MAC and the name is because computers can have different MACs (users move their network cards), OR users simply rename their computer and rejoin them to the domain. When I query for the information, I'm just making sure I get the right computer... that's all.