secoxxx Posted July 18, 2008 Share Posted July 18, 2008 Im sure you have all see the tags on youtube, myspace, and almost every other site out there these days, Where you enter tags separated by commas. my question is. I have a field containing data like so: bob, joe, eric, john, bill, kim, andy, shay all separated with commas. now how in the world do they bring that data to the page, which each name a link, like so bob, joe, eric, john, bill, kim, andy, shay each link being a search type query string on the back end like tag.php?tag=bob, tag.php?tag=joe, tag.php?tag=eric and so on. Any one know what this is called? I am stumped. Thanks Quote Link to comment Share on other sites More sharing options...
marcus Posted July 18, 2008 Share Posted July 18, 2008 You can explode it. <?php $sql = "SELECT tags FROM `videos` WHERE `id`='5'"; $res = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_assoc($res); $tags = explode(",", $row['tags']); foreach($tags AS $tag){ echo "<a href=\"search.php?tag=".trim($tag)."\">".$tag."</a> "; } ?> Quote Link to comment Share on other sites More sharing options...
secoxxx Posted July 18, 2008 Author Share Posted July 18, 2008 Wow, you are the man. Thank you, so this is called "explode". I will remember that. Thank you again Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.