[RESOLVED] Selecting data from MySQL between a range

[kiwibrit]

This line is giving no error message - but wen run in a file it results in a blank screen.

$result = mysqli_query($link,"SELECT * FROM pageref WEHRE pagerefno BETWEEN $leastinterestref AND $maxpageref");

$leastinterestref and $maxpageref are both integers within the range of pagerefno.

What have I done wrong?

php5 in use.

[alimadzi]

WEHRE should probably be changed to WHERE... 😉

[kiwibrit]

Ouch. As bad, the ';' should not have been there - it was followed by

or die ("Error in query: $query. " . mysqli_error());

Moral: don't work late at night when you are dog tired.

Thanks for your help.

[alimadzi]

No worries. We've all been there... 😉