[PHP-DB] SQL problem From: Robert Vukovic (vrobert <email protected>)
Date: 08/31/01

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. ? 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>