When looping Resources, Cant get the first array to display!

numerical25

Im trying to fetch some resources from MySQL and then loop it out onto my website! this is what Im doing below.

NOTE: It works, it just doesnt display the very first row in my 'mySQL' database I am also using dreamweaver to connect to my 'MySQL' Database. Im not sure if that has anything to do with it.

<?php
mysql_select_db($database_ok, $ok);
$query_Recordset1 = "SELECT * FROM users LIMIT 0, 10";
$Recordset1 = mysql_query($query_Recordset1, $ok) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

<?php 
while( $row = mysql_fetch_assoc($Recordset1)) {
	echo $row['lastname']." ".$row['firstname']."</br>";
} ;
?>

Lets say that in my database I have 'Joe' in column firstname row 1. And I have Bill in column first name row 2, and so on. It will only display Bill (row2) and down. It wont display Joe. Why?!?!

ABOUT ME:
O yea, Just to introduce myself. My Name is Anthony, I was doing Coldfusion for a little while now Im doing PHP. Im new and I have alot of questions. Reason Im introducing myself is because Im going to be blowing up this forum cause I got tons of questions. See you guys around 😃

laserlight

You make an additional call to mysql_fetch_assoc() before your loop.

HalfaBee

You are reading the first row here

$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

Put code in [ php] [ /php] tags to make it readable

numerical25

What do you mean, make a additional call to mysql_fetch_assoc() ?
Where would I place the additional call at?
Why would I have to make that additional call for ?

HalfaBee

You have that line and it should be removed.

Line 5 of your first code post.

NogDog

Not make an additional call, but rather you are making an apparently extra and unnecessary call, which is moving the result row pointer to the second row before you start your while loop through the result rows:

<?php
mysql_select_db($database_ok, $ok);
$query_Recordset1 = "SELECT * FROM users LIMIT 0, 10";
$Recordset1 = mysql_query($query_Recordset1, $ok) or die(mysql_error());
[color=red]$row_Recordset1 = mysql_fetch_assoc($Recordset1);[/color] [color=blue]// <-- this line[/color]
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

numerical25

O ok. Well I was only copying another code similar to mine and it worked fine. It went like this...

<?php require_once('Connections/ok.php'); ?>
<?php
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

mysql_select_db($database_ok, $ok);
$query_Recordset1 = "SELECT * FROM users";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $ok) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($_GET['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>

Below is in the body

<body> 
<html>
<table border="1">
  <tr>
    <td>lastname</td>
    <td>useraddress</td>
    <td>firstname</td>
    <td>loginName</td>
    <td>loginPassword</td>
  </tr>
  <?php do { ?>
    <tr>
      <td><?php echo $row_Recordset1['lastname']; ?></td>
      <td><?php echo $row_Recordset1['useraddress']; ?></td>
      <td><?php echo $row_Recordset1['firstname']; ?></td>
      <td><?php echo $row_Recordset1['loginName']; ?></td>
      <td><?php echo $row_Recordset1['loginPassword']; ?></td>
    </tr>
    <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

Im a little bit confused about how the mysql_fetch_assoc() function works. Could someone give me a walk through on how exactly the function works. I here about this Pointer that moves to the next line. What exactly is this pointer ?

NogDog

When you call one of the mysql_fetch_*() functions, it reads the current query result row data, then increments a "row pointer" to the next row, so that the next time you call it (as you do within a the loop), it reads the next result row (or returns false if there are no more rows left to read). This is what allows the typical while($row = mysql_fetch_assoc()) { loop construct to work, reading the next result row on each iteration through the loop.

That line I highlighted in my previous response is doing a single call to mysql_fetch_assoc(), so it is reading the first row of data and incrementing the result row pointer. Therefore, when you get to the loop where you actually do something with the query results, you are starting with the second row of query results, not the first, then looping through all the remaining result rows.

For more info, see [man]mysql_fetch_assoc[/man] and [man]mysql_data_seek[/man].

laserlight

Not make an additional call, but rather you are making an apparently extra and unnecessary call

Ah yes, "unnecessary" was the word I was looking for. Originally wrote "spurious", but that did not seem right 🙂

HalfaBee

Well, I thought spurious would have covered it, but I was totally wrong.

http://dictionary.reference.com/search?r=2&q=spurious

I can see I need to be more expansive on my posts, NogDog really covered it 🙂

Piranha

numerical25 wrote:
O ok. Well I was only copying another code similar to mine and it worked fine.

No, it didn't work fine, you didn't get the first row. I suggest that you do all your coding yourself until you understand PHP and then start using others code. And that you check all code you are using to make sure that it is up to your standards and don't have bugs or other malicious stuff in it. Just to copy-paste will get you in lots of trouble.

HalfaBee

No, it didn't work fine, you didn't get the first row.

They did get the first row, just an extra blank row in the html table.

I suggest that you do all your coding yourself until you understand PHP and then start using others code. And that you check all code you are using to make sure that it is up to your standards and don't have bugs or other malicious stuff in it. Just to copy-paste will get you in lots of trouble.

Definately!

Sometimes it makes you wonder.