While Loop mysql_fetch_array question

RobRocker

Hello,

I have a question.

I have a while loop that looks like this

while($info = mysql_fetch_array($Recordset1))
	{
        Print "random information with variables";
}

It outputs all the queries except the first one. Is there a way I can do something to the effect of "-1" to make it grab the first one aswell? This is really bugging me especially when I am trying to create a multilevel filter.

Thanks & God Bless

devinemke

$result = mysql_query('SELECT * FROM table') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result)) {print_r($row);}

RobRocker

Here is my actual code.

while($info = mysql_fetch_array($Recordset1))
	{
	Print "<tr>";
	Print "<td valign='top' width='25%'>Title:</td><td colspan='2' valign='top' width='25%'>" . $info['title'] . "</td><td rowspan='3' valign='top'><a href='" .$info['img_1'] . "'><img src='" .$info['img_1'] . "' width='200' height='150' style='border-color: #ffffff'></a></td>";
	Print "</tr>";
	Print "<tr>";
	Print "<td valign='top'>Description:</td><td valign='top'>".$info['description'] . "</td>";
		Print "</tr>";
	Print "<tr>";
	Print "<td valign='top'>Address:<p>" . outputUser($row_name['name']) . "</td> <td valign='top'>".$info['address'] . " </td>"; 
	Print "</tr>";
	Print "<tr>";
	Print "<td valign='top' align='right' colspan='4'><div style='float:left; margin-left: 315px;'><form action='" .  $editFormAction . "' method='POST' name='form1'><select name='databasetake' class='form' style='margin-bottom: 4px;'><option value='c_4sale'>For Sale</option><option value='p_4Lease'>For Lease</option><option value='p_Sales'>Sold</option><option value='p_Lease'>Leased</option></select><input name='id' type='hidden' value='" . $info['id'] . "'>&nbsp;&nbsp;<input type='image' src='images/move.gif'><input type='hidden' name='MM_update' value='form1'></form></div><a href='property.php?id=" . $info['id'] . "&datatable=" . $info['datatable'] . "'><img src='images/edit.gif' border='0' alt='Edit Property'></a> &nbsp; <a href='javascript:BRB_PHP_DelWithCon(". $deletelink . "," . $idtext . "," . $info['id'] . "," .$test . ");'><img src='images/delete.gif' border='0' alt='Delete Property'></a></td>"; 
	Print "</tr>";	
	}

So should I change Print to print_r?

RobRocker

I also would like to store all of the results into a variable or array of some sort. How would I go about doing that?