SELECT * FROM emails WHERE emails_id = $start to $end

[brown2005]

how do you write the subject in the correct php.

 

thanks

[JonnoTheDev]

<?php
$result = mysql_query("SELECT * FROM emails WHERE emails_id >= '".$start."' AND emails_id <= '".$end."'");
?>

[Maq]

Alternatively, you can use BETWEEN.  Also, if you are placing this query into a string with double quotes, variables will be interpolated.  ie:

 

$query = "SELECT * FROM emails WHERE emails_id BETWEEN $start AND $end";