Code: Select all
Parse error: syntax error, unexpected $end in /home/unreal/public_html/fansite/member_list.php on line 111Code: Select all
$mail2 = mysql_query("SELECT * FROM `members`
WHERE `username` NOT LIKE CONVERT( _utf8 'a%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'b%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'c%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'd%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'e%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'f%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'g%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'h%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'i%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'j%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'k%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'l%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'm%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'n%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'o%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'p%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'q%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'r%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 's%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 't%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'u%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'v%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'w%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'x%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'y%' USING latin1 ) COLLATE latin1_swedish_ci
AND `username` NOT LIKE CONVERT( _utf8 'z%' USING latin1 ) COLLATE latin1_swedish_ci");lol can u let me know where i have gone wrong thx
Sean