Linux, Apache, MySQL, PHP

Re: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages

2-Feb-09 6:09

Here is the PERFECT place to talk. You will get input from an array of people using different practices, with stronger knowledges is certain areas. You can get the best of all worlds by posting here instead of just getting input from one person.

So no, if you have something to ask, ask it here. It is the best place to ask.

Don't forget, you got your answer to your question by posting here, why stop doing that Poke tongue | ;-P

LazyDragonfist2-Feb-09 6:20

Re: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages

2-Feb-09 6:20

May be you are right.This is the best place i accept but getting
response took 1 day that is why i said that.
Any way thanks for the help.
I have another doubt with php.
that is can we run php for life time?
i want to run a php that checks the site www.example.blog.com(say) and copy
newly add file to the site to my site.

I tried to call php from another php using curl and made it run 3 hours but
did helped to complete my task.

Have any idea.

EliottA2-Feb-09 6:23

Re: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages

2-Feb-09 6:23

LazyDragonfist wrote:
but getting
response took 1 day that is why i said that.

As if I would be on call to help you at your leisure is feasible... yeah right.

LazyDragonfist wrote:
I have another doubt with php.
that is can we run php for life time?
i want to run a php that checks the site www.example.blog.com(say) and copy
newly add file to the site to my site.

Start a new thread, and rephrase your question with proper English so I can understand it.

Before you post, consult with Mr. google[^] and RTFM[^] so you can give it a try before you post. No one here will do your coding for you, only point you in the right direction.

LazyDragonfist2-Feb-09 6:37

Re: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages

2-Feb-09 6:37

I don't want other do my coding.
i was just asking where i am going wrong that it.
I will start a new thread for that.
This time i will see my English.
i understood one thing from your code that query for
the filter was not good.i am able to download 10000 records.
But fails when i apply filter to that.
Can you see the Query and tell me what is wrong please.
i have 4 table champs(Champion Ships),teams(team),matchs(matchs played),rag(scores)

I hope the below Query will be understandable.
SELECT date,(select champname from champs where champid=matchs.champid) AS ChampionShip, matchs.round AS Round, (select teamname from teams where teamid=matchs.home) AS home, (select teamname from teams where teamid=matchs.away) AS away, HomeOdds,AwayOdds,DrawOdds, rag.goalno AS NoOfGoals, (select sum(rag.home) from rag where matchid=matchs.matchid) AS HomeGoals, (select sum(rag.away) from rag where matchid=matchs.matchid) AS AwayGoals FROM matchs, rag WHERE rag.matchid=matchs.matchid And rag.goalno=(select max(goalno) from rag where matchid=matchs.matchid);

EliottA2-Feb-09 6:39

Re: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages

2-Feb-09 6:39

That might be better off in the database section as it's a SQL related question, not a PHP related question, again start new threads, this one is going off topic and out of control.

LazyDragonfist2-Feb-09 6:45

Re: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages

2-Feb-09 6:45

Ok,
Thanks you for every thing.

Perspx2-Feb-09 6:55

Perspx

2-Feb-09 6:55

EliottA wrote:
Before you post, consult with Mr. google[^] and RTFM[^] so you can give it a try before you post.

Well put

Do you think we could get Chris to put something like that at the top of every forum?

Regards,
--Perspx

"A refund for defective software might be nice, except it would bankrupt the entire software industry in the first year."
-Andrew Tanenbaum

"Einstein argued that there must be simplified explanations of nature, because God is not capricious or arbitrary. No such faith comforts the software engineer."
-Fred Brooks

Re: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages

EliottA2-Feb-09 6:57

Re: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages

2-Feb-09 6:57

Something like that exists in the C# and VB.Net sections, I don't see why it's not in the PHP board too. Put it in the suggestions board, I'm sure it will go under consideration, assuming it's not in the to-do already.

LazyDragonfist2-Feb-09 7:22

Re: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages

2-Feb-09 7:22

Well put Poke tongue Do you think we could get Chris to put something like that at the top of every forum?

Regards,
--Perspx

What you guys are thinking are not right.No one here come and
posts with out trying it in google and other tutorials.Of course for
you smart guy its very silly and easy.Here people come when there are
no other ways to find solutions to their problem.

Regards,
Pavan.

Perspx2-Feb-09 21:38

Perspx

2-Feb-09 21:38

LazyDragonfist wrote:
No one here come and posts with out trying it in google and other tutorials

Really..? No-one? WTF | :WTF:

Jeez, a hell of a lot of answers to questions I've seen here are simple, bog-standard, type it into Google sort of things..

Regards,
--Perspx

Re: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages

LazyDragonfist2-Feb-09 7:22

Re: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages

2-Feb-09 7:22

Well put Poke tongue Do you think we could get Chris to put something like that at the top of every forum?

