Set amount

[leeh14]

Hi,

 

Right I have a 'while loop' getting data from the mysql database, but what I want to do is once the loop has retrieved 4 data sets function stops running.

 

How is this done?

 

 

[kenrbnsn]

Please post your current code.

 

Ken

[leeh14]

So yeah i want the while to run 4 times then stop?

 

	$query = "select * from videos"; 

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

		$tit_1 = $row["title"];
		$des_1 = $row["des"];
		$len_1 = $row["length"];
		$url_1 = $row["URL"];
		$img_1 = $row["image"];
		$sli_1 = $row["slider"];
		$del = $row["ID"];	

		echo "<li><a href='$page?\"?goto=true&id=".$del."'><img src='Tutorials/slider_thumbnails/$sli_1' width = '960px' height='400px' alt='CssTemplate Preview' /></a></li>";
	}
			?>

[leeh14]

Is there an answer out there??

[Joshua4550]

Like so?

$query = "select * from videos LIMIT 4";

[leeh14]

Thank you kindly! Works a charm!

[Joshua4550]

No problemo. Please mark the topic as solved.

[leeh14]

One more thing however, if i wanted to get the last 4 data sets from the data (e.g the ones with the highest ID number) how would i do that?

 

 

[Psycho]

A field for date added would be better than using the ID, but with what you have:

 

//First four
$query = "SELECT * FROM videos ORDER BY ID ASC LIMIT 4";

//Last four
$query = "SELECT * FROM videos ORDER BY ID DESC LIMIT 4";

 

Of course the last four will be in reverse order. If you need them in ascending order I think this will do it

 

//Last four in ascending order
$query = "SELECT *
          FROM (SELECT * FROM videos ORDER BY ID DESC LIMIT 4)
          ORDER BY ID ASC";

[Joshua4550]

What he said.

 

But also like he said, you may want to make it a date - best in milliseconds, so when you insert into mySQL:

microtime()

[leeh14]

Another one solved this forum is amazing !!