mysql question

adam_uk · 06-27-2003, 05:00 AM

yo people

im building a web based register and im stuck basically

ive got my sql code

PHP Code:

  SELECT * FROM `$group` ORDER BY `id` DESC

and that will display all the entrys in that table the lnk would be entrys.php?group=2017

but i want to keep the same file but to display the entrys from that day (there are 2 entrys per day)

so i would add a limit onto the end of the code but instead of a value i would give it a variable

then the link would be entrys.php?group=2017&limit=2

now i know all this but when it comes to display all the entrys i dont want to define a limit

so basucally my question is how would i get it so that i can define a limit on todays entrys but not on all the entrys?

im think abotu an IF statement but im not sure wether it would be logical or not

deadserious · 06-27-2003, 06:44 PM

Hmm maybe you could just put it into separate variables? I'm sure there's other ways, but I don't know any of them.

PHP Code:

  $all_entries = "SELECT * FROM `$group` ORDER BY `id` DESC";

$todays_entries = "SELECT * FROM `$group` ORDER BY `id` DESC LIMIT 2";

Maybe ?

adam_uk · 06-28-2003, 07:00 AM

yeh i was thinking somthing like that cheers

06-27-2003, 05:00 AM	#1 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,211 6,170.25 NP$ (Donate)	mysql question yo people im building a web based register and im stuck basically ive got my sql code PHP Code: SELECT * FROM `$group` ORDER BY `id` DESC and that will display all the entrys in that table the lnk would be entrys.php?group=2017 but i want to keep the same file but to display the entrys from that day (there are 2 entrys per day) so i would add a limit onto the end of the code but instead of a value i would give it a variable then the link would be entrys.php?group=2017&limit=2 now i know all this but when it comes to display all the entrys i dont want to define a limit so basucally my question is how would i get it so that i can define a limit on todays entrys but not on all the entrys? im think abotu an IF statement but im not sure wether it would be logical or not

06-27-2003, 06:44 PM	#2 (permalink)
deadserious Senior Member Join Date: Aug 2002 Posts: 1,300 2.85 NP$ (Donate)	Hmm maybe you could just put it into separate variables? I'm sure there's other ways, but I don't know any of them. PHP Code: $all_entries = "SELECT * FROM `$group` ORDER BY `id` DESC"; $todays_entries = "SELECT * FROM `$group` ORDER BY `id` DESC LIMIT 2"; Maybe ?

06-28-2003, 07:00 AM	#3 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,211 6,170.25 NP$ (Donate)	yeh i was thinking somthing like that cheers

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)