Stored procedure not working when being called by php

Hi all, the following works , but when I use CALL getAudio() I get no result.

<?php

$connection = mysql_connect('localhost', 'root', '');
mysql_select_db('mcomp', $connection) or die(mysql_error());

// $q = "CALL getAudio()";

$q = "SELECT * FROM tbaudio t;";
$result = mysql_query($q, $connection);

while ( $row = mysql_fetch_array ( $result ) ) {
echo $row ["id"];
}

?>


I have verified the sp getAudio() on the query browser

any ideas?

Try

SELECT getAudio();

I think it should work ... I always call stored functions via SELECT. I did not call them without the FROM clause but since it is optional in MySQL, I think it should work.

That doesn't work either :(

http://uk3.php.net/pdo.prepared-statements may help

http://uk3.php.net/pdo.prepared-statements may help


Could you help me use that with the code I was trying, I am not sure what to do.

I tried this

<?php

$connection = mysql_connect('localhost', 'root', '');
mysql_select_db('mcomp', $connection) or die(mysql_error());


$stmt = $connection->prepare("call getAudio()");
$stmt->bindParam(1, $result, PDO::PARAM_STR, 4000);
$stmt->execute();

while ( $row = mysql_fetch_array ( $result ) ) {
echo $row ["id"];
}
/* $q = "SELECT * FROM tbaudio t;";
$result = mysql_query($q, $connection);

while ( $row = mysql_fetch_array ( $result ) ) {
echo $row ["id"];
} */



?>


but got this:


Fatal error: Call to a member function prepare() on a non-object

When it is necessary to work with the DB using PDO, mysql_connect() is not used. Please see how to connect to the database here (http://www.php.net/manual/en/pdo.connections.php).

This PDO stuff looks complex :)