Saabeirik
04-26-2013, 12:57 AM
Hi!
I've made a large Excel-sheet with information. I'm going to convert it to CSV, and import it to a MySQL-database for display in my Joomla-site.
I want to make a new column with "hyperlink code". I'm not sure how the code should look like, so that it will be interpreted as a hyperlink. It will probably be some sort of PHP-code.
To the point!
I want to populate each row with a PHP-code, related to another column in the same row:
Example:
Fruit__________Price___________________________Link
Bananas_________$3___________________________ www,fruiters,com/samples/bananas.jpg
Oranges_________$7___________________________ www,fruiters,com/samples/Oranges.jpg
Is there an easy way to populate the LINK column with URLs related to the Fruit column? I'm hoping you understand what I mean, and I can probably apply the principle to my needs if given some help :) If there's an easier way without VBA I'm of course interested in that too.
Thanks in advance for your time!
I've made a large Excel-sheet with information. I'm going to convert it to CSV, and import it to a MySQL-database for display in my Joomla-site.
I want to make a new column with "hyperlink code". I'm not sure how the code should look like, so that it will be interpreted as a hyperlink. It will probably be some sort of PHP-code.
To the point!
I want to populate each row with a PHP-code, related to another column in the same row:
Example:
Fruit__________Price___________________________Link
Bananas_________$3___________________________ www,fruiters,com/samples/bananas.jpg
Oranges_________$7___________________________ www,fruiters,com/samples/Oranges.jpg
Is there an easy way to populate the LINK column with URLs related to the Fruit column? I'm hoping you understand what I mean, and I can probably apply the principle to my needs if given some help :) If there's an easier way without VBA I'm of course interested in that too.
Thanks in advance for your time!