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. 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>";} 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? 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]); 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
Archived
This topic is now archived and is closed to further replies.