Unable to retreve the values from Mysql Query

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

Hi,

Here is the php code that I have, Query is running properly in phpmyadmin and is resulting 5 which is correct but when i try to get tht in php its not printing the value

$sql_query= "Select Count(*) from (Select Cat_Num from cat_completiondate where `EmployeeNumber`=$employeenumber and `CategoryJobPosition` =$jobid) as temp";
$query_result2=mysql_query($sql_query);
$result_row2=mysql_fetch_array($query_result2);
$value=$result_row2['temp'];
echo($value)


Output:- It doesnot print anything.

Your Answer:

Login to answer

Other forums

http to https
Hi,

Is there any specific method/condition to move an http:// page to https:// ?

SQL Query/echo not working
Hey all,

I'm trying to run (what I thought) was a simple operation and it isn't working. I h

Why use OOP?
Can someone explain to me why I should use OOP instead of procedure based code.

Im building a

Multiple submit forms inside a mysql array page
Hi all,

Im having trouble to get the beneath script to work the thing i can't seem to get wor

Any help with my email script?
I have an email script, I have not tested it, although someone tested it for me and said it worked f

help countdown timers
hello every one,

I'd like to know how to insert many countdowns in the same page.
The dura

Thread in PHP
Thread in PHP
Some basic use and basic code for thread in php
This is my question?

Adding meta tags under Zend FW
Hello there, recently has come to my hands the FTP of a website which is running under Zend, I would

first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see

need a script for 3 pages
I have a customer who wants me to set up a site with a number of pages with the following requiremen