Tech Real quick sql querie question... - GoFuckYourself.com

Publisher Bucks · 12-23-2021, 09:51 PM

Is there a way to display SQL querie results on a php page based on the date?

For example, lets say on the 1st it shows 5 results, then on the 10th it shows 10 results, the 15th 15 results... All from the same querie without having to rewrite it and use phodate to display seperate pages?

If so, what is that function called please so I can do some research and playing about with it.

Thanks.

Merry Happy HoliChrismaKwanza to all too

sarettah · 12-23-2021, 10:17 PM

You can use the php date() function to get the day of the month and then use that as your limit.

$limit=date('j',time());
$sql="select * from tablename limit " . $limit;

.

Publisher Bucks · 12-23-2021, 10:23 PM

Quote:

Originally Posted by sarettah

You can use the php date() function to get the day of the month and then use that as your limit.

$limit=date('j',time());
$sql="select * from tablename limit " . $limit;

.

Oh, interesting, I figured it'd actually be a lot more involved than that

Much appreciated, hope you're well

12-23-2021, 09:51 PM	#1
Publisher Bucks Confirmed User Industry Role: Join Date: Oct 2018 Location: New Orleans, Louisiana. / Newcastle, England. Posts: 1,141	Real quick sql querie question... Is there a way to display SQL querie results on a php page based on the date? For example, lets say on the 1st it shows 5 results, then on the 10th it shows 10 results, the 15th 15 results... All from the same querie without having to rewrite it and use phodate to display seperate pages? If so, what is that function called please so I can do some research and playing about with it. Thanks. Merry Happy HoliChrismaKwanza to all too __________________ SOMETHING EXTREME IS COMING SOON!

12-23-2021, 10:17 PM	#2
sarettah see you later, I'm gone Industry Role: Join Date: Oct 2002 Posts: 14,091	You can use the php date() function to get the day of the month and then use that as your limit. $limit=date('j',time()); $sql="select * from tablename limit " . $limit; . __________________ All cookies cleared!