generating sequential numbers

[wkilc]

Hi folks,

I have been Googling for the past few hours with no real luck, and then stumbled upon your forum. I'm rather new at PHP... here goes:

I have PHP page that displays records from a MySQL database. I plan on using the page to submit a form... I can get it to work, but the problem is I need to modify the code so that the records are numbered so they can be properly passed through the form.

The source code looks something like this:

print "<tr><td><input type=text name='NameXXX' size=27 value='$name'</td><td><input type=text name='SchoolXXX' size=27 value='$name'</td></tr>";

But I need he XXX would be replaced by 1 and then 2 and then 3, etc:

<tr><td><input type=text name='Name1' size=27 value='$name'</td><td><input type=text name='School1' size=27 value='$name'</td></tr>
<tr><td><input type=text name='Name2' size=27 value='$name'</td><td><input type=text name='School2' size=27 value='$name'</td></tr>

Thanks very much... and please go slow... ;-)

~Wayne

[Mordecai]

$XXX = 1; // $XXX = 1
$XXX ++; // $XXX = 2
$XXX += 1; // $XXX = 3;
$XXX = $XXX +1; // $XXX = 4;

[tommynanda]

You may want to use arrays here.. change your code to this

<tr><td><input type=text name='Name[]' size=27 value='$name'</td><td><input type=text name='School[]' size=27 value='$name'</td></tr> 
<tr><td><input type=text name='Name[]' size=27 value='$name'</td><td><input type=text name='School[]
' size=27 value='$name'</td></tr> 

Name[1] stores 1st name
Name[2] stores 2nd.... and so on

Good Luck
TommYNandA

[wkilc]

Thank you very much... sorry, but I cannot get either of these solutions to work, likely my own fault.

I added this code:

$XXX = 1; // $XXX = 1
$XXX ++; // $XXX = 2
$XXX += 1; // $XXX = 3;
$XXX = $XXX +1; // $XXX = 4;

and then replaced the PHP source to read:

print "<tr><td><input type=text name='Name$XXX' size=27 value='$name'</td><td><input type=text name='School$XXX' size=27 value='$name'</td></tr>";

and the page it rendered simply names everything "4"... Name4, School4, all right down the line for every record.

As for using arrays, I must be missing a step or two... I only have one line of code in the PHP:

print "<tr><td><input type=text name='NameXXX' size=27 value='$name'</td><td><input type=text name='SchoolXXX' size=27 value='$name'</td></tr>";

... and it generates as many table rows as there are records, and if I change this line to:

print "<tr><td><input type=text name='Name[]' size=27 value='$name'</td><td><input type=text name='School[]' size=27 value='$name'</td></tr>";

... doesn't yield the desired results... there's got to be another step or two here, but I don't know enough to make it work.

Sorry, although I know HTML pretty well, programing with PHP is virgin territority for me! (I just bought the "for Dummies" book.)

Thank you again!

~Wayne :bemused:

[tommynanda]

Okay lets take Mordecai's example further

<?
for($XXX=1;$XXX<=4;$XXX++)
{
print "<tr><td><input type=text name='Name$XXX' size=27 value='$name'</td><td><input type=text name='School$XXX' size=27 value='$name'</td></tr>";
}
?>

This generates 4x2 different fields with Name1, Name2..and so on

This is wat Mordecai meant... This is a cool and easy way of doing it

And the second way I am talking about is similar to this but using arrays... Use Mordecai's idea... That should do the job...

Good Luck
TommYNandA

[wkilc]

Thank you again... I tried to use it, but I'm creating an error somewhere. The line "for($XXX=1;$XXX<=4;$XXX+)" was giving me a "parse error" unexpected "(". I commented it the three new lines I had added.

<? $query =
"SELECT allstate03.name,allstate03.school,allstate03.category,allstate03.division,allstate03.rank,allstate03.status
FROM allstate03
WHERE ((allstate03.name LIKE '$name%')
and (allstate03.school LIKE '$school%')
and (allstate03.category LIKE '$category%')
and (allstate03.division LIKE '$division%')
and (allstate03.rank LIKE '$rank%')
and (allstate03.status LIKE '$status%')
and (allstate03.status NOT LIKE 'NA'))

    ORDER BY allstate03.$sort";

$resultt = mysql_query($query);

// Determine the number of students
$number = mysql_num_rows($resultt);

if ($number == 0) {
print "Sorry, there were no records matching those criteria";
} else {
while ($row = mysql_fetch_object($resultt)) {
$name=$row->name;
$school=$row->school;
$category=$row->category;
$division=$row->division;
$rank=$row->rank;
$status=$row->status;

// for($XXX=1;$XXX<=4;$XXX+)

// {

print "<tr><td><input type=text name='Name$XXX' size=27 value='$name'></td> <td><input type=text name='School$XXX' size=27 value='$school'</td> <td><input type=text name='Category$XXX' size=24 value='$category'</td> <td><input type=text name='Division$XXX' size=6 value='$division'></td> <td><input type=text name='Rank$XXX' size=4 value='$rank'></td><td><input type=text name='Status$XXX' size=6 value='$status'></td><td><input type=text name='Participating$XXX' size='6'></td></tr>";
// }

}
}

// Close the databaas connection
mysql_close();

?>

Also... when I created a test PHP file with only this code:

<? 
for($XXX=1;$XXX<=4;$XXX+) 
{ 
print "<tr><td><input type=text name='Name$XXX' size=27 value='$name'</td><td><input type=text name='School$XXX' size=27 value='$name'</td></tr>"; 
} 
?> 

I recieved the same error.

Thanks.

~Wayne

