Using Vars in DB Queries.

[Anon]

Hey, I'm trying to use vars in DB queries like

$result = mysqlquery("SELECT FROM privatemessages LIMIT $min,$max", $db);

This might not be exact query, I thought it up as an example. Anyway I'm trying to use $min and $max as the minimum and the maximum records to get in a limit, but for some reason my version of php (4.1.0 I think) accepts this fine, but the real server (4.0.6 I think) gives invalid result resource. Any way to use var's in the older version without updating to new version?

[Anon]

Try putting single quotes around the variable names.

[[deleted]]

never quote values in SQL unless there is areason for it, and there is no reason in the limit statement.

Instead, try printing the failing query, I think you'll find that there is simple one or two vars missing entirely.