error when executing procedure from PHP
Posted by:
sdfv sdfv
Date: February 04, 2006 07:16AM
Hi,
I created a stored procedure in Mysql 5.0 (test()). It works.
Now i tried to execute it with PHP (5.0), but i get the error:
"Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in c:\storedprocMy.php on line 5"
Thanks for helping
maisql
The code:
<?php
$link = mysql_connect("localhost", "root", "xxx")
or die("Impossible de se connecter : " . mysql_error());
$dbsel = mysql_select_db('reserv', $link);
$result = mysql_query($link,"call test()");
while ($row = mysql_fetch_assoc($result)) {
$nom = $row['logon'];
$resnr = $row['resnr'];
echo $nom;
echo $resnr;
echo "<br>";
}
mysql_close($link);
?>
Subject
Views
Written By
Posted
error when executing procedure from PHP
4099
February 04, 2006 07:16AM
2017
February 04, 2006 02:19PM
1956
February 05, 2006 03:57AM
1869
February 05, 2006 11:05PM
2064
February 06, 2006 05:55AM
1867
February 06, 2006 10:28AM
2099
February 06, 2006 12:47PM
1718
February 06, 2006 02:37PM
1965
February 07, 2006 10:58AM
1757
February 07, 2006 02:14PM
2073
February 06, 2006 06:43PM
1893
February 06, 2006 08:42PM
4322
February 07, 2006 03:04AM
2147
February 07, 2006 10:12AM
2057
February 07, 2006 10:53AM
1725
February 07, 2006 01:33PM
1782
February 07, 2006 02:24PM
1717
February 07, 2006 04:26PM
1741
February 07, 2006 05:31PM
1906
February 08, 2006 10:16AM
1927
June 05, 2006 08:39AM
1812
June 05, 2006 08:43AM
1725
June 15, 2006 04:14AM
1619
June 15, 2006 07:05AM
1699
February 07, 2006 02:50PM
1921
February 08, 2006 07:34AM
1787
February 08, 2006 10:31AM
1690
February 08, 2006 11:51AM
1692
February 08, 2006 12:08PM
1815
February 08, 2006 10:57AM
1891
June 09, 2006 11:13PM