Menu
Community /Pin to ProfileBookmark
@NogDogJul 28.2005 — #The '@' suppresses error reporting on the function call. It's OK to do that as long as you have the code check the result of the query and handle any false condition as appropriate. My personal stylistic preference (not better, just different) would be to do:
The MYSQL_ASSOC constant tells mysql_fetch_array to only return the associative array for that result row. You can do the same with less typing as:
Without the 2nd parameter to mysql_fetch_array(), you get both a numerically indexed array plus the associative array.
What if a MySQL query target does not exist?
If I’m selecting a row that has a specific property1 and property2, but that row does not exist…….
Can I put this:
[code=php]
$sql = mysql_fetch_array(mysql_query(“SELECT property3 FROM table WHERE table.property1 = ‘blah’ AND table.property2 = ‘blah2’;”));
if(“Empty Nested Set”!=$sql) {
do this if it does exist }
else {
do this if it doesn’t exist }
Would that work? Thanks in Advance!
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogJul 28.2005 — #The '@' suppresses error reporting on the function call. It's OK to do that as long as you have the code check the result of the query and handle any false condition as appropriate. My personal stylistic preference (not better, just different) would be to do:[code=php]
$query = "SELECT property3 FROM table WHERE table.property1 = 'blah' AND table.property2 = 'blah2'";
$result = mysql_query($query) or die("Query failed: ".mysql_error()." -- ".$query);
# the die() message will show the MySQL error message and the exact query text
# once you've debugged the script, remove the stuff after "Query failed" before
# putting the script in production, as such info could be a security hole
if(mysql_num_rows($result) == 0)
{
# handle no rows returned situation
}
else
{
# handle 1 or more rows returned
}
[/code]The MYSQL_ASSOC constant tells mysql_fetch_array to only return the associative array for that result row. You can do the same with less typing as:
[code=php]
mysql_fetch_assoc($result);
[/code]Without the 2nd parameter to mysql_fetch_array(), you get both a numerically indexed array plus the associative array.