Expand Var in a field of a record

[HawkCode]

Hi

 

I need to put in a url like this

 

http://test.com/events/[email protected]&fname=Richard&lname=Albrecht&Member+Number=999999

 

Getting the URL form one table and when expanded gets the data from another table. I created a form to input the url, here is what I put in the field:

 

http://test.com/events/tokenPasser.jsp?email={$row_Recordset['EMail']}&fname={$row_Recordset['FName']}&lname={$row_Recordset['LName']}&Member+Number={$row_Recordset['MemberNumber']}

 

Here is the code

 

$GoToURL = $row_Sysdefaults['HostingURL'];

echo $GoToURL;

 

It does not expand the vars?

 

Is this possible.

 

TIA

 

Rich

[trq]

Your question makes little sense. Your using .jsp files, this is a php board.

[trq]

Do you mean your actually storing variable names in the database not there values? You'll need to look at eval be fare warned however, this is not a safe option.

[HawkCode]

This is not JSP, the link I have to send people to is JSP.

 

Yes I'm storing Vars in the database. I will look at the EVAL.

 

Thanks

 

 

Rich

[HawkCode]

I'm still not getting this to work.

 

I need to direct the user to the web site that gets created by the string stored in the database. The data base has all our webinars and based on the webinars number is will pull a differant url to be built.

 

I'm trying to do this so I don't have to hand modify code for each webinar title. This is the registration system.

 

 

$GoToUrl is set from a Session Var

 

$GoToURL = $_SESSION['GoToURL'];

 

And the session var is set 2 pages earlier like this:

 

$_SESSION['GoToURL'] = $row_Sysdefaults['HostingURL'];

 

 

This is the way the code will be used:

 

 

if ($ResponseCode == "Approved"):{

 

header(sPrintf("Location: %s", $GoToURL  ));

} endif;

 

 

I hope this helps.

 

Rich

[HawkCode]

Figured it out.

 

Thanks

 

 

Rich