[SOLVED] flight board php question

[Paul471]

Hi, i know there is a few topics about departure boards and such. But well there mostly about where to find one to use or to get one they have paid for working.

This does not relate directly to phpvms so if the moderator wants to decline or remove that's cool.

Anyway here is problem. I have made a little dep and arr board it works great but the problem is i can only make it read flights that have only 1 day set.

So the script look at todays date witch would be 6 then compares that to the database and then shows any flight that has the same day. Then sorts ect.

The problem is i have no idea how to make it so it reads the row and looks for a 6. By this i mean.

If you have the flight set to just Sat then in the database you get 6 however if you set it to Monday and Wed and Sat you get 136. So when the script looks at the database for any flights that have day 6 it see the 136 and ignores it.

I need to make it so it looks at the 136 and says arrr that contains a 6.

Hope that makes sense.

Thanks in advance.

[Paul471]

Solved it. For anyone else who need it. use the "like"

WHERE rowname like '%$value%'