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

Form a inline view based on the results of the previous query?
Hi Experts,
Can we form a inline view on the results of a previous query (another inline view)?

Edit MySQL Row Using PHP and HTML Form
Hello,

Here's what I'm trying to do. Build a page where a user enters a MySQL row number in.

Help pulling in 'id' with "read more" link
I'm trying to create snippets of my articles in the cms I'm creating, and then have them redirect to

How to update this array?
I am saving a string that looks this: username1, username2, username3...
into a single cell in a

contact form - output to page and email
I have the following in my controller:

$message['name'] = htmlentities(strip_tags(trim($_POST

Can't find a decent web analytics!!!
I've downloaded and installed Piwik. It's location detection based on IP addresses is fairly inaccur

regex for quoted text within a string
I am still getting the hang of regex expressions, but I cant seem to figure out how I would escape q

puting for loop in 1 value
hi ,

how do i put this code in 1 value:
Code: <?php
for ($i=1; $i<=5; $i

Could Someone Please Debug This?
I was wondering if someone could debug this script for me. I realize it's not the tidest script (and

Merger of 6 sister companies under one flagship company after go live
Dear Experts,
I need one help regarding Merger of sister companies of same group. currently we

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