Select all entries from database that include a phrase


Posted on 16th Feb 2014 07:03 pm by admin

I have a database of clubs - one of the categories is meeting time and place
I would like to have a page that looks something like this:

Monday:
club1
club2
club3

Tuesday:
club1
club2
club3

etc.
and each club is linked to the "showitem.php" page I have set up

I've been able to get it to work for one day, but not so that it lists all of the days and their clubs.
The data includes the place as well as the day where the meeting is held, so I have to use something like SELECT * FROM clubs WHERE meet LIKE "%monday%"

Can anyone help out?

No comments posted yet

Your Answer:

Login to answer
168 Like 47 Dislike
Previous forums Next forums
Other forums

Select question
Hi,

First I would like to say that php is pretty new for me..
so please don't shoot me if

ereg_replace()
Basically what i need to do is

$title = "This Suck's"

$striped = ereg_repl

Place specific image in html page when specific name is typed.
Hello,

Fairly new to PHP and was curious if someone might know how to solve a fairly simple r

Problem with coding MySQL query
I'm having heaps of trouble getting one of my PHP/MySQL queries to work for some reason (and the fun

text box alphanumeric caracters only
hi all!

I have search on google on how to enter in a test box only caracters A-Z,a-z,0-9 usi

Little problem with form insertion in MySQL, Please help!!!
Hi!,

I'm a little bit new with php and I have a little issue here. I created a webform to ins

Attempt to assign property of non-object in...
I'm having issues with the following function in PHP 5...

function getTreeWithChildre

Allegro crashes when running load_bitmap. Why?
I can not get Allegro to load any BMP images. Here is a section of test code. The picture is in the

Add "width" check when upload
Hi!

Can someone add a function that is checking if picture witdh is bigger then 800px whwn up

Grabbing Values From an Array for Posting
I have a grid array that I am using with a form that when it hits the currently named test.php it lo

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash