RE: [PHP-DB] How to work with temporary tables??
| From: | Rick Emery | Date: | Tue, 06 Nov 2001 22:31:53 +0000 |
| Subject: | RE: [PHP-DB] How to work with temporary tables?? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14080@lists.php.net to get a copy of this message | ||
Are you certain that your CREATE statements are working?
-----Original Message-----
From: Andy [mailto:news.letters@gmx.de]
Sent: Tuesday, November 06, 2001 4:20 PM
To: php-db@lists.php.net
Subject: [PHP-DB] How to work with temporary tables??
Hi there,
I am trying to get a result out of a couple of temporrary tables. I always
get 0. Does anybody have an idea why?
Cheers
Andy
Code:
# test
$stmt_1 =" CREATE TEMPORARY TABLE temp_1
SELECT *
FROM $T5
WHERE country = '$parameters[1]'
";
$stmt_2 =" CREATE TEMPORARY TABLE temp_2
SELECT *
FROM $T5
WHERE language_1 = '$parameters[2]' or
language_2 = '$parameters[2]' or
language_3 = '$parameters[2]'
";
if ( !($result_1 = execute_stmt($stmt_1, $link) )){
HEADER("Location:empty");
}
if ( !($result_2 = execute_stmt($stmt_2, $link) )){
HEADER("Location:empty");
}
$stmt =" SELECT *
FROM temp_1, temp_2
";
if ( !($result = execute_stmt($stmt, $link) )){
HEADER("Location:empty");
}
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net