mysql export problems

[daveh33]

I have a table with a load of numbers in it - I also have a table called STOPS

 

what I am trying to do is display all of the numbers in the list - expect for those in the STOPS list - I have written the below code: -

 

if ($f=="all") {
$result = mysql_query("SELECT DISTINCT(number) FROM $tablename") or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
$number = $row['number'];
$result1 = mysql_query("SELECT DISTINCT(number) FROM STOPS or die(mysql_error());
$row1 = mysql_fetch_array($result1);
$stop = $row1['number'];
if ($number!=$stop) {
echo $number;
echo "<br />";
}

 

The error I get is: -

 

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

 

Any ideas anyone??

[adam291086]

I persume thats all the code. If so you were missing some { } try the code below

if ($f=="all") {
$result = mysql_query("SELECT DISTINCT(number) FROM $tablename") or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
$number = $row['number'];
}
$result1 = mysql_query("SELECT DISTINCT(number) FROM STOPS or die(mysql_error());
while($row1 = mysql_fetch_array($result1)){
$stop = $row1['number'];
}
if ($number!=$stop) {
echo $number;
echo "<br />";
}
}

[daveh33]

Thanks - tried that but it doesn't seem to have had any impact, still get same error message

 

It says the error is on line 19: -

 

$stop = $row1['number'];

[Gamic]

You had a missing quote and end bracket in your second sql query.

 

if ($f=="all") {
$result = mysql_query("SELECT DISTINCT(number) FROM $tablename") or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
$number = $row['number'];
}
$result1 = mysql_query("SELECT DISTINCT(number) FROM STOPS") or die(mysql_error());
while($row1 = mysql_fetch_array($result1)){
$stop = $row1['number'];
}
if ($number!=$stop) {
echo $number;
echo "<br />";
}
}

 

However, I think you are going about this the wrong way. This one query should get all of the information you need.

 

<?php
$sql="select distinct(number) as number 
    from $tablename 
    where number NOT IN (
      select distinct(number) 
      from STOPS
    );";
?>