Just hoping someone could point out how to do this: Users can either insert a link to audio or upload audio. Rather than have 2 separate fields in my mysql table (that would lead to more probs) I want to insert depending on which form field has been entered.
ie if I upload the audio, then php inserts the file extension or if I link the audio, php does the same.
I know below is wrong but you can see what I mean. Would a conditional statement do the trick?
mysql_query("INSERT INTO $table (show_id, date, dj, author, description, file, file, visible) VALUES ('$show', '$date', '$dj', '$author', '$description', '$file', '$query', '$visible')");