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

Dobromir Velev

-----Original Message-----
From: Robert Vukovic <[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`)
>> 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]

Reply via email to