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

Form validation with functions
Hi there

I am trying to make a very simple form validation function. I currently have the fol

Blank record injected into database
I always found several blank records inside my database, although $SESSION is required to insert the

phpMailer will not connect using SMTP
I am trying to use phpMailer with smtp:

Code: [Select]$mailer = new PHPMailer();
$mailer-&

$_POST
Hi, I have 2 seperate php files, and i want my $_POSt["fname"] To go into both of them, Fo

Referential Integrity problem when inserting into 2 tables at same time
Hello Everyone,

Im relativity new to PHP and MySQL and i have come up against a problem. i h

ORA-01017: invalid username/password; logon denied
Dear All,

I am facing problem in taken backup from db13 it comes up with the following l

captcha error
I have been trying to implement a captcha in php...

here is the code..
Code: (php) [Select

Echo-ing MySQL content and Keep Formatting?
I have data in my MySQL such as:

QuoteBlah blah

Blah blah

etc
but when i ech

Get relative path from absolute path
How would one go about getting the relative path to a file from its absolute path?

Post, not working, please help
The error is:
Method Not Allowed
The requested method POST is not allowed for the URL /student