help :( before i break my laptop :D

[bamfon]

my code is this

 

SELECT * FROM  episodea, episodeb WHERE episodea.animeid = '1' OR episodeb.animeid = '1' 

 

i want the code to check the the to tables to get the data from the row's thats got animeid "1" but it keep showing  data from the row thats got 2 as its animeid :s

[mikosiko]

how both tables are related to each other?.... that select is doing a Cartesian product

[bamfon]

well animeid has to be saved in table episodea or table episodeb  set it up that wau because latter on the tables will have a few million rows, so i made 2 forms one saves info to episodea the other to episodeb, both of the tables will never have the same animeid.

[mikosiko]

seems that you didn't understand my answer... lets try with an example:

 

Table A

id_a

 

Table B

id_b

 

Rows Values in Table A

1

2

 

Rows Values in Table B

1

2

 

CARTESIAN PRODUCT between Table A and Table B (result from a SELECT  like yours)

1 - 1

1 - 2

2 - 1

2 - 2

 

applying your conditions

WHERE episodea.animeid = '1' OR episodeb.animeid = '1' 

 

Final result

Rows 1 - 1 and 2 - 1

 

more clear?

 

[bamfon]

Final result show all the rows with id1 and id2

[mikosiko]

in addition to what was already explained check what data type is animeid .... number?

[bamfon]

data type  int(11)

[mikosiko]

WHERE episodea.animeid = '1' OR episodeb.animeid = '1'

 

and why then are you using strings here?

[bamfon]

what should I be using?

[mikosiko]

if you data type is INT(11) ideally you should be using numbers no '1'... and to fix an omission in my previous answer...

 

......

CARTESIAN PRODUCT between Table A and Table B (result from a SELECT  like yours)

1 - 1

1 - 2

2 - 1

2 - 2

 

applying your conditions

WHERE episodea.animeid = '1' OR episodeb.animeid = '1'

 

 

Final result

Rows 1 - 1 and 2 - 1

 

in reality the final result is

Rows 1 - 1, 1 - 2 and 2 - 1

[bamfon]

fixed it by using

 

SELECT * FROM episodea WHERE animeid = '1'
UNION ALL
SELECT * FROM episodeb WHERE animeid = '1'