mySQL syntax problems

TeKBuzz · 03-07-2005, 02:13 PM

Ok, I haven't done mysql in a while and someone will yell at me for not realizing why this is wrong but...

Code:

SELECT * FROM 
games AS g, 
game_types AS gt, 
publishers AS p, 
developers AS d
WHERE 
g.id_game =1, 
g.pub_id = p.id_pub, 
g.dev_id = d.id_dev, 
g.type_id = gt.id_type

Anyone know why that doesn't work?

gorillaboy · 03-07-2005, 02:22 PM

Quote:

Originally Posted by TeKBuzz

Ok, I haven't done mysql in a while and someone will yell at me for not realizing why this is wrong but...

Code:

SELECT * FROM 
games AS g, 
game_types AS gt, 
publishers AS p, 
developers AS d
WHERE 
g.id_game =1, 
g.pub_id = p.id_pub, 
g.dev_id = d.id_dev, 
g.type_id = gt.id_type

Anyone know why that doesn't work?

Don't you need a semi colon? ;

TeKBuzz · 03-07-2005, 02:23 PM

Where would I be putting a semi-colon?

Thermit · 03-07-2005, 02:26 PM

I usually put AND's between my WHERE clause expressions...

WHERE g.id_game=1 AND g.pub_id=p.id_pub AND ...

TeKBuzz · 03-07-2005, 02:28 PM

O_O Thanx Thermit! That was my problem...

gorillaboy · 03-07-2005, 02:32 PM

Actually, you left out "And" between your clauses.