Check for statement - MySQL

[The87Boy]

If I have a MySQL-query that seems like this:
SELECT `dom`.`id`, `sam`.`id`, `fld`.`id` FROM `dom`, `fld`, `sam`
WHERE `dom`.`id`='1', `sam`.`id`='6', `fld`.`id`='4';

Can I then count, if there is 3 returning values, or does anybody have
a better idea to check, if there are 3 returning values?

[The87Boy]

If I have a MySQL-query that seems like this:
SELECT `dom`.`id`, `sam`.`id`, `fld`.`id` FROM `dom`, `fld`, `sam`
WHERE `dom`.`id`='1', `sam`.`id`='6', `fld`.`id`='4';

Can I then count, if there is 3 returning values, or does anybody have
a better idea to check, if there are 3 returning values?

[Gordon]

>If I have a MySQL-query that seems like this: 

This query is wierd. You're doing a 3-way join with no relationship
between the tables?
 

What interface are you using to submit queries (C, PHP, the mysql
command-line utility, ODBC)?

mysql_num_rows() (C, PHP interfaces) will tell you how many rows
you got back. I don't see how you can possibly not get 3 values
back in each row assuming you get rows back at all. NULL is a
value. If you need to tell whether you got a NULL, that depends
on the interface.

[The87Boy]

On 3 Mar., 18:54, org (Gordon Burditt) wrote: 
>
> This query is wierd. You're doing a 3-way join with no relationship
> between the tables?[/ref]

What do you mean with relationship between tables?
 
>
> What interface are you using to submit queries (C, PHP, the mysql
> command-line utility, ODBC)?
>
> mysql_num_rows() (C, PHP interfaces) will tell you how many rows
> you got back. I don't see how you can possibly not get 3 values
> back in each row assuming you get rows back at all. NULL is a
> value. If you need to tell whether you got a NULL, that depends
> on the interface.[/ref]

It is on command-line
NULL and an empty row should count

[The87Boy]

On 4 Mar., 21:22, "The87Boy" <com> wrote: [/ref]
> 
>
> What do you mean with relationship between tables?
> [/ref]
> 
> 
>
> It is on command-line
> NULL and an empty row should count[/ref]

Oh, I mean shouldn't count as rows