Re: [PHP-DB] Values for Popdownmenu (Categorie and Subcategorie) from MySQL

2001-04-19 Thread Ron Brogden
At 01:51 AM 4/20/2001 +0200, Denis Mettler wrote: I know how i can fill the values in the first popdownmenu, but i don't know how to handle the second one withe the chosen value from the first. If you mean that you want a selection in the first drop down list to automagically trigger a change

Re: [PHP-DB] PHPNuke 4 error. Got any clues?

2001-04-18 Thread Ron Brogden
At 03:55 PM 4/18/2001 -0400, Brian Tegtmeier wrote: If you have any suggestions, It would be greatly appreciated. thanks! :) First, do not use PHPNuke. It has a shaky codebase which would require a complete rewrite to fix up. I have used it personally and regret it as it is a total pain to

Re: [PHP-DB] How to redirect a user to main page once I capture his info in a form?

2001-04-18 Thread Ron Brogden
At 02:03 PM 4/18/2001 -0700, Hector M Banda wrote: Warning: Cannot add header information - headers already sent by (output started at page.php:42) in page.php on line 45 What's at line 42 of page.php? Cheers -

Re: [PHP-DB] I know this has been asked before, but....

2001-04-11 Thread Ron Brogden
At 03:38 PM 4/11/2001 -0700, SHAWN wrote: What's the SELECT statment I want to use to find duplicate entries in a specific field? SELECT column_name, count(*) AS doubles FROM some_table HAVING doubles 1 GROUP BY colname This should grab all instances where there are multiple instances of

Re: [PHP-DB] images

2001-04-10 Thread Ron Brogden
At 11:48 AM 4/10/2001 -0800, bryan wrote: Maybe there is a way to use .htaccess more appropriately, but, this site allows guest / non-members, to buy something. Once they buy something, they are given a username of email, and password (they choose). If they log back in, they should have access

Re: [PHP-DB] Building a Shopping Cart

2001-04-10 Thread Ron Brogden
At 03:17 PM 4/10/2001 -0400, Matt Braynard wrote: I'm trying to build a shopping cart and am unsure of how to track what each visitor has purchased as they shop. How do I track what items they add as they move through the online catalog adding things and then checkout. Make a table that

Re: [PHP-DB] Protecting files

2001-04-05 Thread Ron Brogden
At 03:09 AM 4/5/2001 +0100, Mick Lloyd wrote: But how do I then protect the directories/scripts from anyone wanting to have a look (not that they're worth much!). Create a .htaccess file that contains the following: deny from all Place it in the directories you wish to protect. Next, create

RE: [PHP-DB] Login System with access levels

2001-03-16 Thread Ron Brogden
At 02:00 PM 3/16/2001 -0600, you wrote: First, I would NOT store passwords in a database. Rather, I'd store a hash based upon the password and username. Storing a password is dangerous as regards security. Just to be a little picky and *not* to start an argument (discussion yes), this really

Re: [PHP-DB] Text Searches on MySQL

2001-03-14 Thread Ron Brogden
At 05:05 PM 3/14/2001 +, you wrote: I'm putting together a db with articles in it. Would it be better to have two tables with the main text of the articles in it linked to a main article table or just chuck it all in together in one table. I want to be able to do a full text search on the

Re: [PHP-DB] csv file with mysql

2001-03-12 Thread Ron Brogden
At 04:05 PM 3/12/2001 -0600, you wrote: I'm loading a csv text file into a table in a mysql database, however it seems to just stop after a while if the file is to big. I'm new with php so any help would be appreciated. PHP scripts will normally have a limited life span set in the server's

Re: [PHP-DB] Using text files instead of a DB

2001-03-12 Thread Ron Brogden
At 09:29 PM 3/12/2001 -0400, you wrote: THE ROTTERS!! They don't have to do ANYTHING to support MySQL except: 1. Set up an empty database 2. Assign it a username/password and, just possibly 3. Provide the most elemental of scripts so you can do a bulk load,

Re: [PHP-DB] ftp upload

2001-03-08 Thread Ron Brogden
At 03:03 AM 3/9/2001 +0200, you wrote: is it possible to make a "upload file" php script ? any example is high acceptable :) Read the supplied PHP documentation at: http://www.php.net/manual/en/features.file-upload.php The above link was from the table of contents of the manual which suggests

Re: [PHP-DB] Drop down box

2001-03-01 Thread Ron Brogden
At 06:32 PM 3/1/2001 -0300, you wrote: The action you want is only available using JavaScript. True but the action *you* want is most definitely not what many of your *users* are going to want. If you use Javascript this way your site will be un-navigable if Javascript is turned off or the

Re: [PHP-DB] Tricky database query involving two tables

2001-02-28 Thread Ron Brogden
At 09:50 PM 2/28/2001 -0500, you wrote: Is there a way to do this in MySQL? Or do I have to just query everything, and then have the skipping logic be in PHP? I'd love to encapsulate this in a query. Would it involve subqueries (something I know that MySQL doesn't directly support)? The

Re: [PHP-DB] onMouseOver onMouseOut

2001-02-23 Thread Ron Brogden
At 06:27 PM 2/23/2001 -0300, you wrote: Remember, php is server side while JavaScript is client side. You can't use php client side. You can use some client side events to call php scripts which will run on the server and send data to the browser. Events are client side, so try JavaScript you'll

Re: [PHP-DB] PHP security

2001-02-20 Thread Ron Brogden
At 01:50 PM 2/20/2001 -0600, you wrote: As far as I know, you can not download PHP programs without access to download them. Meaning you need an account on the webserver, so they would need your account user and pass before they could steal your mysql user and pass. The main issue is that

[PHP-DB] close posting to non-subscribers please

2001-02-20 Thread Ron Brogden
At 12:29 PM 2/21/2001 +1100, you wrote: This will take one minute and is worth it! Arrgh. I just sent a test message as a non subscriber to see if this list was misconfigured, which it is. Whoever is the list admin, please please please close posting to non-subscribers. SPAM on mailing

Re: [PHP-DB] Hide Files

2001-02-19 Thread Ron Brogden
At 04:22 PM 2/19/2001 -0600, you wrote: while ($file_name = readdir($dir)) { if (($file_name != ".") ($file_name != "..") ($file_name !="*.php") ($file_name !="main.gif") ) how come that still displays all the *.php files? You cannot use wildcards in this comparison: $file_name