Why is my row count 0?

Posted on 16th Feb 2014 07:03 pm by admin

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;
Code: <?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
Code: <?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?

Your Answer:

Login to answer

Other forums

Help with PHP Calendar code...
Hello, I'm new to this forum and I'm glad I found it.
I wrote this code for a PHP calendar as an

True way to see if action was successful?
If this is a good way to see if action was successful to continue:

Code: function changeGa

Pre-Fill out a PHP form...??
This is for work actually (geek squad). We have to fill out this online php form at work over and ov

Spaghetti Code
So.

I've pretty much reached the point where I have so many isset s on one page that I can't

Help building / using array
First - this is a cross-posting, if this is wrong I apologise! What started out as a MySQL query que

mysql_real_escape_string making variable equal nothing
i post a form and i post the variable:
Code: $var = $_POST[variable];then i echo $var its what i

PHP code needed to get/post form fields and request mysql query results.
I'm new to PHP

I've created an html form to allow the user to request a basic telephone dire

PHP Game
hy i was wondering what's the best method in order to make some automatic updates in a php game
<

Converting from one format to another
"I have got a date in DD/MM/YYYY but I need it in MM-DD-YYYY. Help!"

How to write on database when a link is clicked?
Hi, I have a list of products in a gridview. When the link is clicked currently it takes to an ext