Re: [PHP-DB] SQL Select statement

Addressed to: "JJeffman" <[EMAIL PROTECTED]> "PHPDB" <[EMAIL PROTECTED]> "bill" <[EMAIL PROTECTED]> ** Reply to note from "JJeffman" <[EMAIL PROTECTED]> Sat, 17 Feb 2001 13:11:20 -0300 > > Try this way : > > "select t1.memberID,t1.choice,t2.memberID, t2.choice from ta

[PHP-DB] Best Way

I've searched the manual and read many examples, but I have to ask here for the best way to program for a number of possibilities. I've got my site working the hard way, but I'll bet there's a smarter way of doing the following: Visitors to my site can search my database by lastname and/or firstn

[PHP-DB] Links On The Fly

Hi All I have a search engine which generates a page full of links. Depending on the link that was clicked, I want to load info on the fly. How do I do that? Regards Sridhar Ranganathan _ Get Your Private, Free E-mail from

AW: [PHP-DB] SQL Select statement

>think you can give your problem another approach, splitting it in two >queries and joining the result sets through php script. >Sometimes you can't put SQL to do all the work. That's true, but in most cases it is more efficient to leave the joins, orders etc. in the DB, because its more optimze

Re: [PHP-DB] SQL Select statement

Try this way : "select t1.memberID,t1.choice,t2.memberID, t2.choice from table as t1, table as t2 where t1.choice = 2 and t2.choice =3" It works, but you'll going to have as many records as the bigger number of records between choice=2 and choice = 3, no matter you use the distinct keyword or n

Re: [PHP-DB] Text field types and efficiency

Thank you. But I do not mention the number of records in my question. Could be tens of thousands in the long run. jaskirat singh wrote: > I am not sure if I get 100% of what you mean .. but what ever ... do not > look for efficiency in such a small no. of records .. look for convenience in > the

AW: [PHP-DB] Security on Windows2000/Nt

>I am using windows2000 and when I run php it enables anyone on my network >to allow php coding to make directorys in my computer.. >How can I disable this feature so they can only make directorys/files in their own directory? You could try to run php in secure mode (not sure if this helps you wi

Re: [PHP-DB] Text field types and efficiency

I am not sure if I get 100% of what you mean .. but what ever ... do not look for efficiency in such a small no. of records .. look for convenience in the long run. HTH At 07:52 AM 2/17/01 +, Alan Hale wrote: >Question from a beginner: I want to associate a fairly small amount of >text (abo