That is the strange thing, there are no error messages. I simply don't
get short_desc with
list($image,$desc)=mysql_fetch_row($res1);
$desc is empty.
I will try your query.
> -----Original Message-----
> From: Dobromir Velev [mailto:[EMAIL PROTECTED]]
> Sent: petak 31. avgust 2001. 10:04
> To: Robert Vukovic; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] SQL problem
>
>
> 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]