If you have id_categoria in both tables why don't you use join?
Try this:
select nome from categorias inner join categoriamembro
on categorias.id_categoria=categoriamembro.id_categoria
where id_membro=1807
[]s
Anderson Pereira Ataides
Em Qui 06 Fev 2003 00:31, you wrote:
Is this possible
Nuno Lopes
Try this:
SELECT music_id, title, artist_name, country
FROM music_table, artist_table
WHERE music_table.artist_id = artist_table.artist_id
AND country LIKE 'desired country'
Anderson Ataides
Em Sex 03 Jan 2003 07:57, you wrote:
Hi everybody,
I have a question about table
of getting data integrity broken.
Hope I could help.
[]s
Anderson Pereira Ataides
Em Qui 12 Dez 2002 16:09, you wrote:
Hi,
If you have more than one user connected to the database which handled the
same tables, you need to use LOCK/UNLOCK tables.
MySQL daemon don't lock tables or records if you
fast learning, and development, MySQL is your choice.
Want more? I could give you more arguments, but I think this should be enough.
Hope I could help you.
Anderson Pereira Ataides
[EMAIL PROTECTED]
-
Before posting, please check
Why should I close port 3306 used by mysql? What would happen if a hacker use
this port?
Anderson Pereira Ataides
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
You gave the answer. Using left join it will work and give you NULL values
for not found records.
I had a similar problem here and left join worked ok.
Bye,
Anderson Ataides
=
Em Quarta 24 Julho 2002 03:51, you wrote:
Hi
I'm
Are you sure you want to do that?
Since php can call local programs, you can call one to reboot your computer.
I think it's not a good idea to allow it.
Anderson Pereira Ataides
Em Quarta 17 Julho 2002 16:38, you wrote:
Hi mysql list members,
Is it possible to reboot the linux server
Em Ter 16 Jul 2002 18:19, Elby Vaz escreveu:
Hi,
the date format of MySql is /mm/dd (2002/07/16) right?
Wrong. The date format of MySQL is -mm-dd.
How I do to insert the date typing in my form dd/mm/ (16/07/2002)?
It is possible?
You have to format your date to insert into