Hi Eric

What you need to do is make another PHP page, maybe info.php, which will fetch the info field from the DB and display it.

So for example, assuming the eventname field is unique, you could make the info like something like:

<a href="info.php?eventname=<?=urlencode($eventname)?>">information</a>

And then make info.php fetch the info field from the DB, for example if you were using MySQL:

// page header HTML here
<?
$row = mysql_fetch_assoc(mysql_query("SELECT info FROM table WHERE eventname='{$_GET['eventname']}'"));
$info = $row['info'];
print(nl2br($info));
?>
// page footer HTML here


Obviously you will need to change that to suit your site, and you may want to add some security to the $_GET variable being passed to the MySQL server to prevent attacks. Other than that, hope this helps.

Regards

Jasper Bryant-Greene
Cabbage Promotions
http://fatalnetwork.com/
[EMAIL PROTECTED]


Eric Holmstrom wrote:


Hi there,

I have this.
Table Name = events
Fields = eventname, date, info. Example

-------------------------------
             EVENTS
-------------------------------
eventname |   date    |  info
------------------------------
event1       |   0202  | info here
------------------------------
event2      |   0303  | info here 2

The problem is that the field "info" has alot of text in it. When I print
this out in an array it makes a huge page due to each event having alot of
information. So im trying to make it so it will display the results like
this.

event1    0202    infomation
event2    0303    infomation

I want the word "infomation" to be hyperlinked, so if you click on it, it
will display the information in the "info" field. The problem is I don't
know how to make a hyperlink that grabs the correct infomation for each
event.

Any help at all will be very grateful for.

Thankyou

Eric Holmstrom

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to