Anyone good at WML ?

[orientalexpress]

Hi there everyone

I have a database with 15 tables in my database format
address ccn expirydate securitycode amount

I would like to display a table that will name all 15 tables and the sum of amount
so eg

table 1 456
table 2 465
table 3 987
.
.
table 15 432

I think it might be like SELECT * TABLES, SUM(amount); ORDER TABLES

any ideas ?

How would i use php to display it like that
I have this already and it doesnt work

<?PHP

 mysql_pconnect('localhost','admin','admin');

mysql_select_db("wml");

   $results = mysql_query("SELECT * TABLES, SUM(amount); ORDER TABLES");

   if ($results){

       while ($a = mysql_fetch_array($results)) {

        echo'<TABLE><TR>
              <TD>'.$a['name'].'</TD>
              <TD>'.$a['amount'].'</TD>
	     </TR></TABLE>';
       };

       print("</TABLE>");

       } else {

       print("No results to display");

       };
?>

any ideas ? thanks guys

[orientalexpress]

.

[Win2Win]

I can program in it yes, but having just got out of bed with my happy pill still working....waaaaaay too early to engage the brain in realism!! :)

I'll look this afternoon.

I know I'd write it different though, get the row count & use a For loop.

[orientalexpress]

I can program in it yes, but having just got out of bed with my happy pill still working....waaaaaay too early to engage the brain in realism!! :)

I'll look this afternoon.

I know I'd write it different though, get the row count & use a For loop.

Id be so muc happier at christmas if this gets done by then, gotta be down kent for 3 days so no work till them :(

[Win2Win]

Is your mysql_query calling the right data? As that is not the way I'd do it. Try calling it direct in myphpadmin & see if it gives the data out correctly.

The way I do it is;

	$query = "SELECT indexx,time,meeting,date,odds FROM `dbONE` ORDER BY indexx ASC"; 
	$ans = mysql_query($query);

[orientalexpress]

 $results = mysql_query("SELECT * TABLES, SUM(amount); ORDER TABLES");

Im trying to call that but i know its incorrect.

SELECT indexx,time,meeting,date,odds FROM `dbONE` ORDER BY indexx ASC";

that would only give the columns for table dbONE.

How do i get it to to display 15 table names and the SUM for column amount ?
Im basically naming the table name and displaying sum of that column

eg it might be

dbONE 465
dbTWO 465798
dbTHREE 987798

[Win2Win]

This explains better than me waffling on :D
http://www.daniweb.com/forums/thread26446.html