[PHP]Confusing Question

[dawizman]

OK, first I'll post a part of the script I am writing:

include("./data/db_info.php");
mysql_connect($host, $user, $pass);
mysql_select_db($db);
$processor = mysql_query("SELECT * FROM processor WHERE processor.platform = '$platform' ORDER BY name ASC");
$processor_no_display= "blah blah blah"
while ($row = mysql_fetcharray($processor) && $row['field'] <> $processor_no_display)
{
echo $row['field'] \n;
}

Now my question is, would that show all the values of $row['field] minus the one that has the same value as $processor_no_display or would that just display nothing at all?

 

[hohoho]

firstoff, it's mysql_fetch_array

i don't think it will work because you should use != ( not equal ) and not <> ( mysql syntax )

and here's another way ( via mysql query )

include("./data/db_info.php");
mysql_connect($host, $user, $pass);
mysql_select_db($db);
$processor_no_display= "blah blah blah";
$processor = mysql_query("SELECT * FROM processor WHERE processor.platform = '$platform' AND field<>'$processor_no_display' ORDER BY name ASC");
while ($row = mysql_fetch_array($processor))
{
echo $row['field']."\n";
}

 

[dawizman]

Thanks, but I would rather have the query grab all the columns and just not display the ones that have the same value as $processor_no_display. Anyway, the nice people at [H]ardforums helped me out to get this:

include("./data/db_info.php");
mysql_connect($host, $user, $pass);
mysql_select_db($db);
$processor = mysql_query("SELECT * FROM processor WHERE processor.platform = '$platform' ORDER BY name ASC");
$processor_no_display= "blah blah blah";
while ($row = mysql_fetch_array($processor) )
{
  if( $row['field'] <> $processor_no_display ) {
    echo $row['field'];
  }
}