过期日期和会员查询 - Expiration date and membership query

这个更新过期和成员关系有什么问题?

      $unit = "Days";
      $length = "1";
      $newExpire = strtotime("+{$length} {$unit}");
      $sqlz  = "UPDATE users SET expire ='$newExpire' WHERE username ='{$_POST['custom']}'";
      $sql  = "UPDATE users SET membership ='14' WHERE username ='{$_POST['custom']}'";
      $retval = mysql_query( $sqlz, $sql, $conn );

你的mysql_query参数是错误的，所以不支持多个查询，更改

$retval = mysql_query( $sqlz, $sql, $conn );

$retval = mysql_query($sql, $conn );

您需要为每个查询单独运行mysql_query