[PHP] Maths + MySQL?

[Hypertext]

OK Show me a row like you said:

Columns: amount, id, miscdesc

1: 7.50
2: 7.50
3: 7.50

With three columns? Yet you have 2? Then an example output as in what do you want the code to return to you...

[Calon]

OK Show me a row like you said:

Columns: amount, id, miscdesc

1: 7.50
2: 7.50
3: 7.50

With three columns? Yet you have 2? Then an example output as in what do you want the code to return to you...

I want the code to return me the data of the amount column in a total.

Example output:

£7.70

[Hypertext]

Oh.

Wow. Thats basic.

$amount = array();
$i = 0;
while($row = mysql_fetch_array($query) {
    $amount[$i] = str_replace('£, '', $row['amount']); // get the unicode for sterling sign
    ++$i;
} 

This will create an array of those values.

[Calon]

Oh.

Wow. Thats basic.

$amount = array();
$i = 0;
while($row = mysql_fetch_array($query) {
    $amount[$i] = str_replace('£, '', $row['amount']); // get the unicode for sterling sign
    ++$i;
} 

This will create an array of those values.

<?php
//mysql login code was here lol

$query = mysql_query("SELECT * FROM `money`")
$amount = array();
$i = 0;
while($row = mysql_fetch_array($query) {
    $amount[$i] = str_replace('£, '', $row['amount']); // get the unicode for sterling sign
}  
?>

[Excellent2]

Hypertext forgot to indentate!!

[Calon]

Parse error: syntax error, unexpected T_VARIABLE in /home/calonuk/public_html/money.php on line 6

*Awaits help.*

[Hypertext]

<?php
//mysql login code was here lol

$query = mysql_query("SELECT * FROM `money`")
$amount = array();
$i = 0;
while($row = mysql_fetch_array($query) {
    $amount[$i] = str_replace('£, '', $row['amount']); // get the unicode for sterling sign
}  
?>

<?php
//mysql login code was here lol

$query = mysql_query("SELECT * FROM `money`")
$amount = array();
$i = 0;
while($row = mysql_fetch_array($query) {
    $amount[$i] = str_replace('£', '', $row['amount']); // get the unicode for sterling sign
}  
?>

I missed a closing quote. That should work now.

Hypertext forgot to indentate!!

GTFO.

[Calon]

<?php
//mysql login code was here lol

$query = mysql_query("SELECT * FROM `money`")
$amount = array();
$i = 0;
while($row = mysql_fetch_array($query) {
    $amount[$i] = str_replace('£', '', $row['amount']); // get the unicode for sterling sign
}  
?>

I missed a closing quote. That should work now.


GTFO.

<?php
mysql_connect( 'localhost', 'calonuk_trains', '*******' ) or die(mysql_error());
mysql_select_db( 'calonuk_website' ) or die(mysql_error());

$query = mysql_query("SELECT * FROM `money`")
$amount = array();
$i = 0;
while($row = mysql_fetch_array($query) {
    $amount[$i] = str_replace('£', '', $row['amount']); // get the unicode for sterling sign
}  

?>

Doesn't seem to be working.

any table stuff or something? I'm really tired and cant think

[Excellent2]

GTFO.

Yeah, you don't like it when people hit back at you do you?

[Calon]

Yeah, you don't like it when people hit back at you do you?

Please don't flame.. I really need help and you're not helping.