Not getting MAX(#)

[Tessa]

Any clues to offer? Trying to find current high number and add 1 to it, but doesnt work.

Thanks.

[PHP CODE]

$sql4 = "SELECT MEMBER_ID from MEMBER where MEMBER_ID = (select MAX(MEMBER_ID) from member";

$result4 = mysql_query($sql4);
$NewMemberId = $result4 + 1;

[barand]

A couple of problems here.

1. MySQL doesn't support subqueries.

2. You are trying to add 1 to a query result set, not a field value!

You need a sepqrate query to find the max value

$sql4 = "select max(member_id) as maxid from member";
$result4 = mysql_query($sql4);
$row = mysql_fetch_array($result4);
$NewMemberId = $row["maxid"] + 1;

[ednark]

barand is exactly right

but you can also push the +1 into sql if you so wished

$sql4 = "select max(member_id)+1 as maxid from member";

[Tessa]

thanks tons....will try first thing in morning....I love that you guys know the answers for us newbies...hehe. I can only aspire!