Re: Odp: [PHP-DB] Best way to check if a query succeeded
| From: | Hans-Werner Guth | Date: | Thu, 29 Mar 2001 12:25:42 +0000 |
| Subject: | Re: Odp: [PHP-DB] Best way to check if a query succeeded | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-7969@lists.php.net to get a copy of this message | ||
We do it this way (code snippet)
...
$dbqueryline = mysql_db_query ($mredatabase,
"select vorgang, bezeichnung
from mrebewkennz
order by vorgang", $dbhandle);
if (mysql_errno() != 0)
{
echo mysql_error(); echo "\n";
}
else
{
$bewkenznzahl = mysql_num_rows($dbqueryline);
print "$bewkenznzahl Bewegungskennzeichen\n";
}
Bartek Pawlik wrote:
> ...snipp...
> >
> > I normally do something like:
> >
> > $sql = "SELECT something FROM table";
> > $result = mysql_query($sql);
> > if(@mysql_num_rows($result) > 0) {
> > echo'Query Suceeded';
> > } else {
> > echo'Query failed';
> > }
...snipp...
--
Hans-Werner Guth S http://www.qits.de
QITS GmbH T mailto:hwguth@qits.de
Formerstr 53 I fon +49-2102-852-145
40878 Ratingen Q fax +49-2102-852-202