mysql_fetch_array

[php4_23]

I am having a bit of trouble understanding how to loop through display .....let me just show you.

If I have something like this

$query = "SELECT title,name  from WHATEVER"
$result = mysql_query($query);

while ($qry = mysql_fetch_array($result))
{
echo "Title" . $qry[title]. ";
echo "Name" .$qry[name]. ";
}

Will this loop through and display all the
information that is stored in the 'name' and 'title' colums.
Am I making sense?
Thanks

[xblue]

in general: yes, once you rid of the syntax errors. mysql_fetch_array gets you on row each time it is called (used in a while loop like this, until there are no more rows).

$query = "SELECT title,name  from WHATEVER";
$result = mysql_query($query);

while ($qry = mysql_fetch_array($result))
{
    echo "Title" . $qry[title]." ";
    echo "Name" .$qry[name]." ";
}

assuming that your query is valid, this would display all in one line, with only some spaces (keep in mind that spaces are ignored unless they are within quotes), so you might change this to

$query = "SELECT title,name  from WHATEVER";
$result = mysql_query($query) or die (mysql_error());

while ($qry = mysql_fetch_array($result))
{
    echo "Title " . $qry['title']." ";
    echo "Name " .$qry['name']."<br />";
}

[mahers]

It certainly will. Except for a couple of errors.

echo "Title" . $qry[title]. ";
echo "Name" .$qry[name]. ";

// Should be
echo "Title".$qry['title'];
echo "Name".$qry['name'];

[php4_23]

Okay thanks guys. Yeah, I am aware of the syntax errors (and less than sufficient error handling) I just quickly typed some stuff down so you could see what I mean.
thanks🙂