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

Session login issue
I'm wondering how to fix a problem I'm having with a session-based login system

Say I go to h

Login Issue's
Code: <?php
$file = fopen('user.txt', 'r');

/* Set login to false initially */

PHP Cannot redeclare class
I have 6 files, and two of them do not seem to want to play well. I keep getting a "Cannot rede

need help with mail()
hi i want to send an email with attaching pdf file using php. i have the following script but the pr

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...

How to return to a previous page after running a PHP script
I'm having a bit of a melt down here because I think this should be really easy but can't work it ou

List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab

Revoking alter any table from a schema
Hi All,

i am working in Oracle 10g.
my requirement is to revoke all kind of DDL oper

xml element exists
Code: [Select]<?xml version="1.0"?>
<Addresses>
<

Open browser page depending on XML results
Hello,

I have some PHP code that sends webbased from data to an external url ( in the form of