I appreciate advice how to do this right.
I am extracting values from one table and then create 2 table out of them in order to compare them (i.e. to overcome sub-query issue).
That is my code:
<?
/ after connection, etc.:
$sql_drop1="
drop table
TEMPTABLE1
";
$result=mysql_query($sql_drop1, $connection) or die ("Could not execute query: Drop table 1.");
$sql_drop2="
drop table
TEMPTABLE2
";
$result=mysql_query($sql_drop2, $connection) or die ("Could not execute query: Drop table 2.");
$sql_create1="
create table
TEMPTABLE1 (LISTING_ID VARCHAR (255) not null )
";
$result=mysql_query($sql_create1, $connection) or die ("Couldn't execute query.");
$sql_create2="
create table
TEMPTABLE2 (LISTING_ID VARCHAR (255) not null )
";
$result=mysql_query($sql_create2, $connection) or die ("Couldn't execute query.");
//PROBLEM HERE:
$sql2001="
select
LISTING_ID
from
REGISTRY
where
WEEK like '%2001'
";
$result=mysql_query($sql2001, $connection) or die ("Could not execute query: $sql2001." .mysql_error());
$row=mysql_fetch_array($result);
for ($i=0; $i< count($row); $i++)
{
$sql_insert_TEMPTABLE1="
insert into TEMPTABLE1 (LISTING_ID)
values
(\"$row\")
";
$result=mysql_query($sql_insert_TEMPTABLE1, $connection) or die ("Couldn't execute query insert TABLE1.");
}
$sql2000="
select
LISTING_ID
from
REGISTRY
where
WEEK like '%2000'
";
$result=mysql_query($sql2000, $connection) or die ("Could not execute query: $sql2000." .mysql_error());
$row=mysql_fetch_array($result);
for ($i=0; $i< count($row); $i++)
{
$sql_insert_TEMPTABLE2="
insert into TEMPTABLE2 (LISTING_ID)
values
(\"$row\")
";
$result=mysql_query($sql_insert_TEMPTABLE2, $connection) or die ("Couldn't execute query insert TABLE2.");
}
?>
The result: I have "Array" written twice in each of the tables.
Where am I wrong???
