id|name|ip|guid
And I have a search page, that basically does this:
Code: Select all
$sql = "SELECT id, name, INET_NTOA(ip) AS ip, guid FROM 1up_people WHERE (name LIKE \"%$query%\" OR INET_NTOA(ip) LIKE \"%$query%\" OR guid LIKE \"%$query%\")";Moderator: General Moderators
Code: Select all
$sql = "SELECT id, name, INET_NTOA(ip) AS ip, guid FROM 1up_people WHERE (name LIKE \"%$query%\" OR INET_NTOA(ip) LIKE \"%$query%\" OR guid LIKE \"%$query%\")";