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]
