SQL problem
| From: | Robert Vukovic | Date: | Fri, 31 Aug 2001 04:33:47 +0000 |
| Subject: | SQL problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12016@lists.php.net to get a copy of this message | ||
Table was created with this
CREATE TABLE
descriptions (
id_property bigint(20) NOT NULL default '0',
short_desc varchar(255) default NULL,
long_desc text,
KEY id_property(id_property),
PRIMARY KEY (id_property),
UNIQUE KEY id_property_2(id_property)
) TYPE=MyISAM COMMENT='';
and this is query:
$res1=mysql_query("SELECT
$tbl_virtual.thumb1,$tbl_descriptions.short_desc FROM
$tbl_virtual,$tbl_descriptions WHERE $tbl_virtual.id_property=$link and
$tbl_descriptions.id_property=$link")
virtual is another table with picture names.
This query work at my home but not on real site. What is a problem. ?