query help

[blanius]

I'm a bit rusty at hand coding a query

What I want to do is select all fields form table 'videos' where cat=1

but I want the an additional field that shows the cat name instead of the id from cat. The field cat in the table videos corresponds to the id field in the category table.

Bret Lanius

http://bretlanius.com

 

[vacunita]

Select cat.videos, categoryname.category FROM videos, category WHERE videos.cat=1 and category.id=videos.cat;

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[blanius]

Thanks, close enough... Fixed it to be
SELECT videos.name, videos.name, category.name
FROM videos, category
WHERE videos.cat =1
AND category.id = videos.cat

and that got me what I needed. I was close before just missed it a bit.

Again thanks.

Bret Lanius

http://bretlanius.com

 

[vacunita]

I inverted the table name for videos.cat. but I'm glad you got what I meant.

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[r937]

why stop with the job half done? you could fix it completely

SELECT videos.name, videos.name, category.name
FROM category
[red]INNER JOIN[/red] videos
[red]ON[/red] videos.cat = category.id
WHERE category.id = 1



r937.com | rudy.ca

 

[blanius]

I'll give that a try thanks...


Bret Lanius

http://bretlanius.com