Renegade — Wed, 16 Mar 2005 08:57:44 +0000

rayzun wrote:
list($first) = explode('/', substr($PATH_INFO,1));
$query = "SELECT *
FROM `makes-model`
WHERE `line` LIKE '$first'

ORDER BY RAND() LIMIT 4";

$result = mysql_query($query);
$number = mysql_numrows($result);
{
for ($i=0; $i<$number; $i++) {
$make=mysql_result($result,$i,"make");
$model=mysql_result($result,$i,"model");
$line=mysql_result($result,$i,"line");
echo "$model";
}}

I don't see where those came from...

timjpriebe — Wed, 16 Mar 2005 02:08:11 +0000

Can you not just use an equal sign instead of NOT? (And, of course, remove the single quotes.)