Regards,
--Perspx

What you guys are thinking is not right.No one here come and
posts with out trying it in google and other tutorials.Of course for
you smart guy its very silly and easy.Here people come when there are
no other ways to find solutions to their problem.

Regards,
Pavan.

EliottA9-Feb-09 6:26

Need A php script for .doc to html conversion.

9-Feb-09 6:26

I disagree, a lot of people come here without searching google or the documentation.

Check out the CodeProject forum Guidelines[^]

Jude Dcoutho31-Jan-09 7:50

Jude Dcoutho

31-Jan-09 7:50

I am running a website where i require uploaded word document to be shown on the fly on the particular poages. , but i dont have a php script that converts .doc file contents to html .
Please help me out.

Regards
Jude Dcoutho
judedcoutho@gmail.com Smile | :)

good news [modified]

PavanPareta28-Jan-09 1:06

PavanPareta

28-Jan-09 1:06

It's good news for python developers.. !!!

It is good, To started python message board.. on codeproject ..

I m too happy Thumbs Up | :thumbsup:

Thanks

Pavan Pareta

modified on Thursday, March 12, 2009 9:41 AM

Cool - we have a Python board

MikeBeard27-Jan-09 5:33

27-Jan-09 5:33

I didn't realize that we had a Python formum. Big Grin | :-D

I'll have to start watching it, as Python is my second favorite language after C++.

Later,
Mike

MikeBeard27-Jan-09 5:39

27-Jan-09 5:39

Seems things are odd right now. I came in here, didn't see any posts, made the one above and then after posting, saw that there were two other posts ahead of mine.

I replied to one of them (which seems to now be linked to this subject rather than the one I replied to) and now I only see this subject.

Weird.

MikeBeard27-Jan-09 5:40

27-Jan-09 5:40

And now, after posting the above, things seem to be back to normal.

Confused | :confused:

Oh well. Still cool that we have a Python forum here.

-Mike

Uros Calakovic28-Jan-09 5:15

Uros Calakovic

28-Jan-09 5:15

MikeBeard wrote:
Python is my second favorite language

You mean something like my brain is my second favorite organ ...

In January you said "Money in April" -
That was two years ago!

B. Python

MikeBeard29-Jan-09 4:47

29-Jan-09 4:47

You got me. I should read over what I write before I post.

Help

sk8te32027-Jan-09 3:10

sk8te320

27-Jan-09 3:10

I'm new to both Perl and SQL and have been given a project to attempt writing a Perl script that will execute an SQL query. Then extract the information generated by the query and import it to a Microsoft Office Excel spreadsheet. Can someone point me in the right direction? Dazed and Confused. All help will be greatly appreciated.

sk8te320 Confused | :confused:

divyamistry27-Jan-09 21:41

divyamistry

27-Jan-09 21:41

You should start in Perl doc and Perl reference online. This is a common task and usually achieved through DBI module. Here's a guide from CodeProject KnowledgeBase[^] That takes care of accessing data from database using an SQL query. Once you have data in a perl variable, you can do all sorts of manipulation (I'm thinking along the lines of regexp and what not).

Now onto your Excel problem. Perl has a couple of modules (OLE, Spreadheet::Excel, etc.) to deal with MS products. I have never used them, but I have heard good things about Spreadsheet::Excel. I just did a quick search and found a nice tutorial/article on IBM developerWorks series. Here's a link[^].

I hope this points you to the right direction. And in case you are not familiar with installation of Perl modules, I'd suggest searching for Perl CPAN. Its homepage will point you to installation instructions and whatever else you might need to get the modules up and running.

sk8te3205-Feb-09 1:57

sk8te320

5-Feb-09 1:57

Dear divyamistry,
I appreciate the help. It's not to often you receive advise that so in depth. Sorry
I didn't get back to you earlier, but we've been having some system problems at work and things have been kind of crazy. I look into your suggestions, they seem like what I've been looking for, who knows, maybe one day I'll be able to return the favor.

Thx again, sk8te320!

divyamistry29-Jan-09 21:06

divyamistry

29-Jan-09 21:06

Continued from PHP forum Smile | :)

Ok, so you said

sk8te320 wrote:
Can someone point me in the right direction? Dazed and Confused. All help will be greatly appreciated.

So, I thought I'd suggest which modules etc. to look up. If you have already done that, and have all the modules installed, would you please let me know where you are stuck? Are you able to verify that you have all the modules installed? Let me know if I could be of any help. I'm no Perl pro, but I've done similar stuff earlier, so I may be able to help you out on this one.

sk8te3205-Feb-09 2:00

sk8te320

5-Feb-09 2:00

Hey divyamistry,
Haven't sunk my teeth into it yet, hope to get to it in the next couple of days but will keep you in the looop.

sk8te320!