Query help please
Posted: Fri Aug 08, 2003 2:39 pm
Hello, brief description of my mysql tables are
owners
-user_id
-email
-aim
-team_id
teams
-team_id
-location
-name
-pre
here's my query that i use
and heres my error message
owners
-user_id
-aim
-team_id
teams
-team_id
-location
-name
-pre
here's my query that i use
Code: Select all
<?php
mysql_connect("localhost", "user", "pass");
mysql_select_db("database");
$query = "select t.team_id, o.team_id, o.email, t.name, o.aim, t.location, from owners o, teams t WHERE o.team_id = t.team_id";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
echo "{$rowї'location']}";
echo "nbsp;";
echo "{$rowї'name']}";
echo " ";
echo "{$rowї'email']}";
echo " ";
echo "{$rowї'aim']}";
echo "<br>";
}
?>any help in remedying the situation would be GREATLY appreciatedWarning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/styckx/public_html/maddenworld/owners.php on line 25