seeking clever php / mySql generic method

2001-06-18 Thread WeAreUs
Hi All! While this is not a huge problem, it is a recurring one so I thought I would see if someone else has a nice generic way of handling this situation. I often set up database tables with a PHP4 interface to handle insertions. It is always set up on a CGI basis, wherein a form blasts variab

advice sought on using a select to extract binary data

2001-03-27 Thread WeAreUs
Hi! I enter some .wav encoded (windows) data into a MySql table as follows: $data = addslashes(fread(fopen($form_data, "r"), filesize($form_data))); $result=MYSQL_QUERY("INSERT INTO b(audio,filename,filesize,filetype,audio_description) ". "VALUES ('$data','$form_data_name','$