What's wrong with my query?

[mbacon]

SELECT * FROM `studentcourse` WHERE `systemcode` = 'ilscorp' AND `status` = 'complete' AND `techcode` IN (SELECT `techcode` FROM `usersubscription` WHERE `subscription_id` = '296')

After I run this the server has an intense lag and needs to be restarted or timeoutes occur.

[peter_budo]

SELECT * FROM `studentcourse` WHERE `systemcode` = 'ilscorp' AND `status` = 'complete' AND `techcode` IN (SELECT `techcode` FROM `usersubscription` WHERE `subscription_id` = '296')

I don't think you need to use single qoutes on variable names, they are used only on variable values when listed. Your query should be like this

SELECT * FROM studentcourse WHERE systemcode = 'ilscorp' AND status = 'complete' AND techcode IN (SELECT techcode FROM usersubscription WHERE subscription_id = '296')

[mbacon]

Hey I appreciate the reply, but removing backticks didn't change the behavoir of the query

[peter_budo]

Where do you use this query? Which database? In what enviroment(PHP to DB, servlets to DB)?

[mbacon]

I've tried it in PHPMYADMIN

and in my PHP script:

$select_results = mysql_query("SELECT * FROM `studentcourse` WHERE `systemcode` = 'ilscorp' AND `status` = 'complete' AND `techcode` IN (SELECT `techcode` FROM `usersubscription` WHERE `subscription_id` = '$subid')") or die("<BR>Failed to run MySQL query!<BR>".mysql_error().$form);

phpMyAdmin - 2.9.0.2

MySQL client version: 5.0.24a

PHP Version 5.1.6

[peter_budo]

is it only timeout and lag what you get, or some error message pop-up?