Normale Datenbank Abfrage mit
$geodb_locationsresult = mysql_query("select * from geodb_locations");
$geodb_locationsnum = mysql_num_rows($geodb_locationsresult);
$geodb_locationsrow = mysql_fetch_array($geodb_locationsresult);
.
Aber bei
$geodb_locationsresult = mysql_query("SELECT umkreis.name_int AS ort,
ROUND(standort.laenge,3) AS km from
geodb_locations umkreis, geodb_locations standort
WHERE
standort.name_int = 'Köln' AND umkreis.name_int != 'Köln' ");
$geodb_locationsnum = mysql_num_rows($geodb_locationsresult);
$geodb_locationsrow = mysql_fetch_array($geodb_locationsresult);
krieg ich immer den fehler :
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
Liegts am AS oder was versteh ich da nicht ?
$geodb_locationsresult = mysql_query("select * from geodb_locations");
$geodb_locationsnum = mysql_num_rows($geodb_locationsresult);
$geodb_locationsrow = mysql_fetch_array($geodb_locationsresult);
.
Aber bei
$geodb_locationsresult = mysql_query("SELECT umkreis.name_int AS ort,
ROUND(standort.laenge,3) AS km from
geodb_locations umkreis, geodb_locations standort
WHERE
standort.name_int = 'Köln' AND umkreis.name_int != 'Köln' ");
$geodb_locationsnum = mysql_num_rows($geodb_locationsresult);
$geodb_locationsrow = mysql_fetch_array($geodb_locationsresult);
krieg ich immer den fehler :
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
Liegts am AS oder was versteh ich da nicht ?