Re: [PHP] Mining a file for data

2003-03-08 Thread Hugh Danaher
st)."', ...you can fill in the rest yourself) "; $result=mysql_query($query); if (!$result) die ("failed on insert ".mysql_error()); } mysql_close($link); fclose($fp); ?> ----- Original Message - From: "John Wulff" <[EMAIL PROTECTED]> To: <[EMAIL

Re: [PHP] Mining a file for data

2003-03-08 Thread John Wulff
uot;', > '".addslashes($title)."', > '".addslashes($date)."', > '".addslashes($directory)."', > '".addslashes($image)."' )"; > $result=mysql_query($query); >

Re: [PHP] Mining a file for data

2003-03-08 Thread Ernest E Vogelsinger
Dear Hugh, please don't use background colors. Black text on darkblue background is definetely hard to decipher. -- >O Ernest E. Vogelsinger (\)ICQ #13394035 ^ http://www.vogelsinger.at/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://ww

Re: [PHP] Mining a file for data

2003-03-07 Thread Hugh Danaher
'".addslashes($date)."', '".addslashes($directory)."', '".addslashes($image)."' )"; $result=mysql_query($query); if (!$result) die ("couldn't update $table".mysql_error()); } fclose($fp); mysql_cl

[PHP] Mining a file for data

2003-03-07 Thread John Wulff
I'm just learning PHP so please excuse my ignorance. I'm trying to extract the data from a simply formatted text file via a simple PHP script. The goal of this project is to take Magic the Gathering spoiler lists and dump them into a MySQL database. I've got plenty of experience with MySQL but n