• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 815
  • Last Modified:

MySQL Resource ID #13

I get this error when executing:

SELECT
      DomainID,DomainName
FROM tblDomainNames
WHERE DomainID NOT IN(SELECT DomainID FROM tblYearlyFees)


there are only about 2000 records in each table
0
willsherwood
Asked:
willsherwood
  • 4
  • 3
1 Solution
 
maeltarCommented:
Can you show the code you are using to get the data please..
0
 
willsherwoodAuthor Commented:
SELECT
      DomainID,DomainName
FROM tblDomainNames
WHERE DomainID NOT IN(SELECT DomainID FROM tblYearlyFees)
0
 
SharathData EngineerCommented:
What is the error?
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
maeltarCommented:
Sorry, when I said code I meant the php, not the query...


Give the following a try and see what happens...

$sql = "SELECT
      DomainID,DomainName
FROM tblDomainNames
WHERE DomainID NOT IN(SELECT DomainID FROM tblYearlyFees)";

$result = mysql_query($sql);

if (!$result){
echo "Error in query " . mysql_error();
die();
}else{
while ($row = mysql_fetch_array($result){
echo "<pre>";
print_r($row);
echo "</pre>";
}

}

Open in new window

0
 
willsherwoodAuthor Commented:
There's no PHP, it's from interactive interface.
i'll try with the other interface and see if it shows more detail.
0
 
willsherwoodAuthor Commented:
odd, it worked without error in the other interface!
go figure - thanks for triggering me to do that
0
 
willsherwoodAuthor Commented:
thanks
0
 
maeltarCommented:
Glad you are sorted, thanks for the points adn have a great New Year
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now