Syntax for adding value to variable within a MySQL query...

[cgm225]

I have the following MySQL query::

 

"SELECT * FROM images WHERE album = $album_id ORDER BY timestamp DESC LIMIT $upper_limit, 1"

 

but if I want to query it with the limit value of ($upper_limit + 1), what is the syntax for querying with that resulting sum within the query line without having to make a new variable with the sum outside the line beforehand?

 

i.e., something like this is what I am going for (though I know this syntax is wrong)

"SELECT * FROM images WHERE album = $album_id ORDER BY timestamp DESC LIMIT ($upper_limit + 1), 1"

 

Thank you all in advance!

[Daniel0]

"SELECT * FROM images WHERE album = $album_id ORDER BY timestamp DESC LIMIT (" . $upper_limit + 1 . "), 1"

?

[cgm225]

Thank you!

[cgm225]

Where is the topic solved link?

[Daniel0]

The modification has not been reinstalled after the upgrade from 1.1.1 to 1.1.4 of SMF.

[cgm225]

Sorry, that syntax does not seem to be working.  I have::

 

    if ((mysql_num_rows(mysql_query("SELECT * FROM images WHERE album = $album_id ORDER BY filename ASC LIMIT (" . $image + 1 . "), 1"))) > 0) { 
        echo "\t\t\t\t\t\t<a href='http://www.example.com/photos/$album/$nextpage/" . ($image + 1) . "'>Next</a>\n";
    }

 

Any ideas?

[Daniel0]

Other than perhaps removing the parentheses after in the LIMIT There should be nothing wrong with the syntax.

 

"SELECT * FROM images WHERE album = $album_id ORDER BY filename ASC LIMIT " . $image + 1 . ", 1"