Subquery mysql_error

[Andrew R]

Can anybody see why the following sql query gives an mysql_error?

 

$clients_q = mysql_query("SELECT * FROM organisations where organisation_Id = (SELECT organisation_id FROM hosting WHERE server_id = '1')") or die(mysql_error);
$clients = mysql_fetch_array($clients_q);
$total_users = mysql_num_rows($clients_q);

 

Many thanks

 

 

[JonnoTheDev]

Are your field names correct?

organisation_Id = (SELECT organisation_id

 

What is the error?

 

 

[Andrew R]

Thanks for the reply.

 

All fields are correct and the error is 'mysql_error'.

 

Many thanks.

[JonnoTheDev]

Change your code to:

or die(mysql_error());

 

And then give us the error

[aschk]

How about you try using a JOIN instead:

 

SELECT o.*
FROM organisations o
JOIN hosting h ON h.organisation_id = o.organisation_Id
WHERE h.server_id = '1'

 

Something tells me the error might be related to the fact that your subquery returned more than 1 resulting row. 

[Maq]

Should

 

organisation_Id

 

be (lowercase i) ?

 

organisation_id

[JonnoTheDev]

Already asked that Maq

[Maq]

Already asked that Maq

 

Sorry, yeah I just skimmed over and thought you were asking something else (obviously). 

[aschk]

It doesn't matter if it's upper, lower or combo case. MySQL doesn't care about cases for columns , it ONLY cares about cases for table names.

[fenway]

Yes, you'd need IN, not =.

[ashishag67]

why dont you try this

 

$client_q=mysql_query("SELECT * FROM organisations o, hosting h where o.organisation_Id=h.server_id='1'") or die(mysql_error());

$client=mysql_fetch_array($client_q);
$total_users=mysql_num_rows($client_q);

 

Do let me know if this works.

 

Cheers