Re: [PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread Jeroen Timmers
Hello, something that you can help is the follow try var_dump($newquery); then you see the complete query and run it in phpmyadmin. Jeroen - Original Message - From: Jonathan Underfoot [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 08, 2002 2:43 PM Subject: [PHP-DB]

RE: [PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread Rick Emery
Yes, you can re-select from the same database without opeing a new connection. I recommend that you print the contents od $newquery to verify it contains the string you think it should. Perhaps the apostrophes you've enclosed the $row[] variable are not expanding. -Original Message-

Re: [PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread DL Neil
Jonathan, I'm trying to write a script that checks for multiple entries on a table in a database. So far I've been plagued by MySQL errors. I'm fairly confident my scripting is ok (Then again, I've been wrong before.) I think moreover there might be some difficulty with my theory. Then

Re: [PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread Jonathan Underfoot
What does bool(false) mean? Thats off the vardump -J - Original Message - From: Jeroen Timmers [EMAIL PROTECTED] To: Jonathan Underfoot [EMAIL PROTECTED] Cc: [PHP-DB] [EMAIL PROTECTED] Sent: Friday, February 08, 2002 8:58 AM Subject: Re: [PHP-DB] MySQL / PHP Database Help Hello

RE: [PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread Rick Emery
, February 08, 2002 8:48 AM To: Jeroen Timmers Cc: [PHP-DB] Subject: Re: [PHP-DB] MySQL / PHP Database Help What does bool(false) mean? Thats off the vardump -J - Original Message - From: Jeroen Timmers [EMAIL PROTECTED] To: Jonathan Underfoot [EMAIL PROTECTED] Cc: [PHP-DB] [EMAIL PROTECTED

Re: [PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread Jeroen Timmers
PROTECTED] Sent: Friday, February 08, 2002 3:47 PM Subject: Re: [PHP-DB] MySQL / PHP Database Help What does bool(false) mean? Thats off the vardump -J - Original Message - From: Jeroen Timmers [EMAIL PROTECTED] To: Jonathan Underfoot [EMAIL PROTECTED] Cc: [PHP-DB] [EMAIL PROTECTED

Re: [PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread DL Neil
Jonathan, [have put the cc back to the list] Is it possible to make BOTH the date and venue into a single unique index? =Why not? Like a good woman, treat her right, and SQL will do almost anything for you: 6.5.3 CREATE TABLE Syntax CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name