Re: where to get mySQL questions answered?
From: Randell D. (reply.to.news.group.only_at_and.share.com)
Date: 01/03/04
- Next message: TG: "Values not displaying in second form after post."
- Previous message: Randell D.: "Re: Using GD Library Functions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sat, 03 Jan 2004 02:35:20 GMT
"Five Cats" <cats_spam@[127.0.0.1]> wrote in message
news:0SYB6dAR2p8$Ewzw@[127.0.0.1]...
In message <pFoIb.874722$6C4.108878@pd7tw1no>, Randell D.
<reply.to.news.group.only@and.share.com> writes
>
>"Zaphod Beeblebrox" <foo@spamsnothere.org> wrote in message
>news:C41Ib.860092$6C4.759329@pd7tw1no...
<snip>
>
>Secondly... Remember Google keeps a good index of the newsgroups and I
>believe either with them, or with deja or dejavu or something that they
give
>online access too - But in most cases, as long as its not porn, you should
>be able to ask your ISP to add mailing.database.mysql to their news feed -
>The additional traffic will not cost them but a fraction of a fraction of
>their overhead... I frequent the newgroup and find it useful with little if
>any junk email.
>
Thanks, have added that to my list of newsgroups.
>Lastly... If the problem you are facing is not the query length, then it
>might be worth while posting some of your code (if its not too long) in to
>this newsgroup as I am having second thoughts, thinking that since your
>query works with one word, but not two - and it seems that your code might
>be passing the syntax of the query wrongly (perhaps leaving your database
>hanging waiting for more info - dunno - its been a long time since I've had
>mysql on a win98 box)... Try echo'ing the full query to your web client
>browser and then copy/paste that to your mysql client and see what the
>result would be... and check error log files too!
I agree that the syntax is probably the problem, or possibly that a
query which will take a humongous time to execute is being created
(possibly a Cartesian product is being generated). However we don't
have the schema, or the nrows for each table, or what the final SQL
being run is so this is all a shot in the dark.
>
>Hope something above helps... best of luck... and happy new year,
>randell d.
>
>
-- Five Cats Email to: cats_spam at uk2 dot net ==================================== You say you don't have the schema - Do you mean you don't have the table's definition? I'm a newbie (six months or so at MySQL) and I might be short on the correct naming convention for it... but if you do not know the table's definition, then using PHP to query the database and perform a 'DESCRIBE database.tablename' and examine the output... Hope that helps you some... Replies please... via the newsgroup, so everyone can learn... Thanks, Randell D.
- Next message: TG: "Values not displaying in second form after post."
- Previous message: Randell D.: "Re: Using GD Library Functions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
