Forum PHP.pl

[SQL] pobierz, plaintext 
SELECT `quotes`.* FROM `quotes` ORDER BY RAND() LIMIT 1
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT tag_name, tag_amount, MIN(tag_amount), MAX(tag_amount) FROM `mybb_stcp` WHERE tag_name IN(
  SELECT `tag_name` FROM `mybb_stcp` ORDER BY RAND()
) LIMIT 10
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT tag_name, tag_amount, MIN(tag_amount), MAX(tag_amount) FROM `mybb_stcp` WHERE tag_name IN(
  SELECT `tag_name` FROM `mybb_stcp` ORDER BY RAND()
) LIMIT 10 GROUP BY tag_name
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT tag_name, tag_amount, MIN(tag_amount), MAX(tag_amount) FROM `mybb_stcp`
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT tag_name, tag_amount FROM `mybb_stcp` WHERE  tag_name != '' ORDER BY tag_amount DESC RAND() LIMIT 10
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
$maxValue = 0;
$minValue = 0;
$maxRecord = null;
$minRecord = null;
$output = '<ul>';
 
while($nextRow)
{
	if($nextRow['value'] > $maxValue)
	{
		$maxValue = $nextRow['value'];
		$maxRecord = $nextRow;
	}
 
	if($nextRow['value'] < $minValue)
	{
		$minValue = $nextRow['value'];
		$minRecord = $nextRow;
	}
 
	$output .= '<li>'.$nextRow['tag_name'].'</li>';
}
 
$output .= '</ul>';
[PHP] pobierz, plaintext 

Cytat(zend @ 26.03.2010, 22:16:42 )

[SQL] pobierz, plaintext 
SELECT tag_name, tag_amount FROM `mybb_stcp` WHERE  tag_name != '' ORDER BY tag_amount DESC RAND() LIMIT 10
[SQL] pobierz, plaintext 

Cytat(Watt @ 26.03.2010, 22:08:08 )

[SQL] pobierz, plaintext 
SELECT tag_name, tag_amount FROM mybb_stcp WHERE tag_name != '' AND (tag_amount=(SELECT MIN(tag_amount) FROM (SELECT tag_name, tag_amount FROM mybb_stpc ORDER BY RAND() LIMIT 4) AS temp) OR  tag_amount=(SELECT MAX(tag_amount) FROM (SELECT tag_name, tag_amount FROM mybb_stcp ORDER BY RAND() LIMIT 4) AS temp)) ORDER BY tag_amount
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT tag_name, tag_amount FROM (SELECT * FROM mybb_stcp WHERE tag_name != '' ORDER BY RAND() LIMIT 4) AS temp ORDER BY tag_amount
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
	$stcp_query = $db->query("SELECT tag_name, tag_amount FROM mybb_stcp WHERE tag_name != '' AND (tag_amount=(SELECT MIN(tag_amount) FROM (SELECT tag_name, tag_amount FROM mybb_stcp ORDER BY RAND() LIMIT 4) AS temp) OR  tag_amount=(SELECT MAX(tag_amount) FROM (SELECT tag_name, tag_amount FROM mybb_stcp ORDER BY RAND() LIMIT 4) AS temp)) ORDER BY tag_amount") or die(':<');
	while($stcp_fetch = $db->fetch_array($stcp_query))
	{
 
			$tag = $stcp_fetch['tag_name'];
			$tagsiz = $stcp_fetch['tag_amount'];
			$max_tagsize = $stcp_fetch['MAX(tag_amount)'];
			$min_tagsize = $stcp_fetch['MIN(tag_amount)'];
			echo $tag." ".$tagsiz."<br />";
       }
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT tag_name, tag_amount FROM `mybb_stcp` WHERE tag_name != '' ORDER BY tag_amount RAND() LIMIT 10
[SQL] pobierz, plaintext