[RESOLVED] Redirect Question

Static_Cling

So I have a dynamic page that will list a number of courses based upon the Users session (username) and query that uses that session...my question is what is the easiest way to have each item in this list be linked to another page so when the user will click on the link it takes them there automatically...I have a column in my table structure that lists where each of these courses are located (html pages) but the list will be different for each user based upon what assignments they have...user1 may have courses 1, 2, 3 and but user 2 may have courses 1, 7.9...and I want them to just click on the course link to bring them there....thanks in advance

Static_Cling

any thought's on this...am I being clear enough in what I am trying to do? If not, let me know and I'll try to explain better...thanks

topsub

if you use a sql database you can just pull all the info from there, Use a linking table to match the courses to the users.

so link user1 to course 1,2,4 and user2 to course 2,4,5

if you set up your site correctly you can do links like

www.yourdomain.com/course/1
www.yourdomain.com/course/4 <-- just have the number be variable

Static_Cling

ok, think I'm lost...let me start again...so i have a page that when a user logs in will display the courses he needs to take. So user1 could have different courses to take then user2. On this page, this course taken info is got from a mySql db and the query pulls the coursename to the page...

so page would look like this:

username: User1

Course to Take:
Course1
Course2
Course5

Those courses are echoed to the page....

now within the database in the courses table, there is a field that has the html link/info of where the course is. What I want to do is have each course basically come out on the page as a link (but using the table location info) so when a user clicks on the link, it takes them to that page....I know how to do this in ASP, but can't figure it out for php...

Thanks

topsub

i don't understand what you are trying to do.

what is it for asp because then i can tell you how to do it in php.

i mean to create a link in html is... well i am sure you know how to do that but i dont' understand what your not getting

Static_Cling

Ok, course table is laid out like this:

CourseName CourseLocation
Course1 www.yourdomain.com/course1/index.htm
Course2 www.yourdomain.com/course2.index.htm

On the page for users after the user logs in, it will list the course assignments (sepearte table)....I want that Coursename to be a link to the Course Location:

So here is my echo statment in my table:

echo $row_Recordset2['coursename'];

I want ['coursename'] to link to the course location

maxpup979

Assuming that you also have a specific course link that stores the proper URL for each course name, you could just do something like:

print "<a href=\"".$row_Recordset2['courselink']."\">".$row_Recordset2['coursename']."</a>";

topsub

a basic link, thats html

topsub

and or

echo "<a href='".$row_Recordset2['courselink']."'>".$row_Recordset2['courselink']."</a>"

Static_Cling

Thanks so much for the help, its working exactly the way I need it too...

Static_Cling

sorry, one last question, if I want this to open to another window using javascript, can that be done? I don't know javascript at all, someone wrote me the script and I'm trying to get it called, but it just wont open the page now...here is my new code:

<?php echo "<a href= javascript:popUp('".$row_Recordset2['exefield']."')>".$row_Recordset2['coursename']."</a>" ?>