Hello List.
I have a sql command that counts, groups and sorts data from a table.
I need to insert the results of that sql command into different table.
My sql SELECT looks like this:
select count(*) as count, searchkeywords from searchtable group by
searchkeywords order by count desc;
and returns records like this:
578 green
254 blue
253 red
253 yellow
118 orange
.... etc.
My PHP looks like this so far:
$sql = "select count(*) as count, searchkeywords from searchtable
group by searchkeywords order by count desc";
$result = @mysql_query($sql,$connection) or die("Couldn't execute
checkcat query");
$num = mysql_num_rows($result);
echo $num;
The echo is of course returning the total number of records.... not
data as listed above.
I know a WHILE statement is to be used here, but can't get it to work.
How do I loop through the above found data, inserting each value as
like this:
insert into mytable (count, color) values ("578", "green");
insert into mytable (count, color) values ("254", "blue");
...etc
Thanks,
--Rick
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
