PHP: explode array

Question

i have two table for article and setting. in article table i put id,title,date ..etc and in settings table, i have row with name featuredarticle and put id of article with separate comma for featured articles. now i need to list/print my featured article only. how to ?

TABLE articles:

ID | TITLE | DATE | PUBLISH
1
2
3
4
5

TABLE settings / row featuredarticle:

1,2,5

enter image description here

You will need to add some additional detail here. How far do you get? Do you have a working MySQL query? Are you getting any error messages? etc. — Ren
– Ren, Commented Jan 15, 2013 at 9:53

John Woo · Accepted Answer · 2013-01-15 09:52:44Z

1

SELECT  a.*
FROM    articles a
        INNER JOIN settings b
            ON FIND_IN_SET(a.ID, b.featuredarticle) <> 0

FIND_IN_SET

If you have time to change the table schema, change it. It is a bad design to have columns vith value separated by a comma.

answered Jan 15, 2013 at 9:52

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

BaTmaN Over a year ago

i see this error : Error 1054: Unknown column 'b.featuredarticle' in 'on clause'. i now this bad design, but i custom the any modules of cms And I have no choice.

John Woo Over a year ago

@BaTmaN how come you have an unknown column? can you post the result of this query please, DESC articles and DESC settings

BaTmaN Over a year ago

sorry but, i dont care how to work DESC articles and DESC settings query! can u tell me how to work this?

Dawid Sajdak · Accepted Answer · 2013-01-15 09:52:52Z

0

Get data from DB to array and use:

$newArray = explode(".", $dataDbArray);

answered Jan 15, 2013 at 9:52

Dawid Sajdak

3,0842 gold badges25 silver badges37 bronze badges

Comments

Suresh Kamrushi · Accepted Answer · 2013-01-15 10:00:55Z

0

You can try this-

SELECT * FROM article
     JOIN settings ON FIND_IN_SET( id, featuredarticle)

Please have a look at demo: demo

edited Jan 15, 2013 at 10:00

answered Jan 15, 2013 at 9:55

Suresh Kamrushi

16.2k13 gold badges79 silver badges93 bronze badges

2 Comments

John Woo Over a year ago

LEFT JOIN is not needed here, the OP states i need to list/print my featured article only

BaTmaN Over a year ago

@SureshKamrushi : i see this error: Error 1054: Unknown column 'featuredarticle' in 'on clause'. i add screen of options table. please see this.

Collectives™ on Stack Overflow

PHP: explode array

3 Answers 3

3 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related