php myAdmin gives different results than php code in query
Posted: Sat Mar 17, 2012 11:17 am
Here is a script that I typed into php MyAdmin:
SELECT
M.media_name FROM media as M
INNER JOIN member_media as J on J.mediaID = M.mediaID
WHERE J.maaMemberId = 209
The number of rows it returns is 3
Here is the php version:
$q = "SELECT
M.media_name FROM media as M
INNER JOIN member_media as J on J.mediaID = M.mediaID
WHERE J.maaMemberId = 209";
$r = @mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));
$row = mysqli_fetch_array ($r, MYSQLI_NUM);
echo $row[0];
echo $row[1];
echo $row[2];
exit();
The only result is $row[0] which is a correct result (matches first row in first example)
The other 2 rows give "Undefined offset"
SELECT
M.media_name FROM media as M
INNER JOIN member_media as J on J.mediaID = M.mediaID
WHERE J.maaMemberId = 209
The number of rows it returns is 3
Here is the php version:
$q = "SELECT
M.media_name FROM media as M
INNER JOIN member_media as J on J.mediaID = M.mediaID
WHERE J.maaMemberId = 209";
$r = @mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));
$row = mysqli_fetch_array ($r, MYSQLI_NUM);
echo $row[0];
echo $row[1];
echo $row[2];
exit();
The only result is $row[0] which is a correct result (matches first row in first example)
The other 2 rows give "Undefined offset"