[PHP-DB] cgi redir

thanks y'all the header("location: blahblahblah..."); worked for my cgi-redirect question! Thanks for the crucial help! -f -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

[PHP-DB] composite keys

Hi all: I am using php4.0.3pl1 with MySQL 3.22.32 on Apache for RH Linux. I have a table/relation of sports, where amongst other categories, are teams, where there can be many 'teamNames' 'teamInfos' for one sport. The problem here is that without the use of a composite key: 'sportName'

Re: [PHP-DB] Oracle WinNT4/2000

Randall, Apparently I mis-understood you. I thought you meant upgrade the servers... Yes we can upgrade the client. Do you have a URL available for the 8.1.6 version of the client... Thanks. Later, Jorge [EMAIL PROTECTED] - Original Message - From: Randall Barber [EMAIL PROTECTED] To:

[PHP-DB] CONNECT BY PHP problem

Hello there! I'm new to this list and I've got a problem ;). Have I to introduce myself? Anyway, here it is: I'm using an oracle database to store hierarchic data in a single table. With HORA, it is no problem to display the hierarchic structure via the CONNECT BY clause. I tried the same

RE: [PHP-DB] CONNECT BY PHP problem

With HORA, it is no problem to display the hierarchic structure via the CONNECT BY clause. I tried the same statement in PHP3 and it I'm using php4pl1 with Oracle 8.1.6 and this works: select c.cvsn_id, c.parent_cvsn_id, level from cvsn c where start with

Re: [PHP-DB] SQL Select statement

I want to find out which memberIDs have BOTH choice 2 AND choice 3. -- SELECT memberID from table where choice=2 AND choice = 3 That won't work (0 results, of course, because no row has two choices, they're mutually exclusive) Exactly, keep several rows for choices, have two tables

Re: [PHP-DB] composite keys

Russ: Keep an independent key, for instance a field called ID, with auto-counter. That will make your rows uniquely identified... then if you want to search for a player in a specific team, and a specific sport, just with a query select * from players where team = t?, sport=? no need for

[PHP-DB] running PHP from the cron

hi there, I have PHP installed as an Apache module and I can't have it as CGI.. now I'm looking into ways to run PHP scripts off the cron, and I saw that PHPAds does a fetch command to parse the script on a regular basis. I'm just wondering if anyone else out there has had to do this, and what

RE: [PHP-DB] running PHP from the cron

I have PHP installed as an Apache module and I can't have it as CGI.. now I'm looking into ways to run PHP scripts off the cron, and I saw Rebuilt php again and don't specify the apache configuration option. This will build php as a CGI program which you can then use in cron. Does anyone else

RE: [PHP-DB] running PHP from the cron

Hello, I run my PHP crons like this: 0 6 * * * /usr/local/bin/lynx -source "http://www.domain.com/file.php" This is not the most secure of course, as the file is below the root and could be hit by any user. But works for my particular case ... Anyone know of a method to make this more

RE: [PHP-DB] running PHP from the cron

I run my PHP crons like this: 0 6 * * * /usr/local/bin/lynx -source "http://www.domain.com/file.php" This is not the most secure of course, as the file is below the root and could be hit by any user. But works for my particular case ... Anyone know of a method to make this more secure

RE: [PHP-DB] runing a query and a another task at the same time

I may be mistaken, but I believe that something as simple as calling a javascript window.open function effectively starts a parallel process, i.e. it is a non-blocking operation in a browser heres the sample code i used to test it. 1. A frameset with 2 frames, A and B. frame A has src=test1.php

Re2: [PHP-DB] Windows 2000 follow up

Also i hear that running a server on windows 2000 is just as good if not better then unix.. Oh god, let's not get started on that.. -- lol oh well.. hey do you know how to fix up the securit for internet users? -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Suppressing NULL values in search results

Hey, I've been using PHP for 'bout a month and my programming abilities are pretty limited. I'm using a script (further below) to retrieve results from a MySQL database. It's intended to retrieve potentially 6 fields of information. Some of these fields in the record, though, may be NULL, but

