Welcome to WebmasterWorld Guest from 54.166.87.123

Forum Moderators: open

Message Too Old, No Replies

Merging keywords with locations

Simple tool required

   
11:52 pm on Nov 19, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



If I was good at Macros I could sort this....
10 keywords x 50 countries = 500 KWs

Whats a simple tool that allows you to put in the 10 KWs, then the 50 countries & it merges them effectively?

I saw one such app a few weeks ago but can't remembr what it was?

Thanks
J

9:03 am on Nov 27, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



<html><body> 
<?php
// very simple in PHP. Quicker to give you the code than explain it

$keywords = array(
"keyword1",
"keyword2",
"keyword3",
"keyword4"// no comma here
);

$countries = array(
"keyword1",
"keyword2",
"keyword3",
"keyword4"// no comma here
);

foreach ($keyword as $kw) {
foreach ($country as $c) {
echo "$kw $c<br>\n";
}
}

?>
</body></html>

11:38 am on Nov 28, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Thanks James!
Much obliged :)
J
11:43 am on Nov 28, 2003 (gmt 0)

10+ Year Member



a page full of 500 keyphrases. hmm...
9:45 pm on Dec 8, 2003 (gmt 0)

10+ Year Member



In case someone likes Excel (no macros required):

If you put the "countries" in a column (i.e. cells A2 through A51) and put the "keywords" in a row (i.e. cells B1 through K1) and then in cell B2 you put =CONCATENATE(B$1," ",$A2) and then copy cell B2 and paste it into the big grid (i.e. B2 through K51).

5:23 pm on Dec 30, 2003 (gmt 0)

10+ Year Member



The excel tip above is very helpful. Do you happen to have any other tips or tools (or know of whre I can find any) using excel to make expansive keyword lists quickly. I created one that I would be happy to share. It basically creates titles with captial letters.
5:14 pm on Jan 1, 2004 (gmt 0)

10+ Year Member



I tried that PHP script on my server, however, I get this error message:

Warning: Invalid argument supplied for foreach() in /home/concord/public_html/kw.php on line 16