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]
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-
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
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
, 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
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
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