Select information from a column

[multipianista]

Hi, I would like to know how can I separate each "String" form a column. For example, in my column "Colors" I have write: "Blue,Red,Green"
So, if I make a consult from the column "Colors", it will return me the whole information "Blue,Red,Gree,". How can I consult just for the blue, the red or the green for separate?

Thank you.

[JJ_Tagy]

If they are definitely separated by commas, you can do a split function or a substr function.

[Altrea]

Hi,

explode() is the answer.

best wishes,
Altrea

[multipianista]

But it doesn't work for this code:

$query = $db->query("SELECT * FROM datos WHERE informacion LIKE '$queryString%' LIMIT 5");
if($query) {
while ($result = $query ->fetch_row()) {
echo '<li onClick="fill(\''.$result->informacion.'\');">'.$result->informacion.'</li>';}


Here it prints the column "informacion" but I just want it to select a part of that column. I mean, I want to search in each string (separate by ",") of the all "informacion" columns.

[Nobbie]

Here it prints the column "informacion" but I just want it to select a part of that column. I mean, I want to search in each string (separate by ",") of the all "informacion" columns.

Therefore you cannot simply output $result->informacion directly, you have to split it into several chunks by using explode() or any suited function.

Anyway: we cannot teach you programming PHP, this forum is meant for technical problems. You should go for a good PHP programming book (there are really many out there) and learn programming step by step. As we all did. This forum cannot replace a good book and (of course) it will take a certain amount of time (months at least) to become a skilled PHP programmer.

[itnasasta]

Here it prints the column "informacion" but I just want it to select a part of that column. I mean, I want to search in each string (separate by ",") of the all "informacion" columns.???

[Nobbie]

Here it prints the column "informacion" but I just want it to select a part of that column. I mean, I want to search in each string (separate by ",") of the all "informacion" columns.???

This is a pain and it definately means, that you have choosen the WRONG data model for your application. It is simply wrong, having comma separated values in your columns, instead of having a 1:n (or even n:n) relationship between some entities. I know that you dont like this answer and it does not make you happy, but its better to have a sudden death instead of a pain without end. I am sorry for the bad explanation, in german the idiom says "besser ein Ende mit Schrecken, als ein Schrecken ohne Ende". Maybe a translator can translate this into an appriopriate engllish idiom.

Anyway, you have to change your data design and your application, otherwise you will not ever have a good performing application.