[YamiKaitou]

PHP Code:

$result = mysql_query("SELECT * FROM accounts ORDER BY account DESC");
$accountid = mysql_result($result, 0, 'account'); 


For more info about the mysql_result function, visit here

[Jheshka]

Heh, I got it right before you answered...

PHP Code:

$result = mysql_query("SELECT * FROM accounts ORDER BY account DESC");
$row = mysql_fetch_array($result);
$highest = $row['account'];
//    echo $highest; 


One last(I hope) question..

When outputting a string (include various queries) is it possible to indent the strings to make it easier to read?


I have it outputting as

PHP Code:

    $result = mysql_query("SELECT * FROM `accounts`");

    while($row = mysql_fetch_array($result))
     {
     echo $row['fname'] . ", " . $row['lname'] . ", "  . $row['addr'] . ", " .  $row['email'] .  ", #" . $row['account'] . ", $" . $row['balance'];
     echo "<br />";
     } 


[Lee]

Amusing.

I'm not sure whether YamiKaitou is to blame (i.e. whether he read the applicable sentence), but in future you should describe the problem - and not the problem you're having with what you believe to be the solution.

If you were to use this convoluted method, your first inkling was the correct query.

Multiple spaces: http://www.w3schools.com/html/html_entities.asp
Tabs: <table>

I hope you're not putting this script on a web-accessible server.