Re: [PHP-DB] Backups, best practices

2001-09-07 Thread Tom Carter
> you can get command line zip/compression packages for windows, although for > *some* reason, as far as i know, not a command line version of winzip - the > big one! err.. please correct me if I'm wrong, but isn't pkzip exactly that? or more exactly, winzip is a windows interface to it? it cert

RE: [PHP-DB] Backups, best practices

2001-09-07 Thread Beau Lebens
// > you can get command line zip/compression packages for // windows, although // for // > *some* reason, as far as i know, not a command line // version of winzip - // the // > big one! // // err.. please correct me if I'm wrong, but isn't pkzip // exactly that? or more // exactly, winzip is

Re: [PHP-DB] Stored Procedure

2001-09-07 Thread Thies C. Arntzen
On Tue, Sep 04, 2001 at 07:44:42AM -0800, [EMAIL PROTECTED] wrote: > Hello everyboby! > > this is my first time on this list and I writing to ask for help on SP. > > I have the following code calling a Procedure: > > > > $c=OCILogon("SYSTEM","manager"); > $x =0; > $cpf="10001628852"; >

Re: [PHP-DB] RE: bizarre ocilogon problem

2001-09-07 Thread Thies C. Arntzen
On Wed, Sep 05, 2001 at 10:24:28AM -0500, Brian Mauter wrote: > Are you running out of logons? You should only need the client > libraries on > the machine with the PHP pages. You do not need them anywhere else. > (That's the beauty of the web!) > > Make sure you have ocilogoff in your PHP page

Re: [PHP-DB] user need password

2001-09-07 Thread Curtis Maurand
you can however not use the password function and use the encode and decode function where you can specify your own encryption key. In that way you can decode a password. insert into user (password) values (encode('$password','$passkey')); select decode($password,$passkey) from users where usern

[PHP-DB] Re: Table Search ... HELP

2001-09-07 Thread Jacob Singh
Hello Devon, Thursday, September 06, 2001, 8:41:55 PM, you wrote: D> Below is an example of my code which searches a table and prints the result, D> the problem is that it only displays the TechContact where I want it to D> display all the fields that associated with it in that row off the colum

[PHP-DB] Re: Forms Question

2001-09-07 Thread Doug Granzow
I would think you would want the "name" of your select to be "store" and not "$store". That way the value will be in the variable $store when the form is submitted. Now, as I understand, what you want is for the value of $store from the database to be preselected when the form is displayed. You

[PHP-DB] Checkboxes with mySQL

2001-09-07 Thread Cilfa
I have a database with articles from which I can make a selection of which articles to show. This selection is made by a form with checkboxes. In the mysql table is a field called "pr". If there's a "1" in this field, the article should be shown for print, if there's a "0", it shouldn't. In

[PHP-DB] Re: Checkboxes with mySQL

2001-09-07 Thread Hugh Bothwell
"Cilfa" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > $query = mysql_query("UPDATE articles SET pr='1' WHERE id='$p[id]'"); > > But it does nothing! How can I insert multiple values (from the checkbox > array) at one time in a database? UPDATE articles SET p

RE: [PHP-DB] Checkboxes with mySQL

2001-09-07 Thread Rick Emery
You have to check each checkbox value in you selection criteria. Somthing like: $query = "UPDATE articles SET pr=1 WHERE 0"; # assume $nbr is size of array $p for($i=0; $i<$nbr;$i++) { if( isset($p[$i]) ) { $query .= "|| id=$p[$i] "; } This will construct a query that looks like: UPDAT

[PHP-DB] Don't Leave Any Tracks Behind...

2001-09-07 Thread john wild
FFA Posting Engine..This email address was used to post to our site ! Removal Instructions at the bottom of this page ! Don't Leave Any Tracks Behind... WARNING: Your Computer tracks all of your internet activity and all of the acti

Re: [PHP-DB] PHP linux interbase Apache

2001-09-07 Thread Stephane MOREL
Thank you very much everything work fine now steph Meir Kriheli a écrit : > On Thursday 06 September 2001 18:47, Stephane MOREL wrote: > > Thank you for your answer > > Interbase is installed in /opt/interbase. I don't use --with-apxs. > > What I need now is to eanble connection to interbase th

[PHP-DB] problem with dbase connections using ODBC

2001-09-07 Thread Don Jackson
Windows NT 4.0 workstation Apache PHP 4 the following code works fine and returns the correct results... "; } odbc_close($connect); ?> --- but if someone else

[PHP-DB] DB design question (so maybe a little OT)

2001-09-07 Thread Alexander Deruwe
Hey all, I have 4 database tables, that each describe some sort of 'person' (transporting company, truck-driver, ..) and have almost exactly the same fields. Is this the best way of storing this, or does this make more sense: One table, with all the same fields + 1 extra, noting the type of pe

Re: [PHP-DB] DB design question (so maybe a little OT)

2001-09-07 Thread Justin Buist
On Fri, 7 Sep 2001, Alexander Deruwe wrote: > I have 4 database tables, that each describe some sort of 'person' > (transporting company, truck-driver, ..) and have almost exactly the same > fields. > Is this the best way of storing this, Nope... > or does this make more sense: > One table, with

[PHP-DB] Re: DB design question (so maybe a little OT)

2001-09-07 Thread Jonathan Hilgeman
I'm thinking that you should get all the common fields among the different types of people: F. Name, L. Name, Address, CC Number And then create a different table containing additional information that only pertains to certain types of people. Then join them using an id. - Jonathan "Alexander

[PHP-DB] Strain testing

2001-09-07 Thread Seb Frost
My website frequently seems to be hugely slow or chuck out loads of php/mysql errors. Initially i thought this the fault of my web hoster, but they're so big and popular I can't believe this is caused by them. Which leads me to think maybe the problems are caused when a certain number of people

Re: [PHP-DB] DB design question (so maybe a little OT)

2001-09-07 Thread Doug Semig
Hi Alexander-- I see folks have already answered your question. However, I would like to mention why what you're doing is not-so-great. How would you search your current db for a person? You have to Union all the tables together to do what would otherwise be a simple search, or fire off four S

[PHP-DB] Re: Does PHP work with Sybase ASA?

2001-09-07 Thread Bruno Franx
Yes! I'm working fine with ASE, Php4 and Apache web-server, check your php.ini for the "extension=php_sybase_ct.dll" line and nice days... "Davor Pleskina" <[EMAIL PROTECTED]> ha scritto nel messaggio [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I mean, is there in PHP support for Sybase Adap