[PHP-DB] List menus

2006-12-05 Thread David Skyers
Hello,

How do you create a database driven list menu, and record the options
that a user has chosen. And then display the list menu with those chosen
option selected.

 Please select from list  PHP 3  ---  PHP 4  PHP
5
 

Regards,

 
David






RE: [PHP-DB] List menus

2006-12-05 Thread Miguel Guirao


The solution has been posted before, check the archives!

-Original Message-
From: David Skyers [mailto:[EMAIL PROTECTED]
Sent: Martes, 05 de Diciembre de 2006 07:20 a.m.
To: php-db@lists.php.net
Subject: [PHP-DB] List menus


Hello,

How do you create a database driven list menu, and record the options
that a user has chosen. And then display the list menu with those chosen
option selected.

 Please select from list  PHP 3  ---  PHP 4  PHP
5
 

Regards,

 
David







Este mensaje es exclusivamente para el uso de la persona o entidad a quien esta 
dirigido; contiene informacion estrictamente confidencial y legalmente 
protegida, cuya divulgacion es sancionada por la ley. Si el lector de este 
mensaje no es a quien esta dirigido, ni se trata del empleado o agente 
responsable de esta informacion, se le notifica por medio del presente, que su 
reproduccion y distribucion, esta estrictamente prohibida. Si Usted recibio 
este comunicado por error, favor de notificarlo inmediatamente al remitente y 
destruir el mensaje. Todas las opiniones contenidas en este mail son propias 
del autor del mensaje y no necesariamente coinciden con las de Radiomovil 
Dipsa, S.A. de C.V. o alguna de sus empresas controladas, controladoras, 
afiliadas y subsidiarias. Este mensaje intencionalmente no contiene acentos.

This message is for the sole use of the person or entity to whom it is being 
sent.  Therefore, it contains strictly confidential and legally protected 
material whose disclosure is subject to penalty by law.  If the person reading 
this message is not the one to whom it is being sent and/or is not an employee 
or the responsible agent for this information, this person is herein notified 
that any unauthorized dissemination, distribution or copying of the materials 
included in this facsimile is strictly prohibited.  If you received this 
document by mistake please notify  immediately to the subscriber and destroy 
the message. Any opinions contained in this e-mail are those of the author of 
the message and do not necessarily coincide with those of Radiomovil Dipsa, 
S.A. de C.V. or any of its control, controlled, affiliates and subsidiaries 
companies. No part of this message or attachments may be used or reproduced in 
any manner whatsoever.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] List menus

2006-12-05 Thread Vincent DUPONT
Hello,

