Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Not a newbie yet question. Limitations on drop down pick lists?

Status
Not open for further replies.

GarryC

IS-IT--Management
Aug 14, 2000
36
NZ
Hi,
I am currently progranming in Foxprowith an additional framework and am sick of constant increase in $cost to stay current. I am also looking for something that can work cross platform. I have not done any WEB programming or HTML so please excuse if my questions seem a bit ignorant.

I have an application which I wish to duplicate in PHP/MySql. Basically it is SQL builder interface, to a reporting system. I have a number of drop down pick lists which display (with incremental search) customer and product lists consisting of roughly 8000 products, 3000 customers.

Is this funtionality possible, feasible using PHP? The user selects 1 or more items which are then build into the SQL query, by taking the literal value inside the variable used to hold the selection.

I have looked at a number of books with syntax, functions etc but is there any books/documents on clever little tricks and advanced techniques?

Regards Garry.
 
That's not a hard thing to do in PHP/MySQL, and for my knowing there are not any limits to the number of elements in the selects.

But (there's always a but), with too much information to send to the user, the application can be slow running cause there's the cost of the transfer between the server and the client. If they are in the same network, the problem is a minor one.

If you want to show the info in the internet, i can tell you that standard modems only transfer 7-8 KBps. Anikin
Hugo Alexandre Dias
Web-Programmer
anikin_jedi@hotmail.com
 
More than feasible, our company intranet does something very similar and the boss will love you foor the $cost saving ;-) ***************************************
Party on, dudes!
[cannon]
 
Thanks. Much appreciated. I will start playing.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top