Menu
Community /Pin to ProfileBookmark
@NogDogSep 08.2005 — #
However, depending on what's in your querydatabase() function, you may need some code there, too, to keep it from throwing any errors.@NogDogSep 11.2005 — #
Hmmm....how so? A mysql_query() should only trigger a warning if the query is invalid, not if it returns no matches. If you're running into errors when trying to read from a query result that has no rows, then precede that part with an if statement, such as:
how do I ignorewarnings in php
[code]
$query = “select wwlands.type as type from wwlands where number1 = $y”;
$result = [b]@[/b]querydatabase ($query);
if (mysql_result($result, 0, “type”) == 1)
echo “<img src=images/stst.jpg alt=M />”;
Heres the code. Now I am looking up alot of things that may exist or may not. I do I do this look up and not have all the warnings not found printed on the page.
tia
Sign in
to post a comment11 Comments(s) ↴
0
@NogDogSep 08.2005 — #[code=php]
$query = "select wwlands.type as type from wwlands where number1 = $y";
if($result = @querydatabase ($query))
{
if (mysql_result($result, 0, "type") == 1)
{
echo "<img src=images/stst.jpg alt=M />";
}
}
[/code]However, depending on what's in your querydatabase() function, you may need some code there, too, to keep it from throwing any errors.
0
@NogDogSep 11.2005 — #yes but errors and warning are 2 different things.
warnings are inevatable when I look for data that does not exist.[/QUOTE]
Hmmm....how so? A mysql_query() should only trigger a warning if the query is invalid, not if it returns no matches. If you're running into errors when trying to read from a query result that has no rows, then precede that part with an if statement, such as:
[code=php]
if(mysql_num_rows($result) > 0)
{
while($row = mysql_fetch_array($result))
{
# output data for this row
}
}
else
{
# output error message saying no data was found.
}
[/code]