RE: [PHP-DB] Re: Handling database calculations with a php page

2005-03-22 Thread JeRRy
Thankyou :) --- Bastien Koert <[EMAIL PROTECTED]> wrote: > Yes, the 'a' value can also be a table alias name. > > Bastien > > >From: JeRRy <[EMAIL PROTECTED]> > >To: php-db@lists.php.net > >Subject: [PHP-DB] Re: Handling database > calculat

RE: [PHP-DB] Re: Handling database calculations with a php page

2005-03-14 Thread Bastien Koert
Yes, the 'a' value can also be a table alias name. Bastien From: JeRRy <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] Re: Handling database calculations with a php page Date: Mon, 14 Mar 2005 19:46:46 +1100 (EST) Hi, So in other words when we are talking queries a

Re: [PHP-DB] Re: Handling database calculations with a php page

2005-03-14 Thread Miles Thompson
That's the convention. You HAVE TO: - read and use the manual, the rest of us do - dig out and follow a tutorial on working with PHP and databases If you do not, you will have no real knowledge of what you're doing, only a piecemeal "Someone said to do it this way." Do this BEFORE

[PHP-DB] Re: Handling database calculations with a php page

2005-03-14 Thread JeRRy
Hi, So in other words when we are talking queries anything before a . for SELECT etc means table name and after the . means column name within that table? So... (table_name).(Column_name) ? Is that right? J Find local movie times and trailers on Yahoo! Movies. http://au.movies.yahoo.com --

Re: [PHP-DB] Re: Handling database calculations with a php page

2005-03-13 Thread Miles Thompson
First of all, check the SELECT statement in your database documentation, because you do this within your select. It is important you that you inform yourself about this, because you will use it a lot. So this is not really a PHP question. The statement is written something like this: SELECT a.c

[PHP-DB] Re: Handling database calculations with a php page

2005-03-13 Thread JeRRy
> What is the best PHP code to use for this inside a > PHP > code? I meant ... What is the best PHP code to use for this inside a PHP page/file. (e.g. calculate.php) Also the total of the 3 tables should than be updated to a 4th table which I did not mention. So the total of table 1, 2 and