linking tables

[bamfon]

<?php 

$con = database_connect();
$sql = "SELECT *
FROM anime1, episode1
WHERE animeid='$animeid'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
$title = $row['title'];
$ep = $row['ep'];
}


?>

 

keep giving me back error

 

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\wamp\www\studying\take 2\addin12.php on line 45

[bamfon]

ok i forgot to put in

 

so the erorr  is

 

 

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\wamp\www\studying\take 2\addin12.php on line 45

Column 'animeid' in where clause is ambiguous

[revraz]

You need to state which table the field name is from, ie.. animel1.animeid

[bamfon]

its from both tables? so how would i do that?

[bamfon]

Fixed it changed it to <?php

 

$con = database_connect();

$sql = "SELECT * FROM anime1, episode1 WHERE anime1.animeid = '$animeid' AND episode1.animeid = '$animeid' ";

$result = mysql_query($sql);

while ($row = mysql_fetch_assoc($result)) {

$title = $row['title'];

$ep = $row['ep'];

 

}mysql_query($sql) or exit(mysql_error());