L

[mrherman]

Greetings,

 

I have a simple MySQL query which give me only one result, an integer.

 

Is there a simpler way to extract the value of "nMaxunit" rather than having to do a "while" loop and a "foreach" loop?

 

A second question is that "{$c_keytable}" seems to work the same as $c_keytable (without the brackets).  Which is preferable?

 

Thanks!

 

$sql = "SELECT MAX( riounit ) AS nMaxunit
          FROM {$c_keytable}" ;
$result = mysql_query ( $sql ) or die ("no result") ;

while ( $row = mysql_fetch_array ( $result ) )
{
   foreach ( $row as $key => $value )
      {
         $max_riounit = $value ;
      }
}

[Pikachu2000]

You can simply not include the loop, or use mysql_result().

[kenrbnsn]

Just get the value:

<?php
$sql = "SELECT MAX( riounit ) AS nMaxunit
          FROM {$c_keytable}" ;
$result = mysql_query ( $sql ) or die ("no result") ;
$rw = mysql_fetch_assoc($result);
$max_riounit = $rw['riounit'];
?>

 

Ken

[mrherman]

Wow, that was fast.  Thanks for the replies. 

 

I looked at mysql_result, but couldn't hang with it mentally.  What would the solution look like if I used "mysql_result()"?

 

Also, what about the brackets in the variable table name? 

 

 

[Pikachu2000]

It's been a long time since I've used mysql_result() myself; I use mysql_fetch_assoc() for nearly everything. I didn't test this, but I think it's a correct example

 

$query = "SELECT MAX(`id`) FROM table";
$result = mysql_query($query);
$value = mysql_result($result);

[mrherman]

Thanks!  That helps -- I'll experiment with it.