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_

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 (es

[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 list

Re: [PHP-DB] RedHat 7 vs. Windows 98

2001-02-22 Thread Ron Brogden
At 05:23 PM 2/22/2001 -0700, you wrote: >I've resolved a similar error by using isset() for if ($id) but when I do >the same for if (!$id) I get a parse error. Sounds like you placed the ! in the wrong spot maybe? "if(!isset($foobar)) {}" is fine syntactically as far as I am aware. >Second err

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'

Re: [PHP-DB] onMouseOver & onMouseOut

2001-02-26 Thread Ron Brogden
At 12:43 PM 2/24/2001 -0300, you wrote: >Are you trying to tell Rudi Ahlers is possible to call php scripts from a >browse event ? The statement "form.submit()" belongs to JavaScript not to >php. Of course not. What I am saying is that client side validation is pretty much useless since you hav

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] Tricky database query involving two tables, much more detail

2001-03-01 Thread Ron Brogden
>I can't query where B.thing != "10", because that will include the "11,1" >entry, which gets me "Joe", which I don't want. You might be able to get away using something like this though it will not be usable with large tables without some other limitations applied: SELECT user.name FROM user

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 br

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] 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 co

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 > l

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] PHP how to compare?

2001-03-14 Thread Ron Brogden
At 10:21 PM 3/14/2001 +0100, Ivo Stoykov wrote: >Try to add this before if statement >echo("$PASS$PASSNOG"); A more accurate way to tell this would be to do the following: echo "\"".$PASS."\",\"",$PASSNOG,"\"\n"; This was you will see embedded spaces and carriage returns which will not be

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 reall

Re: [PHP-DB] SELECT statement

2001-04-04 Thread Ron Brogden
At 03:24 PM 4/4/2001 -0700, Julio Cuz, Jr. wrote: >Every time I run the following code, I get this error if I use a NUMBER >for the 'Email' case: >"Warning: Unable to jump to row 0 on PostgreSQL result index 2 in >/html/rccd/remodel/display2.php on line 35" The problem is that your query is equ

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, creat

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 acce

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 repres

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] I know this has been asked before, but....

2001-04-11 Thread Ron Brogden
At 04:08 PM 4/11/2001 -0700, Ron Brogden wrote: >SELECT column_name, count(*) AS doubles FROM some_table HAVING doubles > 1 >GROUP BY colname Ack, that GROUP BY should be "column_name" (was trying to make it more obvious and missed the last

Re: [PHP-DB] substring_index Part 2

2001-04-12 Thread Ron Brogden
At 11:53 AM 4/12/2001 -0500, you wrote: >Thanks for the help on the earlier ?. Now that I have the select statement >working I can't get any results displayed. You can't print what you haven't asked for. > $result = mysql_query("SELECT substring_index(body, \".\" ,2) FROM > news",$db) or die

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 m

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] 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