wright67uk Posted April 10, 2011 Share Posted April 10, 2011 $query = mysql_query("SELECT name FROM business WHERE type ='Restaurant' ORDER BY name"); echo mysql_error(); while($ntx=mysql_fetch_row($query)) $nt[] = $ntx[0]; $i = -1; foreach($nt as $value) { $i++; echo $nt[$i]."<br/>";} Now im trying to swap the last line; echo $nt[$i]."<br/>";} for somthing more like echo "<a href="$nt[$i].html">$nt[$i]</a>";} My syntax seems to be shot to pieces, and i recieve errors. any ideas welcome? The error i receive is "Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' " Many thanks. Quote Link to comment https://forums.phpfreaks.com/topic/233250-syntax-for-including-variables-within-a-href-links/ Share on other sites More sharing options...
php.ajax.coder Posted April 10, 2011 Share Posted April 10, 2011 echo "<a href="$nt[$i].html">$nt[$i]</a>";} Try this... echo "<a href='" . $nt[$i] . ".html'>" . $nt[$i] . "</a>";} Quote Link to comment https://forums.phpfreaks.com/topic/233250-syntax-for-including-variables-within-a-href-links/#findComment-1199572 Share on other sites More sharing options...
wright67uk Posted April 10, 2011 Author Share Posted April 10, 2011 This works really well, thankyou very much for your help. I can see one problem that Ive caused. echo "<a href='" . $nt[$i] . ".html'>" . $nt[$i] . "</a>";} say for example if a result from my database was Fried Chicken, then I would output somthing like; <a href="Fried Chicken.html">Fried Chicken</a> Obviously this would produce a broken link. Is there a way to factor out the space between Fried and Chicken within the link, but to keep the space in the anchor text? Quote Link to comment https://forums.phpfreaks.com/topic/233250-syntax-for-including-variables-within-a-href-links/#findComment-1199580 Share on other sites More sharing options...
php.ajax.coder Posted April 10, 2011 Share Posted April 10, 2011 You could use str_replace to replace the space If I remember it should work like this but you might need to look it up on the manual echo str_replace(' ', '_', $nt[$i]); Quote Link to comment https://forums.phpfreaks.com/topic/233250-syntax-for-including-variables-within-a-href-links/#findComment-1199587 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.