Posted by Jon on 01/10/06 00:33

Display them via HTML on a php page you mean?

If you just want to display each row, you'd use something like this - When
you say 'one field in each row gets a variable' I'm not sure what you mean
there - I'll include code that I would likely use if I wanted to assign a
variable for ONE field for each record - it'd go into an array for me
personally. This code also isn't exact, just typed on the fly -

$i = 0; //counter for array

//setup and run the query
$sql = "SELECT * FROM table_name";
$queryResult = mysql_query($sql);

//cycle through the query to get the rows outputted and data setup
while($row = mysql_fetch_array($queryResult)){

//echo for each field you want to display from each row
echo $row['fieldName1'].$row['fieldName2];

//Assign a field to an array
$array[$i] = $row['fieldName1];
$i++; //increment $i to move to the next index in the array when the
loop runs again. $i should be equal to the number of records at the end

}//end while


That help or am I not understanindg the question?

"ameshkin" <amir.meshkin@gmail.com> wrote in message
news:1136845201.967334.289610@g49g2000cwa.googlegroups.com...
>I know this is probably not too hard to do, but how do I display
> multiple rows of a mysql query/recordset. Im having trouble doing
> this. I don't just want to display them, but I want to make sure ONE
> field in each row gets a variable.
>
> This is probably something simple that is more experienced, but I've
> only been doing this for a couple of months. Any help would be
> appreicated.
>
> Thank You
>

[Back to original message]