select the smallest and largest number in file.

[netrepsa]

I have to select the smallest and largest number from a MYSQL table and use it to generate a random number $viewthis.

How do I get the $min value?

<?php

// select smalest and largest num in list

$result = mysql_query("SELECT * FROM photolist WHERE clas='AD'",$db);

while ($myrow = mysql_fetch_array($result)) {
     $min = $myrow['num'];

     }

$max = $myrow['num'];
$viewthis = rand($min,$max);

?> 😕

[devinemke]

if you want to grab a random record from your table:

SELECT * FROM photolist WHERE clas='AD' ORDER BY RAND() LIMIT 1

if you want the min and max "num" fields (i'm guessing that is your primary key field):

SELECT MIN(num) AS min, MAX(num) AS max FROM photolist WHERE clas='AD'

[drawmack]

Is it from a file or from a database? You topic says it's a file and your code says it's a database. How can we be expected to answer you when you're not even clear in the question?

Anyway:
From a text file

<?php
$numbers = file('filename.txt');
array_sort($numbers);
$min = trim($numbers[0]);
$max = trim($number[count($numbers)-1]);
?>

From a mysql database

<?php
$sql = "SELECT num FROM photolist ORDER BY num";
$query = mysql_query($sql);
$min = mysql_result($query,0,0);
$max = mysql_result($query,0,(mysql_num_rows($query)-1);
?>