[twmprys]

Another problem from the mad, mad world of php. I've got just a simple php SELECT and WHILE loop to ECHO contents of a MySQL database, but the first record does not appear! What one earth can be going on? Any suggestions greatly appreciated!

PHP Code:

<?php
mysql_connect("host", "name", "password") or die(mysql_error()); 
mysql_select_db("database") or die(mysql_error());
$query = "SELECT * FROM newsletter WHERE number='33' ORDER BY id";
$result = mysql_query($query) or die(mysql_error()); 
$row = mysql_fetch_array($result) or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
echo nl2br($row['headline']) . '<br>';
echo nl2br($row['story']) . '<br>';
}
?>

[midders]

$row = mysql_fetch_array($result) or die(mysql_error()); 
while($row = mysql_fetch_array( $result )) {

You are discarding the first row of the result with the first line above; just omit this and it will work fine.

Slainte

midders

[twmprys]

How silly of me! That's what great about this Tech Support Guy site - people are prepared to help you out with almost anything!

Go raibh maith agat!