# Max (php)

**URL:** <https://forum.kirupa.com/t/max-php/193087>\
**Category:** Uncategorized\
**Created:** [July 4, 2006, 8:58am UTC](https://forum.kirupa.com/t/max-php/193087 "2006-07-04T08:58:07Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![hyacinth](https://avatars.discourse-cdn.com/v4/letter/h/779978/32.png) [@hyacinth](https://forum.kirupa.com/u/hyacinth)\
**Post date:** [July 4, 2006, 8:58am UTC](https://forum.kirupa.com/t/max-php/193087/1 "2006-07-04T08:58:07Z")

</div>

![](http://forum.kirupa.com/uploads/kirupa/2584/4895264a91f02edb.gif)

$query = “SELECT MAX(views) FROM ims\_image where u\_id = ‘$u\_id’”;  
$result\_resource = mysql\_query($query);  
$data = mysql\_fetch\_row($result\_resource);

$mostpic = mysql\_fetch\_assoc(mysql\_query(“SELECT \* FROM ims\_image WHERE u\_id=’$u\_id’ AND views=’$data[0]’”));  
echo" $mostpic[i\_id]";

I want to show “76” but somehow it show"75"!!!  
anyone helps???