Hi,
Are there any error messages?
Just a guess - may be this will work
Select $tbl_virtual.thumb1,$tbl_descriptions.short_desc FROM $tbl_virtual
left join $tbl_descriptions on
$tbl_virtual.id_property=$tbl_descriptions.id_property WHERE
$tbl_virtual.id_property=$link
Dobromir Velev
-----Original Message-----
From: Robert Vukovic <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, August 31, 2001 7:34 AM
Subject: RE: [PHP-DB] SQL problem
>> 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
>
>
>--
>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]
>
>
--
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]
