Can somebody tell me why this query string has nothing in it?
$query = “SELECT wkusers.uid, wkusers.name, alertuserstogroups.alertgroupuid FROM wkusers LEFT JOIN alertuserstogroups ON wkusers.uid = alertuserstogroups.useruid”;
$result = mysql_result($query);
while($row = mysql_fetch_array($result)) {
echo “blah”;
}
My thoughts were that there was something wrong with the php interpreter and the periods in the query.
Anybody have any thoughts regarding this?
This is a valid query and we have connection to database.
