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?
No comments posted yet
Your Answer:
Login to answer
68 
44 
Other forums
Are sessions secure at all?..
I haven't really gotten into yet, but I was just thinking of something weird..
Lets say you h
Must be a string? Huh, what? HELP?
with the following script, I get
Fatal error: Property name must be a string in /home/content/e/
PHP FTP Can't upload Big FIles
Anyone had any success using FTP to upload a file say 90m?
im using ftp_put and it returns fa
Load file in PHP
I have 2 files. The first is a PHP generated XML file that's dependent by 2 inputs. The second is a
This must be easy , pulling the last record of the day, every day, from a txt
I have a txt file logging weather data every minutes (so 1 record per minute). I want to extract the
C++ API to Oracle dB
I need to perform a select command to the Oracle dB to obtain information from a table.
What libr
md5 is it unique
I know this is most likely one of many simple questions that can be found semi easily. But I'm press
New Search Engine
Hey everyone,
I have a ZIP Code Radius search engine already functional. it displays all of t
newbie error
what is wrong with this code ?
<html>
<body>
<?
Executing an exe
Hi. I have some bizarre problem with exec (other any other method) to launch exe's. I am making a ga
