Just started tearing up php got a lot working surprisingly I am trying to echo back all data from my query I can separate and get back with echo $row[0]; or add them . " "$row[1]…ect. but how can I just get back everything without incrementing through them like $row +1 or something. Also the array is coming back six times, when there are only two matches in the database why is that?
<?php
$query = "SELECT * FROM pages, users, usersInfo";
$query .= " WHERE usersInfo.userID = {$_SESSION['user_id']}";
$query .= " And pages.id = usersInfo.projectID ";
$result_set = mysql_query($query, $connection);
confirm_query($result_set);
while ($row=mysql_fetch_array($result_set)) {
echo $row[0] . "<br />";
}
?>
thanks in advance for the advice. MT
