Jump to content


Photo

Dynamic LIMIT for recordsets


  • Please log in to reply
4 replies to this topic

#1 parkster2001

parkster2001
  • New Members
  • Pip
  • Newbie
  • 3 posts
  • LocationBirmingham, England

Posted 23 September 2004 - 11:58 AM

Hi all,

I'm still very novice when it comes to PHP/mySQL.
Here's what i'm trying to do.....I think the way that DW inserts the code is making it hard for me to figure out myself

I need to somehow limit the output of a recordset using dynamic values - I don't know if it's easier to do this when defining the recordset (using LIMIT) or when ECHOing the results on the page in a different way

Any pointers would be VERY much appreciated

Cheers



#2 jerry187

jerry187
  • Members
  • Pip
  • Newbie
  • 4 posts
  • LocationAustralia

Posted 23 September 2004 - 01:30 PM

Myself I always use a mysql statement as much as I can to filter the data. It's a lot more efficient than selecting a whole table and filtering it yourself with php.

just incorporate the values as variables into your query

$query = "SELECT * FROM my_table WHERE this=that LIMIT $row_offset, $rows";
OR you can only select certain fields as well
$query = "SELECT column1, column2, column4 FROM my_table WHERE this=that LIMIT $row_offset, $rows";
AND you may also skip the offset if you just want the first x rows

moving on...

then store the result
$result = mysql_query($query);

then do whatever with the result set

Hopefully thats what you were talking about :P
Just Call Me Jerry

#3 parkster2001

parkster2001
  • New Members
  • Pip
  • Newbie
  • 3 posts
  • LocationBirmingham, England

Posted 23 September 2004 - 07:54 PM

Thanks for the help :)

Ill give that a try and let you know how I get on

#4 parkster2001

parkster2001
  • New Members
  • Pip
  • Newbie
  • 3 posts
  • LocationBirmingham, England

Posted 24 September 2004 - 11:40 AM

I finally got it :D

I think the problem had something to do with dreamweaver's variable passed from the URL and my manual variables not working together.

Anyway - all is fixed now. Thanks again

#5 morpheus.100

morpheus.100
  • Members
  • PipPipPip
  • Advanced Member
  • 145 posts

Posted 27 September 2004 - 08:38 AM

LIMIT works, but if you require pagination you will need a more suitable arrangement. Check phpfreaks pagination tutorial to find out more.

As you posted in the Dreamweaver forum I assume you are using dreaweaver. Use the behaviours in the application panel. You can dynamically limit the recors returned from there. F1 launches the manual.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users