Home »
Imported messages »
comp.lang.php »
MAX(id)
| Re: MAX(id) [message #177256 is a reply to message #177255] |
Thu, 01 March 2012 19:01  |
cerr
Messages: 33
Registered: September 2010
Karma:
|
Member |
|
|
On Mar 1, 10:38 am, Michael Fesser <neti...@gmx.de> wrote:
> .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.
That's what I would have expected too...
>
>> 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.
Yep,
my bad. Figured it out...
Thanks for your time anyways!
--
cerr
www.inetgate.ca
|
|
|
|
Current Time: Sun Dec 01 01:21:41 GMT 2024
Total time taken to generate the page: 0.04206 seconds
Calendar
Search
Help
Members
Register
Login
Home
]