hi everyone am a novie in php world. i was asked to creat a database and a table which i did but now i created a form which has the following client,fullnames,commissioning date, expiry date, email, telephone, vehicle type, subsribtion. i inserted the values into mysql database. but now i want to create a search field which when the enter the client name, it will generate the expired field of the table

Recommended Answers

Why will it generate the expiry date? You have the expiry date in the form so it should be in the DB already, shouldn't it?

Jump to Post

I see that you've opened a new thread to ask the same question again.

http://www.daniweb.com/web-development/php/threads/472595/date-range

Please keep your posts organised. There's no need to open a new thread, even if you do not find …

Jump to Post

All 8 Replies

Member Avatar

Why will it generate the expiry date? You have the expiry date in the form so it should be in the DB already, shouldn't it?

exact match

$sql = "SELECT * FROM mytablename WHERE `fullnames` = '$searchname'";

or search by name parts

$sql = "SELECT * FROM mytablename WHERE `fullnames` LIKE '%$searchname%'";

tanx a lot its working

but am having another problem, i want to view all active users from the table database using date that is not more than one year

Member Avatar

Have you studied SQL syntax? To retrieve use

SELECT ...list of fields you need... FROM ...tablename... WHERE ...fieldname... = ...value...

In your case you'll want the WHERE clause to have a function instead of a simple fieldname...

DATEDIFF(NOW(), expiry_date) <= 365

Maybe something else to take into account leap years.

please can u give me the full php code to that? cuz am a beginner tank u

Member Avatar

I see that you've opened a new thread to ask the same question again.

http://www.daniweb.com/web-development/php/threads/472595/date-range

Please keep your posts organised. There's no need to open a new thread, even if you do not find a contributor's post useful - that's just rude.

In addition, although we are here to help, it is not our job to give you complete solutions or write all the code for you. We are all volunteers and post what and when we can. It's YOUR job to provide US with the code, telling us where it's going wrong.

ok thank u alot i appreciate ur kind help

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.