using WHERE and OR in a query

2006-02-25 Thread Bruce Therrien
Why does this query not work using mysql 3.23.58? The query is updating all records with no regards to the WHERE clauses. Do I need to do separate updates for each WHERE clause? $SQL =<do($SQL) || &cgierr("Reason: $!"); -- Bruce Therrien <[EMAIL PROTECTED]> This is

using WHERE and OR in a query

2006-02-25 Thread Bruce Therrien
Why does this query not work using mysql 3.23.58? $SQL =<do($SQL) || &cgierr("Reason: $!"); -- Bruce Therrien <[EMAIL PROTECTED]> This is the end of the internet. Please turn around and go back. -- MySQL General Mailing List For list archives: http://lists.mysql.c

Counting total files

2003-11-30 Thread Bruce Therrien
We have a database that has a quantity of files listed for each client record. We can count the number of clients, but how do we count the total number of files for all clients combined? -- Bruce Therrien <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives

Re[2]: Retrieving info from a Joined column

2003-11-29 Thread Bruce Therrien
repare ( $query ); $sth->execute ($downloads,$user); Any ideas? On Sat, 29 Nov 2003 00:53:10 +0100 "Hans van Harten" <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > >> From: Bruce Therrien <[EMAIL PROTECTED]> > >> Date: 2003/11/28 Fri PM

Retrieving info from a Joined column

2003-11-28 Thread Bruce Therrien
for all database entries and retrievals. Sample data 1223:1897:9807:36754:20875 Thanks, -- Bruce Therrien <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Selecting a date

2003-09-27 Thread Bruce Therrien
Using a select statement, how does one select all records that have a date one day less than the current date? Searching the archives and I can't seem to find the answer.. Our database has these fields: EMAIL, AMOUNT, ID, DATE The date is in format 00/00/ Thanks -- Bruce The