-Patrick wrote:
$query_rsComments = sprintf("SELECT id_com WHERE idart_com=%s ORDER BY
date_com ASC", $KTColParam1_rsComments);
No FROM clause. Also, don't you need single quotes around %s?
PB
-
can anyone see what Im trying to do here? basically, I want to match the
id_com with an id
Philippe Poelvoorde wrote:
> 2006/4/25, -Patrick <[EMAIL PROTECTED]>:
>
>> $query_rsComments = sprintf("SELECT id_com WHERE idart_com=%s ORDER BY
>> date_com ASC", $KTColParam1_rsComments);
>>
>>
>> can anyone see what Im trying to do here? basically, I want to match the
>> id_com with an idart_
2006/4/25, -Patrick <[EMAIL PROTECTED]>:
> $query_rsComments = sprintf("SELECT id_com WHERE idart_com=%s ORDER BY
> date_com ASC", $KTColParam1_rsComments);
>
>
> can anyone see what Im trying to do here? basically, I want to match the
> id_com with an idart_com to produce a value and report back t
$query_rsComments = sprintf("SELECT id_com WHERE idart_com=%s ORDER BY
date_com ASC", $KTColParam1_rsComments);
can anyone see what Im trying to do here? basically, I want to match the
id_com with an idart_com to produce a value and report back through the
other chunk of code already given to out
Daniel da Veiga wrote:
> On 4/25/06, -Patrick <[EMAIL PROTECTED]> wrote:
>
>> Hi Folks,
>> Here is the table for the articles:
>>
>> CREATE TABLE `blg_article_art` (
>> `id_art` int(11) NOT NULL auto_increment,
>> `idtop_art` int(11) NOT NULL default '0',
>> `title_art` varchar(100) NOT NU
On 4/25/06, -Patrick <[EMAIL PROTECTED]> wrote:
> Hi Folks,
> Here is the table for the articles:
>
> CREATE TABLE `blg_article_art` (
> `id_art` int(11) NOT NULL auto_increment,
> `idtop_art` int(11) NOT NULL default '0',
> `title_art` varchar(100) NOT NULL default '',
> `description_art`
Sorry about that..
$totalrows_rsComments gives a value of 0. But no matter what I do I
can't seem to alter it. It stays at zero.
-Patrick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Patrick schrieb:
Hi Folks,
Here is the table for the articles:
CREATE TABLE `blg_article_art` (
`id_art` int(11) NOT NULL auto_increment,
`idtop_art` int(11) NOT NULL default '0',
`title_art` varchar(100) NOT NULL default '',
`description_art` blob NOT NULL,
`text_art` longtext NOT NU
Hi Folks,
Here is the table for the articles:
CREATE TABLE `blg_article_art` (
`id_art` int(11) NOT NULL auto_increment,
`idtop_art` int(11) NOT NULL default '0',
`title_art` varchar(100) NOT NULL default '',
`description_art` blob NOT NULL,
`text_art` longtext NOT NULL,
`date_art` dat