Jump to content

query help please


TEENFRONT

Recommended Posts

Hey thanks for reading!

 

Im after a little help building a query to pull info on players.

 

$query = "SELECT games_won, games_played, userrating, profiledata, profileID, usernick FROM gamezer_users_1 WHERE banned !='1' and userstatus ='1' and profiledata !='' ORDER BY userrating DESC LIMIT 50";

 

is my current query but where i have this

 

AND profiledata !=''

 

i want to change it to soemthing like

 

AND profiledate !='XX::XX:YY'

 

to explain, i have a profiledata field that sets the avatar number, there sex and there country flag.

 

so the profile data field wuld output this "01:ML:UK"  or "05:FM:US" but sometimes if they dont fill out there country flag it will return this for example "02:ML:"

 

i want to select the users that have this fully filled out so the select query would have to make sure that profiledata contained the 3 sets of info...

 

is this possible?

 

Many thanks for any help thrown my way :)

Link to comment
https://forums.phpfreaks.com/topic/152432-query-help-please/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.