Merging keywords with locations

Forum Moderators: open

Message Too Old, No Replies

Merging keywords with locations

Simple tool required

johnser

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

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

jamesa

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

<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>

johnser

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

Thanks James!
Much obliged :)
J

snookie

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

a page full of 500 keyphrases. hmm...

gmoney

9:45 pm on Dec 8, 2003 (gmt 0)

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).

jornada

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

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.

progex

5:14 pm on Jan 1, 2004 (gmt 0)

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