Making a list

leodirk

Ok, basically I have a database that has users, and the users have fields linked to them with IDs that go from 1-100. I want to make a page that lists the name of the field in ID order, and if any range of the numbers 1-100 are not used for that persons list, to display something like "empty". I don't really have much to post to show you what I have done. All I got so far was it to list the items.

halojoy

hi
post that little bit of code you have got
and somebody will add what it takes
to make list what ID-s are not taken

I want to make a page
that lists the name of the field in ID order,
and if any range of the numbers 1-100 are not used for that persons list,
to display something like "empty".

leodirk

<?php
SQL login here


$sql="SELECT * FROM $tbl_name ORDER BY id ASC";
$result=mysql_query($sql);

while($rows=mysql_fetch_array($result)){
if ($rows['id'] > 0){
echo $rows['name'];
echo "<br>";
}
}

mysql_close();
?>

Since the IDs go below 0, but not above 100 and all I want is 1-100 that is how I got it to display it.

halojoy

this code I post

Suppose you have ONLY one Record for each ID-number
'id' is a so called UNIQUE KEY
If so, I think this will work very well, but have NOT tested it ....
There might be some little detail I have overlooked
when quickly writing this php code.
🙂
halojoy

<?php
//SQL login here

// We only SELECT id + name, 
// Only PULL from DB what we need from each result row
// This way we put as little work, stress, on DB as possible
// Makes a bit faster script

$sql="SELECT id, name FROM $tbl_name ORDER BY id ASC";
$result = mysql_query($sql);

$hits = array(); // To collect any hit
while($row = mysql_fetch_array($result)){
    //Equal to: $hits[id] = $row
    $hits[$row['id']] = $row; // each row id+name
}

mysql_close();

// We now have CLOSED MySQL and can use the DATA array $hits

// LOOP 1-100
for( $i=1; $i<=100; $i++ ){
    echo $i . '. ';

if( isset( $hits[$i] ) ){
    //echo $hits[$i]['id']  not needed
    echo $hits[$i]['name'];
}
else
{
    echo 'available!';    
}

echo "<br />\n";    
}

exit(); 

?>

leodirk

Worked perfectly, thanks man.

classix16

how about this:
in sql syntax use:
"SELECT id, name FROM $tbl_name where (id between '1' and '100') ORDER BY id ASC"

halojoy

classix16, may have the smart solution here
but before reading
I was thinking
about

LIMIT 1,100

/halojoy