[PHP-DB] sorting tables

2002-05-03 Thread nauti
Hi everybody I am doing a select in my oracle DB where i get some records. These records are grouped by product id, cost, etc, and amount sold every month. Then, i show all regs in a table, but as the ORDER BY is done also with the month / year, because i want to show how much every month is

Re: [PHP-DB] sorting tables

2002-05-03 Thread Jason Wong
On Friday 03 May 2002 16:02, nauti wrote: Hi everybody I am doing a select in my oracle DB where i get some records. These records are grouped by product id, cost, etc, and amount sold every month. Then, i show all regs in a table, but as the ORDER BY is done also with the month / year,

[PHP-DB] sql querry problem

2002-05-03 Thread andy
Hi there, I do have 2 tables. One contains an update for the other one. Before inserting I would like to delete all the entries in the old table containing the same country_code like one in the new table. I tryed: delete o.* from Cities_update_imported n, test.cities o where n.country_code =

[PHP-DB] Inserting images in postgres

2002-05-03 Thread sharmad
Hi, I made a table test in postgresql as follows CREATE TABLE test ( number INT; image OID ); but the moment i try to insert an image as a normal user it say it cant do so as a normaal user only superuser (/postgres) can do it. the command for insert is as follows INSERT INTO test

[PHP-DB] MySQL Query

2002-05-03 Thread CM
Hi. I am having trouble after migrating an Access Database to MySQL. Basically the Access query I was using for my application was: SELECT Periode.LibPeriode, PaysPeriode.RefPaysPeriode, PaysPeriode.DateDebut, PaysPeriode.DateFin FROM Periode INNER JOIN (Pays INNER JOIN PaysPeriode ON

Re: [PHP-DB] MySQL Query

2002-05-03 Thread Alnisa Allgood
At 1:01 PM +0100 5/3/02, CM wrote: SELECT Periode.LibPeriode, PaysPeriode.RefPaysPeriode, PaysPeriode.DateDebut,PaysPeriode.DateFin FROM Periode, PaysPeriode, Pays WHERE Pays.RefPays = PaysPeriode.Refpays AND Periode.RefPeriode = PaysPeriode.RefPeriode AND PaysPeriode.DateDebut 2002020700

RE: [PHP-DB] sql querry problem

2002-05-03 Thread Ryan Jameson (USA)
the ansi syntax for delete is delete from table where ??? You don't tell it what to delete since it will always delete whole rows. So just remove o.* . If you are in need of setting a field to blank you'll have to use an update, not a delete. Ryan -Original Message- From: andy

[PHP-DB] indexing

2002-05-03 Thread Steve Bradwell
Hi all, More of a database question here, my apologies: I've been doing some reading on indexes but I thought I should get an experienced persons input. My question is about Over Indexing. I have a MySQL MyISAM table that stores inventory transactions, in, out etc. I store numeric fields that

RE: [PHP-DB] indexing

2002-05-03 Thread Ryan Jameson (USA)
I could be wrong but I seem to remember that Primary keys are indexed automatically. Regardless, smallints and dates really are pretty easy to index. So go for it! Strings introduce a bit of overhead, but I've never heard anyone, nor would I, recommend holding back on indexing because you have

[PHP-DB] Can´t connect on Mysql server

2002-05-03 Thread Jaciane
I have a aplication (PHP) into server Apache that needs to read a database Mysql in another server IIS/win2000). These servers are in diferent LAN. This aplicattion has a perffect funcionality into LAN where is the database, but when we try with remote conetion it doesn´t. The mensage is that:

[PHP-DB] teste

2002-05-03 Thread Jaciane
s -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] sql querry problem

2002-05-03 Thread szii
Delete from does not work with multiple tables, AFAIK.. -Szii - Original Message - From: andy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 03, 2002 2:02 AM Subject: [PHP-DB] sql querry problem Hi there, I do have 2 tables. One contains an update for the other one.

RE: [PHP-DB] sql querry problem

2002-05-03 Thread Ryan Jameson (USA)
That too... :-) You'll have to do two deletes, if your referential integrity is set up you'll have to delete the children before you can delete the parent as well. Thanks Szii.. I missed that part. Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent:

[PHP-DB] translating password($var) back to text

2002-05-03 Thread John Hughes
I am setting up a PHP-mySQL login script. One key feature I need is the ability automatically to e-mail people their password when they forget it. Obviously, I can store the password without using password() and retrieve it at any time. Is it possible to store the password using password() and

Re: [PHP-DB] translating password($var) back to text

2002-05-03 Thread Paul DuBois
At 15:47 -0700 5/3/02, John Hughes wrote: I am setting up a PHP-mySQL login script. One key feature I need is the ability automatically to e-mail people their password when they forget it. Obviously, I can store the password without using password() and retrieve it at any time. Is it possible to