Max Statement

irishmaggie

Hi there its me again!

Here's my new problem...

I am trying to retrieve the maximum number entered into my prices table and I run the query, but it either tells me that the result is "Resource id#2" thingy, or it doesn't give me a value at all.
Here is my code:

<?php

$database = mysql_connect("localhost", "user", "password");

$rs=mysql_select_db("db", $database);

$sql="SELECT max(price_id) from prices";

$result=mysql_query($sql)or die (mysql_error());

while ($row = mysql_fetch_array($result)) {

     $priceid = $row['price_id'];
     echo "YOUR PRICE ID IS $result PLEASE WRITE DOWN OR     RETAIN THIS NUMBER AS IT WILL BE REQUESTED LATER ON IN THE BOOKING PROCESS<br><br>";

$rs2=mysql_query($sql)or die (mysql_error());
}
?>

Can you please tell me what I am doing wrong, I cannot see the problem?????

Your help would be very much appriciated!
Regards,
irishmaggie!*

irishmaggie

Sorry I meant:

while ($row = mysql_fetch_array($result)) {
$priceid = $row['price_id'];
echo "YOUR PRICE ID IS $priceid PLEASE WRITE DOWN OR RETAIN THIS NUMBER AS IT WILL BE REQUESTED LATER ON IN THE BOOKING PROCESS ";
}

ccgorman

echo "YOUR PRICE ID IS $result PLEASE WRITE DOWN OR RETAIN THIS NUMBER AS IT WILL BE REQUESTED LATER ON IN THE BOOKING PROCESS ";

should be

echo "YOUR PRICE ID IS $priceid PLEASE WRITE DOWN OR RETAIN THIS NUMBER AS IT WILL BE REQUESTED LATER ON IN THE BOOKING PROCESS ";

and I don't know why you have this in the while:

$rs2=mysql_query($sql)or die (mysql_error());

laserlight

maybe try:

<?php

$database = mysql_connect("localhost", "user", "password");
if (!mysql_select_db("db", $database)) {
	exit("Error: could not select database!");
}

$result = mysql_query("SELECT max(price_id) from prices") or die(mysql_error()); 

while ($row = mysql_fetch_array($result)) {
	$priceid = $row['price_id']; 
	echo "YOUR PRICE ID IS $priceid PLEASE WRITE DOWN OR RETAIN THIS NUMBER AS IT WILL BE REQUESTED LATER ON IN THE BOOKING PROCESS<br><br>\n"; 
}
?>

and see?

tomhath

If you want to refer to the column by name, you have to give it a name :eek:

SELECT max(price_id) AS price_id from prices

irishmaggie

Thanks a million for all your replys,
Thanks especially to "tomhath", you got it in one...I never knew that before!
Chat later!
irishmaggie!*