FUDforum: comp.lang.php

Home » Imported messages » comp.lang.php » MAX(id)

Show: Today's Messages :: Polls :: Message Navigator

Re: MAX(id) [message #177255 is a reply to message #177254]

Thu, 01 March 2012 18:38

Michael Fesser
Messages: 215
Registered: September 2010

Karma:

Senior Member

.oO(cerr)

> I have a query to figure out the max ID in a table. The code looks
> like this:
> $subquery = "SELECT MAX(id) FROM `xymply_markers`";
> if (!$subresult = mysql_query($query)){
> die('Error: ' . mysql_error());
> }
> if($max = mysql_fetch_array($subresult)){
> var_dump($max);
> }
> Now this query gives me a nice result in phpMyAdmin but here I get a
> sh*tload of data from my var_dump(), why is that?

What is a "sh*tload" of data? How much and what do you get?

From your usage of mysql_fetch_array() I would expect an array with two
elements as the result.

> How do I correctly read out the highest id number?

See the manual for how to control what mysql_fetch_array() returns.
Or use another mysql_fetch_* function.

Micha

--
http://mfesser.de/blickwinkel

Report message to a moderator

[Message index]

		MAX(id) By: cerr on Thu, 01 March 2012 18:30
		Re: MAX(id) By: Michael Fesser on Thu, 01 March 2012 18:38
		Re: MAX(id) By: cerr on Thu, 01 March 2012 19:01

Previous Topic:	javascript, XmlHttpRequest, PHP, and daemon
Next Topic:	Name of page itself?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 07:47:23 GMT 2024

Total time taken to generate the page: 0.04062 seconds