Re: [PHP-DB] Associated popup menu (php/mysql)

2004-02-06 Thread Ignatius Reilly
By pop-up do you really mean pop-up or rather drop-down boxes? Have a look at the PEAR Quickform class and its hierselect form element (hierarchical dropdown boxes) http://pear.php.net/manual/en/package.html.html-quickform.tutorial.php HTH Ignatius _ - Original

[PHP-DB] page hit tracking

2004-02-06 Thread js
i am using php MySQL and i want to know how i can make a hidden value for certain entries in a table and how many times they are called. for instance, say i have a table of vegetables people can look at. the page displays all of the vegetables, and then it generates links to each one and if the

RE: [PHP-DB] Acessing a excel worksheet from a php site

2004-02-06 Thread Griffiths, Daniel
I dont know any way to actually open and read the file with php, havent come across any classes or methods that will do this. My solution when I had this problem was to do it in 2 parts, run a macro on the excel file that will extract the data to a text file and then use php to read that into

Re: [PHP-DB] Acessing a excel worksheet from a php site

2004-02-06 Thread Ricardo Lopes
In my modest opinion it woul be much easier and faster to export the worksheet as a CSV file and parse the file in PHP than creating a macro in VBA to extract the data to a text file. - Original Message - From: Griffiths, Daniel [EMAIL PROTECTED] To: Bruno Pereira [EMAIL PROTECTED];

Re: [PHP-DB] page hit tracking

2004-02-06 Thread Ricardo Lopes
you could create a counter table and store there the vegetable id and the hits. After that each time you search for a vegetable, make an update to the table. - Original Message - From: js [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 06, 2004 8:18 AM Subject: [PHP-DB]

RE: [PHP-DB] Acessing a excel worksheet from a php site

2004-02-06 Thread Griffiths, Daniel
thats asuming the data is in a nice table that will go into the db easily, and if it is then there must of been some process to getting it like that as its simply not the easiest way for people to work due to the massive amount of duplication, if its a typical spreadsheet cross tab then that

Re: [PHP-DB] Acessing a excel worksheet from a php site

2004-02-06 Thread Ignatius Reilly
Check this class: http://sourceforge.net/projects/phpexcelreader/ HTH Ignatius _ - Original Message - From: Griffiths, Daniel [EMAIL PROTECTED] To: Bruno Pereira [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, February 06, 2004 10:10 Subject: RE: [PHP-DB]

[PHP-DB] Rules in a database

2004-02-06 Thread John
I work in tax and thus have to read legislation - some complex - and I wanted to store some of the logic in a database so that if I know certain conditions were true I could look up what results this might have. Thus I am thinking of having two tables - one of phrases and the other of how these

Re: [PHP-DB] Rules in a database

2004-02-06 Thread Ignatius Reilly
A bit of algebra first: any expression formed of atomic expressions, AND, OR and parentheses can be reduced to a canonical form, by using the De Morgan laws: a AND ( b OR c ) is equiv. to a AND b OR a AND c So a rule can eventually be reduced to AND groups, joined by OR: a(1) AND... AND a(n) OR

RE: [PHP-DB] Acessing a excel worksheet from a php site

2004-02-06 Thread Robert Twitty
You can use ODBTP (http://odbtp.sourceforge.net) to connect to it using MS's ODBC driver for Excel. -- bob On Fri, 6 Feb 2004, Griffiths, Daniel wrote: I dont know any way to actually open and read the file with php, havent come across any classes or methods that will do this. My solution

Re: [PHP-DB] Associated popup menu (php/mysql)

2004-02-06 Thread dpgirago
Let's see if I'm understanding you correctly. You want to have a form with 2 or more popup menus, where a choice of `country` in the first menu then populates a second popup menu with the `states` located in that country? If this is what you're asking, I do this all the time using select (or

RE: [PHP-DB] Rules in a database

2004-02-06 Thread Paul Miller
I guess I did not pay attention that day in class, but that is cool. - Paul -Original Message- From: Ignatius Reilly [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 9:14 AM To: DB list PHP; John Subject: Re: [PHP-DB] Rules in a database A bit of algebra first: any

Re: [PHP-DB] Associated popup menu (php/mysql)

2004-02-06 Thread alb_shop
Hi all, This is exactly what I meant. I thought that this operation could be done without any JS. But this not seems to be the correct way. Definitively a mix of languages must be used. Thank you all for your responses. David -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] php/.htacces authentication

2004-02-06 Thread john
Hi, I have a need to protect directories using .htaccess but want to initially authenticate via the tables used by phpBB. How do I tell avoid the browser popping up a login window for the directory when I know that the user should be allowed in? thanks, John Wunderly -- PHP Database Mailing

[PHP-DB] substr() problems

2004-02-06 Thread James Meers
Hi all, I am trying to use substr() negative start, but I get nothing returned - if i do a positive start then i do get something back, below is my code and a line of what i get returned: $DB_ref = 210020007; $DB_temp_ref = $DB_ref; $DB_sub_ref = substr($DB_temp_ref , 0, 1); $DB_sub_ref .=

RE: [PHP-DB] substr() problems

2004-02-06 Thread James Meers
Apologies, the script was right - but the data was wrong - I had lots of white space at the end of each string, i have used rtrim to solve this: $DB_ref = rtrim($DB_ref, ); $DB_temp_ref = $DB_ref; J. -Original Message- From: James Meers Sent: Fri 06/02/2004