hyperlink on mysql

[stream]

is there any way that mysql store data type of hyperlink? (just like msAccess2003 having this facility).

if not possible, how to display mysql result in hyperlink look? (using php on web), so it is clickable to url/ftp address.

please kindly help, n thank you again

[alex-party]

Hi stream,
MySQL has pre-defined data types and for better performance, usually specify data length, like:

CREATE TABLE LINKS(
lid int(5) NOT NULL default '0',
url varchar(255),
PRIMARY KEY (`lid`)
);

See, varchar(255), that is where you store the link name and "lid" is the link id. Where (255) - is the maximum allowed characters in this field.

To display a result from mysql as a link, you could use php and wrap the result in the way as:

echo "< ahref='".$url_from_database_here."'>some link name</a>";

Hope this helps a little

Regards,

[stream]

hi again alex, big thanks!

your reply is helpful verymuch. so how's midi creation going? hope u njoying
don't know if u r mucisian too. g'luck n see ya around!

[alex-party]

Hi stream, you're always welcome
I been away for couple weeks working in Dublin, dropped my music for a while, but I'll pick it up again when get a free minute.
I did not know you play too What instruments do you play?

Warm regards,

[stream]

hi alex, sorry for late reply. i've been away for my boaring office work.. I used to play guitar when in high school, but since then, I didn't touch guitar 4 long time. now with my little project on music tab, I hope I could spend more times on guitar play. so how's work in dublin going? g'luck....!

[alex-party]

Hi stream,
Oh those school times, have lots of good memories

I have a guitar too and axiom-49 midi controller, but I prefer keyboard, because my fingers can't get used to guitar strings.

Thank you, my project was ok, I had just landed in another country - Lithuania, this is my home, I'm on holidays, took 1 month off.
Why do you say that your work is boring? What do you do, if that's not a secret?

[stream]

hi again, n... home sweet home for u.
im kind of person who enjoys atmosphere of east european culture, u know. i got used to it during my 1 year work in Uzbekistan (former USSR) in 2005. there i learnt a bit russian languange, russian cold soup, russian genuine vodka, n had a ride with Volda (if not mistaken) - that is like russian mercy car anyway, people there is also good. perhaps someday i can go to visit the legendary Dracula home in transvelnia, is it closed to lithuania? i like vlad dracula since kid, he's horror but not scary though

since 2006, i backed to bali for work in finance area. u know it's kind of counting money without even holding it in my hand, have to make them balanced in such a way every end of month. i like it, but sometime get boared.

btw, if u have time, would u review my site. i sent such thread yesterday in web review forum. thank u and happy holiday....

[basdotnet]

Hi stream,alex

[dongarcia]

Originally Posted by stream

hi again, n... home sweet home for u.
im kind of person who enjoys atmosphere of east european culture, u know. i got used to it during my 1 year work in Uzbekistan (former USSR) in 2005. there i learnt a bit russian languange, russian cold soup, russian genuine vodka, n had a ride with Volda (if not mistaken) - that is like russian mercy car anyway, people there is also good. perhaps someday i can go to visit the legendary Dracula home in transvelnia, is it closed to lithuania? i like vlad dracula since kid, he's horror but not scary though

since 2006, i backed to bali for work in finance area. u know it's kind of counting money without even holding it in my hand, have to make them balanced in such a way every end of month. i like it, but sometime get boared.

btw, if u have time, would u review my site. i sent such thread yesterday in web review forum. thank u and happy holiday....

What is a VOLDA? We have the same in common...I like VLAD Dracula too...

PLaying Video Games check this out for new Video Games to be Release: