when I ran this query:
Code: Select all
SELECT * FROM packaging WHERE amin >= 4 AND amax <= 4if I ran this query:
Code: Select all
SELECT * FROM packaging WHERE amin >= 4 OR amax <= 4Is there a better way to write the query.
Moderator: General Moderators
Code: Select all
SELECT * FROM packaging WHERE amin >= 4 AND amax <= 4Code: Select all
SELECT * FROM packaging WHERE amin >= 4 OR amax <= 4Code: Select all
SELECT * FROM packaging WHERE amin >= 4 AND amax <= 4Code: Select all
SELECT * FROM packaging WHERE amin > 3 AND amax < 5Code: Select all
$query = "SELECT * FROM packaging WHERE amin > ".($audio-1)." AND amax < ".($audio+1);
echo $query.'<br>';
$result = query_db($query, '2');
$num_rows = mysql_num_rows($result);
echo $num_rows.'<br>';
for ($i = 0; $i <= $num_rows -1; $i++)
{
$info = mysql_fetch_assoc($result);
echo $infoї'package'].'<br>';
}Code: Select all
SELECT * FROM packaging WHERE 12 BETWEEN amin AND amax