cedtech23
08-22-2004, 01:07 AM
I decided to create a directory on my server to store the mp3 files instead and then to store the files path in the mysql
so I would first create the table like this
$sql = CREATE TABLE mp3_files (
id int NOT NULL AUTO_INCREMENT Primary Key,
Song Name VARCHAR,
Artist Artist VARCHAR ,
Release_Date date,
Additional Notes VARCHAR,
Path ?? );
where "Path" would it me VARCHAR type?? and how would I store the absolute path of the file using PHP
Lets say I had a folder called MP3_Files on my server that would contain all my mp3 files and I uploaded an mp3 song called big poppa? How would I store this location so that when I go to retrieve this file it know the exact one?? :eek:
so I would first create the table like this
$sql = CREATE TABLE mp3_files (
id int NOT NULL AUTO_INCREMENT Primary Key,
Song Name VARCHAR,
Artist Artist VARCHAR ,
Release_Date date,
Additional Notes VARCHAR,
Path ?? );
where "Path" would it me VARCHAR type?? and how would I store the absolute path of the file using PHP
Lets say I had a folder called MP3_Files on my server that would contain all my mp3 files and I uploaded an mp3 song called big poppa? How would I store this location so that when I go to retrieve this file it know the exact one?? :eek: