<html><head></head><body bgcolor="#FFFFFF"><div>Have you tested the subquery in php?<br><br><br></div><div><br>On 29 Jun 2011, at 09:13, Dan Attwood <<a href="mailto:danattwood@gmail.com">danattwood@gmail.com</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div>I know that isn't strictly Linux but here we go;<div><br></div><div>I have the following mysql query:</div><div><br></div><div>SELECT * FROM usr WHERE <a href="http://usr.id">usr.id</a> NOT IN (SELECT DISTINCT member FROM mahara.group_member WHERE mahara.group_member.group='10')</div>
<div><br></div><div>This selects all users in the usr table that don't have entry for group 10 in the group_member table</div><div><br></div><div>The query works as expected when run in mysql workbench</div><div><br></div>
<div>However when I run it in a php script it only run the first part, so does a select * from usr</div><div><br></div><div>Has anyone come across this before and have any idea of a fix?</div><div><br></div><div>Dan</div>
<div> </div>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>Kent mailing list</span><br><span><a href="mailto:Kent@mailman.lug.org.uk">Kent@mailman.lug.org.uk</a></span><br><span><a href="https://mailman.lug.org.uk/mailman/listinfo/kent">https://mailman.lug.org.uk/mailman/listinfo/kent</a></span></div></blockquote></body></html>