SQL and PHP need help

[jpoltora]

Hi,

Could someone help me I try to do 'COUNT()'
$query2 = "
SELECT count()
FROM paper, academic ac, author aut1
WHERE ac.FamName = '$tokenf'
and ac.GiveName = '$tokeng'
and ac.AcNum = aut1.AcNum
and aut1.PaNum = paper.PaNum";

and after try to feach the result by:

$Handler2 = ociparse($connection, $query2);

// ociexecute($Handler1); // Run the query
ociexecute($Handler2);
....
$number = trim(ociresult($Handler1, 1));
echo "Number of publication: $number\n";

and this is my error message
Warning: ociresult(): supplied argument is not a valid OCI8-Statement resource in.

how can I get the value in 'count(*)?

[sdjensen]

// ociexecute($Handler1); // Run the query 
ociexecute($Handler2); 
.... 
$number = trim(ociresult($Handler1, 1)); 

You need to change to code to

// ociexecute($Handler1); // Run the query 
ociexecute($Handler2); 
.... 
$number = trim(ociresult($Handler2, 1));