Part of a url contains data from a MySQL field... possible?

[mattc_uk]

Is is possible to write php code whereby it will contain a url but part of the url address is extracted from a MySQL database field? What would be the right coding for this?

 

i.e.

 
print "<a href=\"http://www.mysite.com/....  ['database field name']... /more of url address\"</a>"

 

 

[DanielHardy]

echo '"www.google.com/".$your_field_from_database."therestofyoururl.com"';

[Jessica]

echo '"www.google.com/".$your_field_from_database."therestofyoururl.com"';

Because you have single quotes around the whole thing, that won't work.

 

echo "www.google.com/{$your_field_from_database}therestofyoururl.com"

 

Would work and remove the concatenation.

Or use single quotes and concat.

 

 

OP, if you're stuck post actual code.

[DanielHardy]

 

Because you have single quotes around the whole thing, that won't work.

 

echo "www.google.com/{$your_field_from_database}therestofyoururl.com"

 

Would work and remove the concatenation.

Or use single quotes and concat.

 

Oops, right you are. Simply remove the single quotes so it becomes:

 

echo "www.google.com/".$your_field_from_database."therestofyoururl.com";

 

Or use jesirose' solution.

 

So you actually know a little about what is going on here, concatenation involves printing one or more strings when they have other things inbetween them. The concatenation operator is the " . " dot simple you see above, which basically means "and".