How to relate custom field

[Sonu2007]

How i relate custom filed value to user server details.

 

suppose we assigned server to client ip 127.0.0.1 and we have custom field "Rack Id" (for admin only) it contain value "324"

 

how i get "rack id" from clients assigned ip using mysql?

 

Thanks

[laszlof]

Something like this should work.

 

SELECT 
 cfv.value AS rackid
FROM 
 tblhosting h, tblcustomfields cf, tblcustomfieldsvalues cfv 
WHERE 
 h.id = cfv.relid AND
 cf.id = cfv.fieldid AND
 cf.fieldname = 'Rack ID' AND
 h.assignedips = '127.0.0.1';