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?

Your Answer:

Login to answer

Other forums

PHP Programming error. Please help!
Hi there,

Am making a website for a friend and have encountered a problem that i need fixing

Embedding flash object in Else statement
This is my first major project in PHP and I'm having some trouble embedding a flash object in an Els

Code Review - SQL and Insertion Attacks (Warning: Not for Newbs)
Hey guys,

Its been a while, I know. Use to love coming here to answer peoples questions, but

I need help with formatting date from mysql! with php!
Hello guys

*Note: this is a php question not MySQL question, please do not move it to mysql s

Add a sign-up feature to a flat file login script
I'm working on a flat file login script and I would like to add a sign-up feature to it with a email

php/mysql auto logout after 2 hour and reset password
Hi all,

This I hope will make sense. I've the following code which when a user logins in, cr

POST into Array problem
Hi Chaps,

I have a repeat region, displaying rows of data: jobid, fromtable, translatorcharge

why isn't this PHP code working ???
it's suppose to find a name on the database.

<?php

$s = $_POST["lname&

RSS feed - FeedList for WordPress
Hi,

I'm trying to alter the FeedList plugin for WordPress so that I can click on the title of

Retail terminologys not been altered after activing Retail System
Hi, All

After I active Retail System via TCode SWF5, the terms does not been changed, th