Knowing if a query returns something

ginblossom

Hi I know this is a very simple Q but I just don't know where to look for a short answer or function to check the query.

$a_db->query("select * from name where status='single' order by id_number;");

Assuming all of the status are married. This query won't return any right? how do i make a if statement of the query didn't return any data.

ednark

depends on what system you are using...

what is $a_db, a pear object, and aodb object, your not using a straight mysql_connect handle?

or are you trying to write your own?

ginblossom

Above that code is a :

$a_db=new filerec_db;

$a_db->query("select * from name where status='single' order by id_number;");

What i'm trying to achieve here is for me to use the if statement something like this

$a_db=new filerec_db;

$a_db->query("select * from name where status='single' order by id_number;");

if ($a_db->status='active') {
echo "active";
}
else {
echo "notactive";
}

now I want to reverse the if statement. I want to test something like

if ($a_db->status=' ') {

echo "notactive";

}
else {
echo "active";
}

how do i check for 0 query result if all of the person in the status are all married?

planetsim

as i didnt see a mysql_num_rows or anything like that you can try empty() but i dont know if thats an int feild or not

ginblossom

I realized that my logic of IF statement is wrong. What I really need to use is the result of the query not the content of the "single field" since it was specify in my mysql statement only to select field wiht single status. Just incase there is no single status what will the query returns? if its a 0 the code need to run this or that. I need help on how I can construct that IF using the an empty query.

ednark

what is a filerec_db? did you are someone on your project hand write that? i don't think thats a standard php object.

Q: what exactly does your ->query function return if there was a success?

A: an array?

Q: what exactly does your ->query function return if there was not a success?

A: did you say 0

do a :
$result = $a_db->query();
gettype($result);

and tell me what that is

if it is a handwritten library then just look through the source to figure out what it returns in each case

ginblossom

----ednark wrote---
Q: what exactly does your ->query function return if there was a success?

A: an array?

It return list of person name with a single status.

-----ednark wrote -----------------------

Q: what exactly does your ->query function return if there was not a success?

A: did you say 0

yup it will return nothing and thats my problem and thats my question. what piece of code i can use to check this style in coding.

$a_db->query();

by the way filerec_db is a database name. And also about the code I'm not the one who originally coded it. Its too advance for me however I need to do some revisions.

ednark

ack!
this will set the status to active:
$a_db->status = 'active'

this will check to see if the status is active:
$a_db->status == 'active'

this will check the reverse:
$a_db->status != 'active'

does $a_db->query actually return data

$result = $a_db->query

or does it just set some internal varibale to the result

$a_db->query
print $a_db->status
print $a_db->result

look into using the [man]operators[/man] == and === as well as the functions [man]is_int/man and [man]is_array/man

they should either be of some use, or clarify things for you

$a_db=new filerec_db;

$results = $a_db->query("select * from name where status='single' order by id_number;");

if ( is_array($results) ) {

foreach ( $results as $result ) {
    print $result;
}

} else if ( $results == 0 ) {

print "no results found";

}