Page 1 of 1

Hey I get this error....

Posted: Tue Jun 20, 2006 12:01 pm
by sc4ba
Hey I get this error:

Code: Select all

Parse error: syntax error, unexpected $end in /home/unreal/public_html/fansite/member_list.php on line 111
When using this code:

Code: 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");
Basically I want to list all the members in my database that use any character other than the alphabet.. uno?

lol can u let me know where i have gone wrong thx

Sean

Posted: Tue Jun 20, 2006 12:04 pm
by RobertGonzalez
Post line 110. It is usually a forgotten semicolon or some other simple syntax thing at the line before the reported line.

Posted: Tue Jun 20, 2006 12:04 pm
by Chris Corbyn
Sounds like you're missing a closing curly brace somewhere }

Posted: Tue Jun 20, 2006 12:13 pm
by sc4ba
thx guys worked it was a missing } lol stupid things lol jk jk

if i did this

Code: Select all

AND `username` NOT LIKE 'b%'
instead of this ...

Code: Select all

AND `username` NOT LIKE CONVERT( _utf8 'b%' USING latin1 ) COLLATE latin1_swedish_ci

does it matter?

Posted: Tue Jun 20, 2006 12:20 pm
by RobertGonzalez
This code...

Code: Select all

AND `username` NOT LIKE 'b%'
Effectively eliminates/skips all records where username starts with a 'b'.

Posted: Tue Jun 20, 2006 12:21 pm
by feyd
I think using a REGEXP would work better here.

Posted: Tue Jun 20, 2006 12:39 pm
by sc4ba
how does that work?