RE: [PHP-DB] SQL problem
| From: | Robert Vukovic | Date: | Fri, 31 Aug 2001 04:38:52 +0000 |
| Subject: | RE: [PHP-DB] SQL problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12017@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. ?
>
I forgot to say that PHP is 4.04 and I am using MySQL