Re: Re2: [PHP-DB] Windows 2000 follow up

Oh god, let's not get started on that.. lol oh well.. hey do you know how to fix up the securit for internet users? Maybe you could be able to configure different virtual directory to run under the right of different users. If this is not possible you have to find Win2000 analogous

Re: [PHP-DB] Suppressing NULL values in search results

I used to do this: function nice( $value ) { if ($value=="") { return "-nbsp;"; } else return $value; } print nice($row["company"]) Lennin Arriola [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

[PHP-DB] Help :)

Hey can somone show me how to make something to list all files in a directory spedified ? fread?

[PHP-DB] user authentication

Hi all, I'm still trying to get my site to work just right. Basically I'm building a "secure" portal. What I want to do is: 1) get user info from form 2) submit name password to query template 3) query template checks login::: i) if good - needs to... a) initialize this user's

Re: [PHP-DB] running PHP from the cron

Maybe this will help, I use lynx -d to do some stuff on the database every day. Basically, I just made a php page that does the thing I need to do in the database and it doesn't generate any output. My command is lynx -d http://website/phppage.php Hope this helps. Marky From: "Simon R Jones"

[PHP-DB] Hide Files

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?

[PHP-DB] Inserting arrays into a database

Hello: I'm wondering what is the best way to insert an array into a database table. As well as the best way to extract and show that information. The information that I'd be inserting is a bunch of id numbers for data in another table. So when getting the information, I'd like to do a table

Re: [PHP-DB] Hide Files

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

Re: [PHP-DB] Hide Files

In article 000c01c09ac2$7ed27ab0$0100a8c0@fusion, [EMAIL PROTECTED] ("Fusion") 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?

Re: [PHP-DB] composite keys

MySQL do support composite keys . Have a look on the mysql database structure the "columns_priv" table has 5 fields in its primary key. I think you should use an auto_increment as your primary field instead. HTH. Jayme. -Mensagem Original- De: Russ Michell [EMAIL PROTECTED] Para:

Re: [PHP-DB] Hide Files

($file_name !="*.php") how come that still displays all the *.php files? Because that's an exact string match for a file called '*.php' which probably doesn't exist. Try some thing like (substr($file_name, -4) != '.php') That should exclude all files ending in '.php'. - Darryl

Re: [PHP-DB] Inserting arrays into a database

Try use a delimited string and split it on retrieve. HTH. Jayme. -Mensagem Original- De: Kyle Mathews [EMAIL PROTECTED] Para: [EMAIL PROTECTED] Enviada em: segunda-feira, 19 de fevereiro de 2001 19:35 Assunto: [PHP-DB] Inserting arrays into a database Hello: I'm wondering what is

[PHP-DB] Is there a PHP equivalent of DATE_FORMAT ?

Just wondering... DATE_FORMAT($datevariable, \"%Y%c%e\") works great in a query but I only need to list the date once on the page (as opposed to in each row of the query result) and I don't want to use a second query to MySQL. The date is passed to the page as a variable in md (month and

[PHP-DB] Deleting single record

The following big chunk of code produces the following line: uukjh has been deletedMySql has been selectedDELETE FROM db WHERE Db = uukjhUser Db has failed Which tells me that everything but the delete command does not work. The above line is broken down to database name has been deleted, The

Re: [PHP-DB] members page

Brandon Feldhahn wrote: im making a webdesign website that has a members login, do i have to make a member page for each member or can i get the info from the database of the person whom logged in and put it on the members page You could make individual pages for each member, but it's a lot

[PHP-DB] apostrophe

Is it possible to insert apostrophe into a Mysql database ?? I have a varchar type column and want to insert " manufacturer's" into it. How can I do this ?? Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

[PHP-DB] members page

im making a webdesign website that has a members login, do i have to make a member page for each member or can i get the info from the database of the person whom logged in and put it on the members page -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL