Really very basic question about getting a query output into URL for google cale

[dazzathedrummer]

Ok, I know this is a really simple one, but I haven't done any coding for a couple of month and i'm a bit rusty.

 

I'm trying to add a field from a MySQL query to a Google calendar add button link so I can create a dynamic 'add to calendar' button from my gig list.

 

So on the gig list page that echo's all the dates from the database, I want to add the venue name to the 'text' section of the google URL -

 

<a href=\"http://www.google.com/calendar/event?action=TEMPLATE&text=VENUE HERE&dates=20060101T000000Z/20060101T000000Z&details=gig%20text&location=gig%20town&trp=false&sprop=www.the-guards.co.uk&sprop=name:The%20Guards\" target=\"_blank\"><img src=\"http://www.google.com/calendar/images/ext/gc_button6.gif\" border=0></a>

 

if I echo the field like so -

 

echo"{$row['gl_venue']}";

 

I get the correct result - I just can remember how to embed the php within the html, everything i've tried has failed so far.

 

Once i've got this sorted i can go ahead and add the date, location fields etc.

 

 

[dazzathedrummer]

s'ok - i figured it out!