Excluding a row

[RynMan]

Hi guys

 

So I'm trying to display some text from mySQL but it's only showing one of the two records in the database.  Here's my code....

 

$resultWriters = mysql_query("SELECT * FROM `tblclientinformation` WHERE Fight = 1 ORDER BY LastName ASC ; ", $connection);
if (!$resultWriters) { 
die("Database query failed" . mysql_error()) ;
}

while ($arrayWriters = mysql_fetch_array($resultWriters)){

	echo '
	<tr>
	<td> </td>
	<td><span class="FieldText14">
	<a href="cvprofile_other.php?CVType=director&KamID='.$arrayWriters["KAMClientID"].'">' 
	.$arrayWriters["FirstName"]." ".$arrayWriters["LastName"].'</span></a></td>
	<td> </td>
	</tr>
	';
	}

 

Any idea why it's only displaying one of the two records returned in my query? 

[PFMaBiSmAd]

If that is all the relevant code, then there IS only one matching row.

 

What does echoing mysql_num_rows($resultWriters); show?

[RynMan]

If that is all the relevant code, then there IS only one matching row.

 

What does echoing mysql_num_rows($resultWriters); show?

 

2

 

[PFMaBiSmAd]

What does a 'view source' of the page in your browser show?

[RynMan]

My apologies PFM.

 

I found this code also occurring in there....

 

$arrayWriters = mysql_fetch_array($resultWriters)	;

 

This was the cause.  Thanks for your help.

[PFMaBiSmAd]

We cannot really help you with what your code is doing when you don't post your actual relevant code. It just wastes everyones time.

[RynMan]

We cannot really help you with what your code is doing when you don't post your actual relevant code. It just wastes everyones time.

 

I have a lot of code, and I realise when ppl post every line of code they have, it deters other from taking a look at their problem.  In this case, I made a mistake and apologised for it.  Thanks for your understanding.