PHP MYSQL Help

[Monkuar]

Hi everyone! I am stuck!

 

SELECT config FROM inettuts WHERE user_id='5'

 

This config pulls out this data:

 

PostInfo,color-grey,User Info,not-collapsed|Twitter,color-grey,Twitter,not-collapsed;AboutMe,color-grey,AboutMe,not-collapsed|Signature,color-grey,Signature,not-collapsed

 

From a Text field in the mysql db, it then it is translated from jquery to show a portable iGoogle like page.

 

But the problem is, I need to make the query select everything but the "Twitter,color-grey,Twitter,not-collapsed" (TWITTER PART) how is this possible?

[cmb]

if "|" represents a new record  then try this

SELECT config FROM inettuts WHERE user_id = '5' AND config != 'Twitter,color-grey,Twitter,not-collapsed'

[Monkuar]

if "|" represents a new record  then try this

SELECT config FROM inettuts WHERE user_id = '5' AND config != 'Twitter,color-grey,Twitter,not-collapsed'

 

I tried everything, the | before and after, I don't think the "AND" etc is working when I already selected my initial user_id = 5??

 

could I use another "AND" replacement that might get it to work?

[scootstah]

Try something like this:

 

SELECT config FROM inettuts WHERE user_id = '5' AND config NOT LIKE '%Twitter%' AND config NOT LIKE '%color-grey%' AND config NOT LIKE '%not-collapsed%'

[Monkuar]

Try something like this:

 

SELECT config FROM inettuts WHERE user_id = '5' AND config NOT LIKE '%Twitter%' AND config NOT LIKE '%color-grey%' AND config NOT LIKE '%not-collapsed%'

 

Thanks for your response, now it just shows nothing?

 

I think this will be easier If I took screenshot's instead.

This is the value stored in my "text" field.

 

 

When I use your query it just show no data, but no error also? hmmm

[scootstah]

Isn't that what you wanted? To not show rows that meet those conditions?

[Monkuar]

Isn't that what you wanted? To not show rows that meet those conditions?

 

They're not rows, there data inside 1 Field?

Sorry for the misunderstanding

 

[Monkuar]

Bump ty