[PHP-DB] PHP/mySQL and INSERT statements

2001-08-28 Thread Pyran Firebrand
Hello... I'm trying to enter a fair amount of text into a mySQL database from textfiles using PHP. I'm having some problems, and I hope someone can help me. The table looks like this: Name: rants id : int auto_increment date: varchar(8) category: char(1) title : varchar(75)

Re: [PHP-DB] PHP/mySQL and INSERT statements

2001-08-28 Thread Paul Burney
on 8/27/01 11:32 PM, Pyran Firebrand at [EMAIL PROTECTED] wrote: $query = INSERT INTO rants VALUES (1, '$date', '$type', '$title', '$text'); mysql_db_query($query, $db_link) or die (brProblem!); } You should probably be specifying the database before the $query. By the way, use of the

Re: [PHP-DB] PHP/mySQL and INSERT statements

2001-08-28 Thread Jason Wong
- Original Message - From: Pyran Firebrand [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001 2:32 PM Subject: [PHP-DB] PHP/mySQL and INSERT statements Hello... I'm trying to enter a fair amount of text into a mySQL database from textfiles using PHP. I'm having