RE: [PHP-DB] Quarter question..

2002-11-04 Thread joakim . andersson
$sql = select quarter($qdate) or die(not work #3); change to $sql = select quarter($qdate) as my_quarter; //Added an alias to quarter($qdate). Easier to access that way... And there's no need for an 'or die()' here. You're just assigning a variable and most likely this will allways work! $yyy

RE: [PHP-DB] Quarter question..

2002-11-04 Thread joakim . andersson
printf(tda href=\%s?id=%sdelete=yes\Delete/a/td, $PHP_SELF, $myrow[id]); printf(tda href=\%s?id=%ssubmit=yes\Update/tdtd%s/tdtd %s/tdtd %s/td/a/tr, update-inv.php, $myrow[id], $myrow[name], $myrow[details], $yyy); My bad. Before this printf statement you need $my_var =

Re: [PHP-DB] Quarter question..

2002-11-04 Thread Jason Wong
On Monday 04 November 2002 19:58, [EMAIL PROTECTED] wrote: $sql = select quarter($qdate) or die(not work #3); change to $sql = select quarter($qdate) as my_quarter; //Added an alias to quarter($qdate). Easier to access that way... And there's no need for an 'or die()' here. You're just

RE: [PHP-DB] Quarter question..

2002-11-04 Thread joakim . andersson
On Monday 04 November 2002 19:58, [EMAIL PROTECTED] wrote: $sql = select quarter($qdate) or die(not work #3); change to $sql = select quarter($qdate) as my_quarter; //Added an alias to quarter($qdate). Easier to access that way... And there's no need for an 'or die()' here. You're

Re: [PHP-DB] Quarter question..

2002-11-04 Thread Jason Wong
On Monday 04 November 2002 22:56, [EMAIL PROTECTED] wrote: I might have been unclear in my reply. Sorry, I was following this thread on and off and probably misinterpreted your post. The original code had an 'or die()' on $sql = select... aswell and that is, in my opinion, rather