Access 2003: hyperlink in a text field

Joined
Dec 14, 2009
Messages
2
Reaction score
0
Hi

I have a database, which is administered using Access. The data is held in MYSQL tables and i use PHP script on the web pages.

I have a field which is a memo field in Access. I need to include hyperlinks in the text. but when the hyperlinks appear on the web pages, they are just text rather than clickable links.

Does anyone please have any ideas for something i can do to make the hyperlinks appear.

Many thanks

Amina
 

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
This could be due to formatting in Access or the way your PHP script has been coded.

Is the PHP script quite short? If so, you can paste the relevant parts in here and I'll have a look.
 
Joined
Dec 14, 2009
Messages
2
Reaction score
0
Hi Ian, thanks for answering.

I am not sure which bit of the PHP is relevant as it is long. here is an example of what pulls the pre-req field in question from the MYSQL table:
default​
: // retrieve the student courses

$sql = "SELECT courses.CourseName AS name, courses.Description AS description, courses.PublicityShort AS PublicityShort, courses.PreReq AS preReq, courses.Content AS content, courses.WebDetails AS webDetails, schedule.ScheduleID AS ID, schedule.ScheduleDate AS theDate, schedule.ScheduleStart AS startTime, schedule.ScheduleEnd AS endTime, schedule.NoPlaces AS places, venues.Site AS building, venues.Room AS room FROM courses Inner Join schedule ON schedule.CourseID = courses.CourseID Left Join venues ON schedule.VenueID = venues.VenueID WHERE schedule.quickBook = 0 AND schedule.staff = 0 AND schedule.scheduleDate > NOW() AND courses.CourseCat_ID = '{$_SESSION['cat']}' AND schedule.Live = -1 AND schedule.Cancelled = 0 AND schedule.ProgID IS NULL ORDER BY schedule.ScheduleDate";
This is what the MYSQL table looks like in case that's it. It's a memo field in Access.
Field: PreReq
Type: Text
Null: not null
If you know something better that i can send you please just tell me!
Thank you.

 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top