Need help with a query

[rizzah00]

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 i get this error message

<?php  

mysql_connect("localhost", "user", "pass");  

mysql_select_db("database");  

$query = "select 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>"; 


}  

?> 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/styckx/public_html/maddenworld/owners.php on line 25

any help in remedying the situation would be GREATLY appreciated 🙂

[steadyguy]

If I'm not mistaken, you need to select the rows you use in a WHERE clause, otherwise the query will generate an error - which won't give you an array, giving you the error you listed.

Try:
SELECT o.team_id, o.email, o.aim, t.team_id, t.name, t.location,
FROM owners o, teams t
WHERE o.team_id = t.team_id

[rizzah00]

thats the line im using look at the code 🙂

[tekky]

Well its either you need to select o.email AS email like I did in this code..... or you cant use WHERE on a field you arent selecting? <- really not sure on the last one as I've always had to select the column I was using in WHERE for other reasons....

<?php  

mysql_connect("localhost", "user", "pass");  

mysql_select_db("database");  

$query = "select o.email email, t.name name, o.aim aim, t.location 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>"; 


}  

?> 

[rizzah00]

that didnt work either..

[steadyguy]

The query I submitted isn't the same as the one you originally posted ... look carefully. The query I submitted earlier has two extra columns being selected (o.team_id, and t.team_id), which are not in the query you posted. Without them, the WHERE clause will fail.

[rizzah00]

Originally posted by steadyguy
The query I submitted isn't the same as the one you originally posted ... look carefully. The query I submitted earlier has two extra columns being selected (o.team_id, and t.team_id), which are not in the query you posted. Without them, the WHERE clause will fail.

it still doesnt work, and that inconseqential because it all worked fine when i didnt select the t.location

[steadyguy]

If you need to use the the location, just take out the comma after it ... should have seen that before.

[rizzah00]

haha wow, too much time in front of the computer editor today, lol much thanks 🙂

[steadyguy]

no problem ... it's not just you, either .. 😃

[tekky]

Originally posted by steadyguy
If you need to use the the location, just take out the comma after it ... should have seen that before.

nice catch... now why didnt I see it... grumble :rolleyes:

glad its working now though 😃