Jump to content

Archived

This topic is now archived and is closed to further replies.

ayucuk

converting a mysql entry to a text by PHP

Recommended Posts

i have a webpage with mysql .. it contains lyrics .. now lyrics get too big so this makes server to overload sometimes .. my friend having an idea that we can convert these mysql entries to a single txt files \"Artist Name - song name\".. have any script or does anybody know a way to do this ?? i only know simple PHP commands so if you can explain or write a script for me , i will be pleased ...

 

mysql entries like that

id Views pending_reports Track Title Artist Album Year Genre Comment Composer Orig_Artist Copyright URL Encoded_by UploadBy lyric date

 

 

so i want file names as artist - title . and this txt will contain other things like lyrics, year,album

thanks for helps...

Share this post


Link to post
Share on other sites

No MySQL server would crash displaying song lyrics. MySQL could probably hold all the lyrics to all the songs for the past 10 years and still have room for more info! I think your problem goes far beyond any DB probs, your code must be keeping conns open or opening too many. Request what you\'re trying to do more clear and me, or the people here and you get the help you need.

 

http://www.mysql.com/doc/en/

http://www.php.net/manual/en/ref.mysql.php

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.