Mysql query

[wap3]

Hi

Can somebody tell me why this wont work. It is supposed to fecth the highest value in the field Item_id.

It wont work though. It just returns 'no' which I put there to see if it wasn't retreiving anything ??

Thanks

PHP Code:

function display_add_item_form() {
$conn = db_connect(); //connect to database
$query = mysql_query("SELECT Item_id FROM products ORDER BY Item_id DESC LIMIT 1");
$result = mysql_query($query);
if (!$result)
    echo "no";
$newid = $result;
print ("$newid");
} 


[Wichetael]

you're calling mysql_query two times, you should not do that. Instead you should directly assign the return value of the first mysql_query call to $result like so:

PHP Code:

$result_=_mysql_query("SELECT Item_id FROM products ORDER BY Item_id DESC LIMIT 1"); 


Though you will have to make another call to fetch the actual data from the result. with one of the mysql_fetch_* calls, take a look at the php manual here

btw, do try to use a more descriptive subject line next time, Thank you.

[bcarl314]

Yep,

basically change your $resutt line to
$result = mysql_fetch_assoc($query);

then you can access the fileds this way
$newid = $result['Item_Id'];

[Spookster]

No need to get all fancy:


[php]

function display_add_item_form() {
$conn = db_connect(); //connect to database
$query = "SELECT Item_id FROM products ORDER BY Item_id DESC LIMIT 1";
$result = mysql_query($query);
if (!$result)
echo "no";
$newid = $result;
print ("$newid");
}