Solved

What value does $query = mysql_query("select * from member where loginID like '$loginID'") return if there is no field with loginID = $loginID

Posted on 2008-06-21
4
229 Views
Last Modified: 2008-06-22
I have the following code...
$query = mysql_query("select * from member where loginID like '$loginID'");

I have an if statement that follows as thus...
if(!empty($query)){
//code
}

that if statement, though, won't execute if there is a value in $query
0
Comment
Question by:jabrthel
  • 2
  • 2
4 Comments
 
LVL 82

Accepted Solution

by:
hielo earned 500 total points
ID: 21839741
it returns a resource which has zero records. So if you are trying to find out how many records were returned you need:
$query = mysql_query("select * from member where loginID like '$loginID'");
if( 0==mysql_num_rows($query) )
{
  echo "No records found";
}
0
 

Author Comment

by:jabrthel
ID: 21839807
That worked, I just needed to change == to !=
0
 

Author Comment

by:jabrthel
ID: 21839809
thanks
0
 
LVL 82

Expert Comment

by:hielo
ID: 21840973
You are welcome!
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Exporting image to excel from php document 10 26
.htaccess 5 33
PHP and google maps 13 42
google analytics in wordpress 4 31
Generating table dynamically is the most common issue faced by php developers.... So it seems there is a need of an article that explains the basic concept of generating tables dynamically. It just requires a basic knowledge of html and little maths…
Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now