how to add 1 to this query

Discussion in 'PHP' started by dougvcd, Apr 22, 2009.

0
  1. #1 
    $sql = "select count(*) from register";
$st = mysql_query($sql) or die(mysql_error());
echo "<p>Rename your photo before sending to pic " . mysql_result($st, 0, 0) . "</p>";
    PHP:
    how do i get $st +1
    cheers
    Doug
     
    dougvcd, Apr 22, 2009 IP
  2. koko5

    koko5 Active Member

    Messages:
    394
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    70
    #2 
    $sql = "select count(*)+1 from register";
    PHP:
    :cool:

    Edit: or 
    ...(intval(mysql_result($st, 0, 0))+1)...
    PHP:
     
    koko5, Apr 22, 2009 IP
  3. dougvcd

    dougvcd Peon

    Messages:
    267
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    cheers for that
    Doug
     
    dougvcd, Apr 23, 2009 IP