there is a very good menu to do this : see PEAR html_menu
(see http://pear.php.net, search for package HTML_Menu)

this has various menu types. One is the 'tree' (vertical list), the other is 
the 'urhere', which will display the 'You are in:...' menu.

I guess this is mhat you need.
This works very well as long as you have a distinct URL for every menu item, 
which is usually the case.
I guess there is a PEAR::DB wrapper that will let you connect and fetch the 
data from a database. I did my own menu class to fetch my own menu data and 
display of using the HTML_Menu.

A good point is also the 'renderers' wich let you create new layouts for the 
very same menu data. this will help you create special menus for your 
customers...

Vincent


-Original Message- 
From: David Skyers [mailto:[EMAIL PROTECTED]
Sent: Tue 5/12/2006 14:19
To: php-db@lists.php.net
Subject: [PHP-DB] List menus
 
Hello,

How do you create a database driven list menu, and record the options
that a user has chosen. And then display the list menu with those chosen
option selected.

 Please select from list  PHP 3  ---  PHP 4  PHP
5
 

Regards,

 
David

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] List menus

2006-12-05 Thread Bastien Koert

here is a link to one such example

http://www.weberdev.com/get_example-3852.html

Bastien



From: Miguel Guirao [EMAIL PROTECTED]
To: David Skyers [EMAIL PROTECTED], php-db@lists.php.net
Subject: RE: [PHP-DB] List menus
Date: Tue, 05 Dec 2006 08:59:44 -0600



The solution has been posted before, check the archives!

-Original Message-
From: David Skyers [mailto:[EMAIL PROTECTED]
Sent: Martes, 05 de Diciembre de 2006 07:20 a.m.
To: php-db@lists.php.net
Subject: [PHP-DB] List menus


Hello,

How do you create a database driven list menu, and record the options
that a user has chosen. And then display the list menu with those chosen
option selected.

 Please select from list  PHP 3  ---  PHP 4  PHP
5


Regards,


David







Este mensaje es exclusivamente para el uso de la persona o entidad a quien 
esta dirigido; contiene informacion estrictamente confidencial y legalmente 
protegida, cuya divulgacion es sancionada por la ley. Si el lector de este 
mensaje no es a quien esta dirigido, ni se trata del empleado o agente 
responsable de esta informacion, se le notifica por medio del presente, que 
su reproduccion y distribucion, esta estrictamente prohibida. Si Usted 
recibio este comunicado por error, favor de notificarlo inmediatamente al 
remitente y destruir el mensaje. Todas las opiniones contenidas en este 
mail son propias del autor del mensaje y no necesariamente coinciden con 
las de Radiomovil Dipsa, S.A. de C.V. o alguna de sus empresas controladas, 
controladoras, afiliadas y subsidiarias. Este mensaje intencionalmente no 
contiene acentos.


This message is for the sole use of the person or entity to whom it is 
being sent.  Therefore, it contains strictly confidential and legally 
protected material whose disclosure is subject to penalty by law.  If the 
person reading this message is not the one to whom it is being sent and/or 
is not an employee or the responsible agent for this information, this 
person is herein notified that any unauthorized dissemination, distribution 
or copying of the materials included in this facsimile is strictly 
prohibited.  If you received this document by mistake please notify  
immediately to the subscriber and destroy the message. Any opinions 
contained in this e-mail are those of the author of the message and do not 
necessarily coincide with those of Radiomovil Dipsa, S.A. de C.V. or any of 
its control, controlled, affiliates and subsidiaries companies. No part of 
this message or attachments may be used or reproduced in any manner 
whatsoever.


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



_
Not only does WindowsOff to school, going on a trip, or moving? Windows Live 
(MSN) Messenger lets you stay in touch with friends and family wherever you 
go. Click here to find out how to sign up!  Live™ OneCare™ provide 
all-in-one PC care to keep your computer protected and well-maintained, but 
it also makes creating backup files a breeze. Try it today! 
http://www.telusmobility.com/msnxbox/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] CSV import to mySql

2006-12-05 Thread Chris Carter

Hi,

I have this data given below as sample. Trying to import to mySQL is failing
everytime. There are more than 100 rows of data but when I follow the
procedure of phpMyadmin  databasename  tablename  click import tab from
top choose the file (csv file)  Click on the CSV radio button on Format
of imported file area  put Fields terminated by ,, Fields enclosed by ,
fields escaped by \ and Lines terminated by by auto (do not mention
anything in Column text box.

Doing the above first of all gives me errors Invalid field count in CSV
input on line 7.. The number of rows is exactly the same in the table and
in csv. It does import but only 4-5 rows of data than all 100. Please
advice.

Also, what does it mean about Overhead in mySQL. Its size is increasing
and its showing in red.

Sample:

Unistar Estates,Commercial,Property Dealers,Mall,NULL,Ground
Floor,NULL
Space and Finance,Commercial,Property Dealers,Mall, Level 1,NULL

Thanks in advace.
Chris
-- 
View this message in context: 
http://www.nabble.com/CSV-import-to-mySql-tf2766023.html#a7713284
Sent from the Php - Database mailing list archive at Nabble.com.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] CSV import to mySql

2006-12-05 Thread Chris

Chris Carter wrote:

Hi,

I have this data given below as sample. Trying to import to mySQL is failing
everytime. There are more than 100 rows of data but when I follow the
procedure of phpMyadmin  databasename  tablename  click import tab from
top choose the file (csv file)  Click on the CSV radio button on Format
of imported file area  put Fields terminated by ,, Fields enclosed by ,
fields escaped by \ and Lines terminated by by auto (do not mention
anything in Column text box.


Sounds like something for the phpmyadmin guys to me.

http://sourceforge.net/mail/?group_id=23067

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] CSV import to mySql

2006-12-05 Thread Niel Archer
Hi

Your example data does have an invalid field count  The first row has has
7 fields, the other 6. 

So if you took them from your actual data that's your problem

Niel

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php