Jump to content


Photo

converting a mysql entry to a text by PHP


  • Please log in to reply
1 reply to this topic

#1 ayucuk

ayucuk
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 03 February 2003 - 11:01 PM

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...

#2 benW

benW
  • Members
  • PipPip
  • Member
  • 12 posts
  • LocationWaukesha WI

Posted 04 February 2003 - 12:54 AM

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/m...n/ref.mysql.php


<?php str_replace("ASP", "PHP", $str); ?>




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users