Re: [PHP-DB] apostrophe

2001-02-19 Thread CC Zona
In article <01cd01c09b0d$7f247630$0101a8c0@server>, [EMAIL PROTECTED] ("Pankaj Ahuja") wrote: > 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 ?? Escape it with a slash: " manufacturer

[PHP-DB] apostrophe

2001-02-19 Thread Pankaj Ahuja
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: [EMA

Re: [PHP-DB] members page

2001-02-19 Thread Timothy Aslat
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 l

[PHP-DB] members page

2001-02-19 Thread Brandon Feldhahn
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 PROTECTED

[PHP-DB] Deleting single record

2001-02-19 Thread John Miller
>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,

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

2001-02-19 Thread Timothy Wright
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 day

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

2001-02-19 Thread JJeffman
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 wh

Re: [PHP-DB] Hide Files

2001-02-19 Thread Darryl Friesen
> && ($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'. - Darr

Re: [PHP-DB] composite keys

2001-02-19 Thread JJeffman
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: <[E

Re: [PHP-DB] Hide Files

2001-02-19 Thread CC Zona
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

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_

[PHP-DB] Inserting arrays into a database

2001-02-19 Thread Kyle Mathews
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 join

[PHP-DB] Hide Files

2001-02-19 Thread Fusion
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] running PHP from the cron

2001-02-19 Thread Mark @ 10base-T
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] user authentication

2001-02-19 Thread Free Beachler
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 ses

Re: [PHP-DB] Help :)

2001-02-19 Thread fabrizio . ermini
On 19 Feb 2001, at 12:54, Fusion wrote: > > Hey can somone show me how to make something to list all files in a = > directory spedified ? > Check this out: http://www.php.net/manual/en/function.readdir.php HTH! /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ Fabrizio Ermini

[PHP-DB] Help :)

2001-02-19 Thread Fusion
Hey can somone show me how to make something to list all files in a directory spedified ? fread?

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

2001-02-19 Thread Lennin Arriola
I used to do this: function nice( $value ) { if ($value=="") { return "- "; } 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 comma

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

2001-02-19 Thread fabrizio . ermini
> > 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 analog

[PHP-DB] Suppressing NULL values in search results

2001-02-19 Thread Cameron Metcalf
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 th

Re2: [PHP-DB] Windows 2000 follow up

2001-02-19 Thread Fusion
> > 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/

RE: [PHP-DB] Windows 2000 follow up

2001-02-19 Thread Mark Newnham
> 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.. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To con

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

2001-02-19 Thread Mark Newnham
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

[PHP-DB] Windows 2000 follow up

2001-02-19 Thread Fusion
Hey I have checked out some of the user options but where would I go about changing them for secure modes? Also i hear that running a server on windows 2000 is just as good if not better then unix.. Thanks.. Michael

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

2001-02-19 Thread Simon R Jones
> 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 se

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

2001-02-19 Thread Nicholas W. Miller
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 secure

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

2001-02-19 Thread Simon R Jones
> > 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. > > D

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

2001-02-19 Thread Lennin Arriola
IMHO, I don't think you can doit on PHP, you may have to do it outside PHP, for instance in java, java has multithreading, and then you might access it through PHP, Lennin Arriola [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] Fo

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

2001-02-19 Thread David Benson
> 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 els

[PHP-DB] running PHP from the cron

2001-02-19 Thread Simon R Jones
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 is

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

2001-02-19 Thread Pedro M. S. Oliveira
hello all! i was wondering how to do a php script that works like this. i need to make an update to a database but at the same time i need to make a query to another database. the update and the query doesn't have anything to do with each other, they just need to run both in a paralel way. i was

Re: [PHP-DB] composite keys

2001-02-19 Thread Lennin Arriola
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 compos

Re: [PHP-DB] SQL Select statement

2001-02-19 Thread Lennin Arriola
> 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 tabl

RE: [PHP-DB] CONNECT BY & PHP problem

2001-02-19 Thread David Benson
> 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 wit

[PHP-DB] CONNECT BY & PHP problem

2001-02-19 Thread Mirko Cegledi
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 stat

Re: [PHP-DB] Oracle & WinNT4/2000

2001-02-19 Thread Jorge Santos
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] composite keys

2001-02-19 Thread Russ Michell
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' & 'T

[PHP-DB] cgi redir

2001-02-19 Thread Free Beachler
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 admi