Why is my row count 0?

[iPixel]

Here's the MySQL query i'm running. It basically pulls data from 2 tables based on some data passed.

 

Here are things i know.

1. The data passed is passed correctly, and is correct as far as data goes.

2. The sql statements do run, the database connection is solid and works.

3. Other queries work, this however is the first join query im attempting.

4. employee_directory is a regular table, but pcsmgr.mvx_phone_history_io is a table inside the pcsmgr SCHEMA on the database. hence the prefix in the table names.

 

My guess it that perhaps the fact that my SELECT fields have two periods? maybe i dunno.

pcsmgr.mvx_phone_history_io.extension for example.

 

Here's the query - please see if you can figure out why the $recordCount returns 0;

<?php
#Check for this branch
$branchid_SQL = $brancharray[$key][0];
#===Find All People That Work for "filenumber" WITHIN EACH BRANCH
$sql_1 = "SELECT employee_directory.filenumber, 
				 employee_directory.phone, 
				 employee_directory.firstname, 
				 employee_directory.lastname, 
				 employee_directory.managerid, 
				 employee_directory.departmentid, 
				 employee_directory.branchid, 
				 pcsmgr.mvx_phone_history_io.extension, 
				 pcsmgr.mvx_phone_history_io.calldate, 
				 pcsmgr.mvx_phone_history_io.calltype, 
				 pcsmgr.mvx_phone_history_io.dur_seconds, 
				 pcsmgr.mvx_phone_history_io.dur_minutes, 
				 pcsmgr.mvx_phone_history_io.dist_pnums, 
				 pcsmgr.mvx_phone_history_io.count_pnums, 
				 pcsmgr.mvx_phone_history_io.dognet_user_id, 
				 pcsmgr.mvx_phone_history_io.callcat
		  FROM   pcsmgr.mvx_phone_history_io, employee_directory 
		  WHERE  employee_directory.managerid = '$DT_filenumber' AND
				 employee_directory.branchid = '$branchid_SQL' AND
				 employee_directory.filenumber = pcsmgr.mvx_phone_history_io.dognet_user_id";
$go_1 = oci_parse($conn, $sql_1);
oci_execute($go_1);
$result_1 = oci_fetch_assoc($go_1);
$recordCount = oci_num_rows($go_1);
echo $recordCount;
?>

 

-- NEW

 

just realised that by removing this line of code from the query

<?php
AND employee_directory.filenumber = pcsmgr.mvx_phone_history_io.dognet_user_id
?>

I actually get a result, an inaccurate one but a result none the less. So i guess the next question is whats wrong with that line?

[iPixel]

Update :

I ran this code

<?php
					while($result_1 = oci_fetch_assoc($go_1))
						{
							echo $result_1['FILENUMBER'] . " -- " . $result_1['FIRSTNAME'] . " -- " . $result_1['CALLCAT'] . "<BR>";
						}

?>

 

and it actually returns the proper results... so there's just something wrong with the $recordCount.

 

Could it simply be that it doesnt know which table to count from? Or something that silly?

 

and this is including that

employee_directory.filenumber = pcsmgr.mvx_phone_history_io.dognet_user_id

line

[corbin]

oci_num_rows

 

 

"Note: This function does not return number of rows selected! For SELECT statements this function will return the number of rows, that were fetched to the buffer with oci_fetch*() functions. "

 

No idea what function you do use to get the number of rows from a SELECT statement though.