Hey I get this error....

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
sc4ba
Forum Newbie
Posts: 3
Joined: Tue Jun 20, 2006 11:54 am

Hey I get this error....

Post 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
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Post line 110. It is usually a forgotten semicolon or some other simple syntax thing at the line before the reported line.
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

Sounds like you're missing a closing curly brace somewhere }
sc4ba
Forum Newbie
Posts: 3
Joined: Tue Jun 20, 2006 11:54 am

Post 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?
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

This code...

Code: Select all

AND `username` NOT LIKE 'b%'
Effectively eliminates/skips all records where username starts with a 'b'.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I think using a REGEXP would work better here.
sc4ba
Forum Newbie
Posts: 3
Joined: Tue Jun 20, 2006 11:54 am

Post by sc4ba »

how does that work?
Post Reply