Entering result data into new table?

[Anon]

While I am outputting result data from a query into an html table i am also inserting it into a new temporary table...however, for some reason only every other row is being entered any thoughts???

• Joe

[amcgrath]

Can u paste your code so we can get a better idea as to the solituion?

[Anon]

for some reason it only enters evry other result into the new table.

$query1 = "SELECT * FROM Gr1 WHERE (Last LIKE '%$TheName%' AND BudgetStatus LIKE '%$BStat%') ORDER BY BudgetStatus";
$result1 = mysql_query ($query1)
or die ("Name Query failed");

while($line = mysql_fetch_array($result1)){

$First1 = $line["First"];
$Last1 = $line["Last"];
$Purpose1 = $line["Purpose"];
$Sponsor1 = $line["Sponsor"];

$queryq = "INSERT INTO temp1 VALUES( '$Last1', '$First1', '$Purpose1', '$Sponsor1' )";

$resultr = MYSQL_QUERY($queryq);

}

...help me...

• Crazy

[amcgrath]

Joe,

I don't know what to tell ya, your code looks right (except I would probably list the columns in the select, doing it the way you are could cause problems if you ever alter the table, learned that from experience)... let me know what it finally turns out to be.