Perl+MySql - few questions

They have: 109 posts

Joined: Apr 1999

Can someone give me a quick example of how to take data from a mysql database, and use it in a perl program?
Say in the table 1 is row (or column,..forgot what heh)
is URL
and one of the entries is http://www.yahoo.com

And how can I add entries into a mysql database?
Say the table only consisted of 1 row called URL

how can I add $url (from my perl program) into the database table?

How can i get
that Url from the database into $url in my perl program?

They have: 5,633 posts

Joined: Jan 1970

dass, i'm sorry about the long waiting, just didn't find the time to come in here..... Sad
since i'm not that confirm with the mysql-format, i will take a closer look about and give you an answer as soon as i can!
but i hope somebody else who's having some more experiences with this knows an answer???
cu
patrick

They have: 109 posts

Joined: Apr 1999

Patrick, no prob about the long wait, it's worth it to hear your perl wisdom Smiling, I think on behalf of everyone, I would LIke to thank you for all the effort you put into making this forum so great!
Thanks!

They have: 2,390 posts

Joined: Nov 1998

I was hoping to get more into CGI/Perl and then be able to help out here - I have recently decided to go the PHP way though, as it seems to be a better option.

Thanks Patrick for putting so much time into this forum, hopefully another perl wizard will find his way over here to help you out! Smiling
JP

----------
The Webmaster Promotion and Resource Center.
http://www.what-next.com

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.