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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to