for and if for a table?

houston08

Ok, I'm stuck.
Here is what I'm trying to do.
I have a max of 10 entries, but going by increments of 2. Let me explain, I have Checks, and then I have Date when the Check was recieved. so, each one of those will be in one row, for a maximum of 5 rows in a table. I want only the needed rows to show up. So if I should only have 2 rows, I don't want the other 3 to show. If I have 4 rows I don't want the other 1 to show, etc. I think I can do this with a != 0 with an if statement as you see below, here is my code:

$checks =
for ($i= 0; $i<6; $i++)
{ if ($row[priorcheck$i] != 0) {
{ echo "
<tr>
<td align=\"center\">\$number_format($row[priorcheck$i])</td>
<td align=\"center\">($row[priorcheckdate$i]</td>
<tr>";
} } ;

Now, I'm sure that isn't completely right, but, I hope I'm close.

It's supposed to be something like...

| $112,286,338 | 11/06/05 |
I
hope you understand what I mean by that. I also have an error, but that is probably from the code no being right.

"Parse error: parse error, unexpected T_FOR in C:\Program Files\xampp\htdocs\results.php on line 27"

Line 27 is the for:
"for ($i= 0; $i<6; $i++)"

so, how can I fix my code? I don't see what I'm missing.
Thanks!

jignesh1

i dont think u could assign the loop to the variable

$checks = 
for ($i= 0; $i<6; $i++) 
{ if ($row[priorcheck$i] != 0) { 
{ echo " 
<tr> 
<td align=\"center\">\$number_format($row[priorcheck$i])</td> 
<td align=\"center\">($row[priorcheckdate$i]</td> 
<tr>"; 
} } ;

but u could do is

for ($i = 0; $i < 6; $i++){
     if{$row[priorchecks$i] != 0){
            $checks = "<tr>"
            $checks .= "<td align=\"center\">\$number_format($row[priorcheck$i])</td>";
            $checks .= "<td align=\"center\">($row[priorcheckdate$i]</td>";
            $checks .= "</tr>";
      }
}

houston08

that looks as though it would work better.
I tried it, but now I have this error:

"Parse error: parse error, unexpected T_VARIABLE in C:\Program Files\xampp\htdocs\results.php on line 27"

Line 27 is:
" if($row[priorchecks$i] != 0){"

What could it be?

jignesh1

try this
if($row[priorchecks . $i ] != 0)

houston08

that helped, so I applied it to the rest that used similar.

for ($i = 0; $i < 6; $i++){
     if($row[priorchecks . $i ] != 0){
            $checks = "<tr>"
            $checks .= "<td align=\"center\">\$number_format($row[priorcheck . $i ])</td>";
            $checks .= "<td align=\"center\">($row[priorcheckdate . $i]</td>";
            $checks .= "</tr>";
      }
}

New Error:
"Parse error: parse error, unexpected T_VARIABLE in C:\Program Files\xampp\htdocs\results.php on line 29"

Line 28 & 29:

            $checks = "<tr>"
            $checks .= "<td align=\"center\">\$number_format($row[priorcheck . $i ])</td>";

What do you think?

jignesh1

i think u r trying ot arrray the $row['priorcheck'][$i]
or u trying to the concat the $row['priorcheck'] . $i

houston08

I don't understand the question, but niether one worked.

madwormer2

for ($i = 0; $i < 6; $i++){
     if($row['priorcheck' . $i ] != 0){
            $checks = "<tr>"
            $checks .= "<td align=\"center\">\$".number_format($row['priorcheck' . $i ])."</td>";
            $checks .= "<td align=\"center\">".$row['priorcheck' . $i ]."</td>";
            $checks .= "</tr>";
      }
}

houston08

same error as last time, nothing changed

madwormer2

Then rephrase the question so that it makes more sense.

houston08

Put this code in a txt pad and save as .htm
So you can see what I want, 😃

                                <html>
<head>
<title>Undecided</title>
</head>
<body>
<center>


<div align="center">

  <p align="left"><font size="7" face="Impact" color="#ff0000">
  <i>Undecided  </i></font></p>


<TABLE width="40%" BORDER="1" cellpadding="6" cellspacing="0">
  <tr>
    <td colspan="2" bgcolor="blue">
      <center><font color="white" size="5"><b>Contact:</b></font></center>
    </td>
  </tr>

  <tr>

<td width="50%">
  Contact:
</td>
<td width="50%">

John Doe

  </tr>

  <tr>
    <td>
      E-Mail:
    </td>

<td>

 email@aol.com

  </tr>

  <tr>
    <td>
      Location:
    </td>
    <td>

 City Name, State

  </tr>

  <tr>
    <td>
      Phone:
    </td>
    <td>
      555-555-5555
  </tr>


  <tr>
    <td>

  Asking Price:
</td>
<td>

 $0


</td>

  </tr>

  <tr>
    <td>

  Contact me By:
</td>
<td>

 You may contact me by phone or email.

  </tr>

<table border="0" width="500">
  <tr>
    <td colSpan="2">
      <center><b>Earnings</b></center>

</td>
</tr>
<tr>
<td width="250">
<center>Amount</center>
</td>
<td width="250">
<center>Date</center>
</td>
</tr>
<tr>
<td colSpan="2">
<center><i>(Most Recently Descending)</i></center>

</td>
</tr>
</table>

<table width="40%" BORDER="1" cellpadding="6" cellspacing="0">
<tr>
<td width="50%" align="center">$1,231</center></td>
<td width="50%" align="center">12/21/00</center></td>
</tr>



<tr>
<td align="center">$1,231,231</td>

<td align="center">03/30/98</td>
</tr>


<tr>
<td align="center">$93,312</td>
<td align="center">11/12/96</td>
</tr>

<tr>
<td align="center">$0</td>
<td align="center"></td>
</tr>

<tr>
<td align="center">$0</td>
<td align="center"></td>
</tr>

<tr>
<td align="center">$0</td>
<td align="center"></td>
</tr>


<tr>
<td></td>
<td></td>

</tr>

<tr>
<td align="center">Name:</td>
<td align="center">Land Name</td>
</tr>

<tr>
<td align="center">Location</td>
<td align="center">Location City, State</td>
</tr>


<tr>
<td align="center">Legal Discription:</td>
<td align="center"></td>

</tr>

</table>

</center>
</body>
</html>

You see how there are zeros under amount? I want it so that if there is a zero, then the row isn't displayed. Know what I mean?

madwormer2

Now, that's HALF of the question.

How is the data currently stored? Is it in an array structure like so:

Array(
0 => 50,
1 => 40,
2 => 45,
3 => 10
4 => 0,
5 => 0,
6 => 33
)

Or is it stored differently?

houston08

no, it's stored in a Database

coekrix

its easy, because after
line 28: $checks = "<tr>"
line 29: $checks .= "<td align=\"center\">\$number_format($row[priorcheck . $i ])</td>";
in line 28 command you doesn't close with ";"

madwormer2

^ Even if he does that, it probably won't do what he wants it to do.

How are you retrieving it then? When you ask a question, you need to give all the relevant information.

We can't help you display it if we don't know how the data is stored and retrieved.

It's like trying to build a house without any materials. 😛

houston08

Well, lets see if I can explain better, I'm never good at it..

1st, a customer would input data using javascript. The script would pass it to a php file where it would then store the info in a database.
2nd, a customer would want to pull up the information. So, they go to the results page, the one I'm working on, and it pulls up the data of their choice, according to the ID. The ID isn't important though.

The data displayed is just like that in the sample file I posted above.

The data is retrieved in the results.php file, using $query = "SELECT auto_id, name_first, name_last, email, mostrecentcheck, mostrecentdate, priorcheck1, priorcheckdate1, priorcheck2, etc......

there are 5 priorchecks in the database, and 5 priorcheckdates, and one from each is taken to match each other. That might be confusing, but I don't know how to explain it. Usually priorchecks and priorcheckdates 1 and 2 will have stuff, or they won't, in either case, if they don't have anything priorchecks will have a value of 0. If any of the priorchecks equal 0, I don't want them to be showed. I hope that helped, otherwise, I'll get a friend to type what I'm trying to do. Thanks!