Displaying results from mySQL database

[nortksi]

Hi guys, I'm hoping someone can help me with little problem I'm having 'echo'ing results retrieved from a mySQL database.

 

I know there are 4 results being returned but my code only displays 3 of them.  Any ideas, it's probably really simple but I am just leaning.

My code is below:

 

               <?php        

                $rt=mysql_query($query);
	echo mysql_error();

	$nt=mysql_fetch_array($rt);

	$results=@mysql_num_rows($rt);

	if ($results > 0) {
			for ($ii = 0; $ii < $results; $ii++){
				$data = mysql_fetch_array($rt); 
				$dr [] = $data;
			}
		}

	if ($results > 1) {
		for ($ii = 0; $ii < $results; $ii++){
			echo $dr[$ii]['event_name'];?><br /><?php
          		}
	}else {}
              ?>

 

Thanks in advance! 

 

Mark.

 

[nortksi]

I forgot to mention that it is the first result not being displayed.

 

Regards,

Mark.

[WebStyles]

You seem to be confusing a lot of things. keep it simple.

 

<?php        
$rt=mysql_query($query);
while($data = mysql_fetch_assoc($rt)){
$dr[] = $data;
echo $data['event_name'] .'<br />';
}
?>

[nortksi]

Hi WebStyles,  thanks for the reply, and tip.

 

However; it still only displays 3 out of the 4 results, again it is the first result in the mySQL database that isn't being displayed.

 

Regards,

Mark.

[@]

any chance the event name for the first row is empty? otherwise id say the issues is in your query.

[WebStyles]

instead of this line:

 

echo $data['event_name'] .'<br />';

 

try this:

echo trim($data['event_name']) != '' ? $data['event_name'] .'<br />' : 'Database contains empty event name here<br />' ;

[nortksi]

any chance the event name for the first row is empty? otherwise id say the issues is in your query.

 

Hi.  The first row is not empty.  This has really confused me as I know 4 results have been retrieved from the database because I tested it by echoing $results which displayed 4.

 

I have to be careful what I write on here as I'm signed into a non-disclosure agreement so I don't know how much of the code I can put on here.

 

Kind regards,

Mark.

[nortksi]

instead of this line:

 

echo $data['event_name'] .'<br />';

 

try this:

echo trim($data['event_name']) != '' ? $data['event_name'] .'<br />' : 'Database contains empty event name here<br />' ;

 

Hi,

 

OK I tried this, exactly the same result

 

Thx

Mark.

[WebStyles]

what's in $query ? are you doing a JOIN of some sorts ? (please post the rest of the code)

[PFMaBiSmAd]

Your original code contained an extra $nt=mysql_fetch_array($rt); statement that was fetching and discarding the first row from the result set. Even though WebStyles posted a much simplified and commonly used way of executing a query and looping over the result set, I doubt that you changed all your code to use just those lines of code.

 

Post your current code, from the line where you are executing the query through to the end of the loop you are using to iterate over the result set.

[nortksi]

Thanks for you help guys, I finished work early today and wont be back in until Monday morning.  I'll get onto your suggestions first thing monday morning and I'll post the results.

 

Thx again guys.

 

Mark.

[nortksi]

Your original code contained an extra $nt=mysql_fetch_array($rt); statement that was fetching and discarding the first row from the result set.

 

OK I couldn't resist, I took my work home and tried removing one of the $nt=mysql_fetch_array($rt); and this did the trick!  Thanks PFMaBiSmAd and everyone else for their help, much appreciated

 

If you get time, PFMaBiSmAd, will you be able to explain why having 2 arrays would dicard the first row?

 

Kind regards,

Mark.

[PFMaBiSmAd]

There's nothing to explain. You are calling a mysql_fetch_ statement before the start of your loop, so of course the first row in the result set is missing. It has already been fetched.

 

Computers only do exactly what their code tells them to do.