I've got a billing query, and then a billing result. How can I use the billing result twice? or can I? I mean is there a clean way of doing this or do I have to do 2 separate queries?

Here's the code in question:

$billingQuery = "SELECT * FROM Billing WHERE UID = '$userData[UID]'";
$billingResult = mysql_query($billingQuery)or die("#164;billingQuery error: ".mysql_error());
$billingCount = mysql_num_rows($billingResult);


while($billingData = mysql_fetch_array($billingResult)){
    foreach($billingData as $key => $value){
        echo "$key => $value <br>";
    }
}

if($billingCount >= 1){
echo "<br>found $billingCount!! <br>";
// now the following array should have the same data as $billingData, but doesn't
$billingDataPrime = mysql_fetch_array($billingResult);
echo $billingDataPrime['Last_Pmt']."<br>";
}

The best ideas are not the simple ones, they're the complex ones made easy.

cottager,
Try this:

  $uid = trim($userData[UID]);
  // SELECT * FROM Billing WHERE UID = '$userData[UID]'

  $sql = "SELECT * ";
  $sql .= "FROM Billing ";
  $sql .= "WHERE UID = '" . $uid . "'";
  $rst = @$con->query($sql);


  if($rst == false)
  {
    echo "<h4>Error: " . mysqli_error($con) . "</h4>";
  }
  elseif(@mysqli_num_rows($rst) == 0)
  {
    echo "<h4>Query completed. No results returned.</h4>";
  }
  else
  {
    /* Display results */

    echo "<table border='1'>";
    echo " <thead>";
    echo " <tr>";

    // Get fieldnames as table headers from the result query:
    $fields = mysqli_fetch_fields($rst);
    foreach($fields as $field)
    {
      echo "<th>&nbsp;" . $field->name . "&nbsp;</th>";
    }

    echo " </tr>";
    echo " </thead>";
    echo " <tbody>";

    // Get Number of rows from the result query:
    for ($i=0; $i<mysqli_num_rows($rst); $i++)
    {
      echo "<tr>";

      // In each row get values for each columns from the result query:
      $row = mysqli_fetch_row($rst);
      foreach($row as $value)
      {
        echo "<td>&nbsp;" .$value. "&nbsp;</td>";
      }
      echo "</tr>";
    }

    echo " </tbody>";
    echo "</table>";
  }