TalkPHP - View Single Post

Tanax · 10-02-2007, 07:20 PM

PHP Code:


			
$pSql = sprintf("SELECT * FROM ".$system->db->table['players']." WHERE name LIKE %1$s OR level LIKE %1$s OR vocation LIKE %1$s",
        %$search%);    
        $pResult = $system->db->query($pSql);

If I search for Ser, I will get Server, and Service and other words with "ser" in it, IF they exists in the database ofcourse.

10-02-2007, 07:20 PM	#4 (permalink)
Tanax The Prestige Join Date: Sep 2007 Location: Sweden, Stockholm Posts: 1,080 Thanks: 115	PHP Code: `$pSql = sprintf("SELECT * FROM ".$system->db->table['players']." WHERE name LIKE %1$s OR level LIKE %1$s OR vocation LIKE %1$s", %$search%); $pResult = $system->db->query($pSql);` If I search for Ser, I will get Server, and Service and other words with "ser" in it, IF they exists in the database ofcourse.