Re: [PHP] Picking up Data of Previous Date from Table

On Mon, Jul 29, 2002 at 01:03:55AM -0700, Thomas Edison Jr. wrote: > > SELECT * FROM transactions,holdings where > transactions.isinno=holdings.isinno AND > transactions.clientid='$clientid' AND > holdings.clbal!=0 GROUP BY holdings.isinno ORDER BY > shares > > Now for this purpose i'm facing a s

[PHP] Picking up Data of Previous Date from Table

Glory! I have one Table (Transactions), having a Date Column, with date stored as -MM-DD I have another Table (Holdings), having a Date Column, with date stored as -MM-DD Now i'm joining the two tables, to get data from both the tables and display on the page. The query i'm using is som