capturing

[Danny620]

 <?php require('settings/control.php');
	require('lib/lib.php');


// Query the database:
	$q = "SELECT MAX(id) FROM users";		
	$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

	$max_id = mysqli_fetch_array($r);

	echo $max_id[id]; 


?>

 

it should echo 13 as thats the highest id but it does'tn

[mikesta707]

try

$q = "SELECT MAX(id) as maxID FROM users"
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));     
$max_id = mysqli_fetch_array($r);      
echo $max_id['maxID'];

 

it would help if you also said what that code echoed

[Garethp]

Well, I'd use

 

$q = "SELECT * FROM `users` ORDER BY `id` DESC LIMIT `";
$r = mysql_query($q);
$r = mysql_fetch_array($r);
echo $r['id'];