[tommynanda]

Oops... typo 😃 add + sign after $XXX+ ... Check my previous post...edited

TommYNandA

[tommynanda]

To fit this into your code...

<? $query = 
        "SELECT allstate03.name,allstate03.school,allstate03.category,allstate03.division,allstate03.rank,allstate03.status 
        FROM allstate03 
        WHERE ((allstate03.name LIKE '$name%') 
              and (allstate03.school LIKE '$school%') 
      and (allstate03.category LIKE '$category%') 
   and (allstate03.division LIKE '$division%') 
   and (allstate03.rank LIKE '$rank%') 
   and (allstate03.status LIKE '$status%') 
   and (allstate03.status NOT LIKE 'NA')) 

    ORDER BY allstate03.$sort"; 
$resultt = mysql_query($query); 


// Determine the number of students 
$number = mysql_num_rows($resultt); 

$XXX = 1;
if ($number == 0) { 
   print "Sorry, there were no records matching those criteria"; 
} else { 
while ($row = mysql_fetch_object($resultt)) { 
    $name=$row->name; 
    $school=$row->school; 
    $category=$row->category; 
    $division=$row->division; 
    $rank=$row->rank; 
    $status=$row->status; 




print "<tr><td><input type=text name='Name$XXX' size=27 value='$name'></td> <td><input type=text name='School$XXX' size=27 value='$school'</td> <td><input type=text name='Category$XXX' size=24 value='$category'</td> <td><input type=text name='Division$XXX' size=6 value='$division'></td> <td><input type=text name='Rank$XXX' size=4 value='$rank'></td><td><input type=text name='Status$XXX' size=6 value='$status'></td><td><input type=text name='Participating$XXX' size='6'></td></tr>"; 
$XXX++; 
    } 
} 

// Close the databaas connection 
mysql_close(); 

?>

This will be your altered code

Have Fun!
TommYNandA

[TheDefender]

OK, I am going to change things up on you here...
If you know how many you want, you could define a range() and use that...

<?php
echo "<table>";
$name="John Doe";
$School="USC";
$range = range(1, 20);
FOREACH($range AS $v){
echo "<tr><td><input type=\"text\" name=\"Name".$v."\" size=\"27\" value=\"".$name."\"></td><td><input type=\"text\" name=\"School".$v."\" size=\"27\" value=\"".$School."\"></td></tr>";
}
echo "</table>";
?>

[wkilc]

Aha! Thank you. Now it's working like it's supposed to.. only it's displaying 4 of each record. Instead of four records (kids) in four rows... its displaying each kid four times.

That might be my problem. I don't know how many records each page will display... depending on which teacher is filtering the database... it could display anywhere from 1 to 75 student records. This worked fine before I tried to add the auto-generated numbers.

Thanks... sorry to be a pain.:queasy:

~Wayne

p.s. why is this forum page getting wider? Did I screw up?

[wkilc]

I just pasted in Tommy's code (which I missed before) and it looks good!

THANK YOU! You rock dude!

I'm going to test it out and then close this thread!

~Wayne

[wkilc]

Before I resolve this thread... in an effort to make the table slimmer... if my database has records for "school"... but in this case all the dispayed records would show the same exact school in each row, so it seems a waste to put the same school in the table in each and every row. I'd like to remove '$schools' from the table and insert just once in a field above the table:

if i add:

print "School: $school<br>"

it prints the result anywhere from 1 to 75 times, just as it would in the table.

I'm sure there is a very simple answer to make it print just once... please pardon my ignorance. 😉

Thanks again.

~Wayne

[tommynanda]

From what I understood... you dont want to repeat school field if its the same
Here is a modified version of ur code

<? $query =  

        "SELECT allstate03.name,allstate03.school,allstate03.category,allstate03.division,allstate03.rank,allstate03.status  

        FROM allstate03  

        WHERE ((allstate03.name LIKE '$name%') 
              and (allstate03.school LIKE '$school%') 
      and (allstate03.category LIKE '$category%') 
   and (allstate03.division LIKE '$division%') 
   and (allstate03.rank LIKE '$rank%') 
   and (allstate03.status LIKE '$status%') 
   and (allstate03.status NOT LIKE 'NA')) 

    ORDER BY allstate03.$sort";  
$resultt = mysql_query($query);  


// Determine the number of students 
$number = mysql_num_rows($resultt);  

$pschool = NULL;  // Previous School
$XXX = 1; 
$SXXX = 1;  // School ID
if ($number == 0) {  

   print "Sorry, there were no records matching those criteria";  

} else {  

while ($row = mysql_fetch_object($resultt)) {  

    $name=$row->name;  

    $school=$row->school;  

    $category=$row->category;  

    $division=$row->division;  

    $rank=$row->rank;  

    $status=$row->status;  

if($pschool!=$school)  // If its different from previous school
{
print "<tr><td><input type=text name='School$SXXX' size=27 value='$school'</td></tr>";
$SXXX++;
$pschool = $school;
}


print "<tr><td><input type=text name='Name$XXX' size=27 value='$name'></td>  <td><input type=text name='Category$XXX' size=24 value='$category'</td> <td><input type=text name='Division$XXX' size=6 value='$division'></td> <td><input type=text name='Rank$XXX' size=4 value='$rank'></td><td><input type=text name='Status$XXX' size=6 value='$status'></td><td><input type=text name='Participating$XXX' size='6'></td></tr>";  

$XXX++;  

    }  

}  

// Close the databaas connection 
mysql_close();  

?>

Note additional variables,

On a side note: you may want to look at RDBMS concept...

Good Luck
TommYNandA