Programming Help

Web Development



What's Here?

  • Members: 132,467
  • Replies: 471,308
  • Topics: 73,071
  • Snippets: 2,540
  • Tutorials: 665
  • Total Online: 1,417
  • Members: 98
  • Guests: 1,319

Who's Online?

Welcome to Dream.In.Code
Getting PHP Help is Easy!

Join 132,467 PHP Programmers for FREE! Get instant access to thousands of PHP experts, tutorials, code snippets, and more! There are 1,417 people online right now. Registration is fast and FREE... Join Now!




Pear Db

 
 Reply to this topicStart new topic

Pear Db, tuts?
SpaceMan
post 18 Mar, 2005 - 10:21 PM
Post #1


D.I.C Regular

Group Icon
Joined: 20 Feb, 2003
Posts: 270
i looking for easy tutorials on pear db.

reason being, i project i am working has a dedicated mysql server with a databse that is hundreds of megs. with the limits in php script run time and phpmyadmin.
wondering about pear db in general.
the post on que mail, made me wonder if it has time out things like that, not shure how to say it.
running the admin to get on days results takes a long time,
wondering if can
run query, post resuslts every 50 resuslts, run again till all done.

but the totals would need to be added together for final output.
hmm, might have to work on the idea on how i would like to do it.
User is offlineProfile CardPM

Go to the top of the page

cyberscribe
post 19 Mar, 2005 - 12:22 AM
Post #2


humble.genius

Group Icon
Joined: 5 May, 2002
Posts: 1,062



Thanked 2 times

Dream Kudos: 154
My Contributions
Sounds like a case for the SQL LIMIT clause.
User is offlineProfile CardPM

Go to the top of the page

SpaceMan
post 19 Mar, 2005 - 12:32 AM
Post #3


D.I.C Regular

Group Icon
Joined: 20 Feb, 2003
Posts: 270
QUOTE(cyberscribe @ Mar 19 2005, 01:22 AM)
Sounds like a case for the SQL LIMIT clause.

ehhh?
User is offlineProfile CardPM

Go to the top of the page

cyberscribe
post 19 Mar, 2005 - 12:35 AM
Post #4


humble.genius

Group Icon
Joined: 5 May, 2002
Posts: 1,062



Thanked 2 times

Dream Kudos: 154
My Contributions
If you want to return the results of an sql query in chunks, just add 'LIMIT 0,x" to the first query, then "LIMIT x,y" to the second, then "LIMIT x+y,z" for the third and so on (x, y, and z being numbers). Check the MySQL manual select syntax and play around with it. You'll get the idea.
User is offlineProfile CardPM

Go to the top of the page

SpaceMan
post 19 Mar, 2005 - 12:57 AM
Post #5


D.I.C Regular

Group Icon
Joined: 20 Feb, 2003
Posts: 270
ok, thx
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 11/22/08 01:44PM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live PHP Help!

PHP Tutorials

Reference Sheets

PHP Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month