Having banged my head against a brick wall trying to call mysql stored procedures and actually get the results from the output parameters in php we finally installed php5 and mysqli on the server.
$sql="call insert_account(
'$SQLEmailAddress','$SQLPassword','$SQLFirstName',@retval);
select @retval as return_string;";
if (mysqli_multi_query($link,$sql)) {
do {
if ($result = mysqli_store_result($link)) {
$row = mysqli_fetch_row($result);
$ResultString=$row["return_string"];
if ($ResultString!="S") {
echo "There is already an account for this email address. ";
}
else {
echo "Account created successfully. You will shortly be receiving an email
with a link to confirm your registration.";
include("confirmationemail.php");
}
mysqli_free_result($result);
}
} while (mysqli_next_result($link));
}
mysqli_close($link);
Job done!