No problem. I just prefer to use extract() for areas that are only
pulling out a single set of data, or several sets with different variable
names within the array. Less typing, no reassignments necessary. Personal
preference, that's all.
On 5/4/07, Dan Shirah <mrsquash2@xxxxxxxxx> wrote:
Thank you Daniel!!
I didn't do it exactly as you suggested, but you put me in exactly the
right direction! THANK YOU!
Below is how I have it working if anyone else is interested.
****The javascript****
function showAlert(id,type) {
alert( 'The type is:' + type + 'The ID is:' + id );
}
****The Form****
<?php
if(!empty($result_payments)) {
while ($row_payments = mssql_fetch_array($result_payments)) {
$id = $row_payments['child_support_id'];
$case_number = $row_payments['case_number'];
$payment_amount = $row_payments['payment_amount'];
$total += $row_payments['payment_amount'];
?>
<tr>
<td width="21">ID:</td>
<td width="88"><a href="javascript:showAlert('<?php echo $id;
?>','C')"><?php echo $id; ?></a></td>
<td width="98">Case Number:</td>
<td width="252"><?php echo $case_number; ?></td>
<td width="116"><div align="right">Payment Amount:</div></td>
<td width="105"><div align="right">$<?php echo
number_format($payment_amount, 2); ?></div></td>
</tr>
<?php
}
}
?>
thanks again.
On 5/4/07, Daniel Brown <parasane@xxxxxxxxx> wrote:
>
>
> I know you said it's a form.... but where does the browser realize
> that?
>
> Using a hidden value such as that would require a POST or GET action
> via a form. JavaScript wouldn't work for that. However, you could do
> something like this:
>
> <snip>
> <SCRIPT LANGUAGE="JavaScript">
> function showAlert(id,type) {
> alert('The type is:' + type + ' - The ID is:' + id);
> }
> </SCRIPT>
> <?
> while($row_payments = mssql_fetch_array($result_payments)) {
> extract($row_payments);
> $total += $payment_amount;
> ?>
> <tr>
> <td width="21">ID:</td>
> <td width="88"><a
> href="javascript:showAlert('<?=$child_support_id;?>','C')"><?=$child_support_id;?></a></td>
>
> <td width="98">Case Number:</td>
> <td width="252"><?=$case_number;?></td>
> <td width="116"><div align="right">Payment
> Amount:</div></td>
> <td width="105"><div
> align="right">$<?=number_format($payment_amount,2);?></div></td>
> </tr>
> <?
> </snip>
>
> If 'C' isn't a constant, but rather a dynamic value from a column in
> a database (named the same as the convention in your example suggests), then
> simply modify it as such:
> <td width="88"><a
> href="javascript:showAlert('<?=$child_support_id;?>','<?=$request_type;?>')"><?=$child_support_id;?></a></td>
>
> That should do it for you.
>
>
> On 5/4/07, Dan Shirah < mrsquash2@xxxxxxxxx> wrote:
> >
> > Okay, I think this is a 1/2 PHP problem and 1/2 Javascript
> > problem. And I
> > think my Javascript problem is being caused by my PHP. Follow?
> >
> > The code below is a loop of records returned from my query:
> >
> > 1 - If the result is not empty it will loop through the results.
> > 2 - It assigns variables based on columns from the query.
> > 3 - The first column of the row is the ID which is used by the
> > Javascript to
> > pull up the correct record.
> > 4 - I put in a hidden value to assign all the rows in this loop a
> > "request_type" value.
> > 5 - When someone clicks on a record ID it calls the Javascript to
> > "alert"
> > the ID and request_type.
> > 6 - If the loop only returns a single record, the "alert" displays
> > correctly. Example: The type is:C The ID is:80
> > 7 - If the loop returns multiple records, the "alert" does not return
> > the
> > correct values.
> >
> > Example: The type is:undefined The ID is:80
> > The type is:undefined The ID is:85
> > The type is:undefined The ID is:104
> >
> > Why do I only get "undefined" if the loop returns more than a single
> > record???
> >
> > ***The Javascript***
> >
> > function showAlert(id) {
> > var type;
> > type = document.Submit.request_type.value
> >
> > alert( 'The type is:' + type + 'The ID is:' + id );
> > }
> >
> > ***The Form***
> >
> > <table align="center" border="0" cellpadding="0" cellspacing="0"
> > width="680">
> > <?php
> > if(!empty($result_payments)) {
> > while ($row_payments = mssql_fetch_array($result_payments)) {
> > $id = $row_payments['child_support_id'];
> > $case_number = $row_payments['case_number'];
> > $payment_amount = $row_payments['payment_amount'];
> > $total += $row_payments['payment_amount'];
> > ?>
> >
> > <tr>
> > <td width="21">ID:</td>
> > <td width="88"><?php echo "<a
> > href='javascript:showAlert($id)'>$id</a>"
> > ?></td>
> > <td width="98">Case Number:</td>
> > <td width="252"><?php echo $case_number; ?></td>
> > <td width="116"><div align="right">Payment Amount:</div></td>
> > <td width="105"><div align="right">$<?php echo
> > number_format($payment_amount, 2); ?></div></td>
> > <input type="hidden" name="request_type" value="C">
> > </tr>
> >
> > <?php
> > }
> > }
> > ?>
> > </table>
> >
> --
> Daniel P. Brown
> [office] (570-) 587-7080 Ext. 272
> [mobile] (570-) 766-8107
--
Daniel P. Brown
[office] (570-) 587-7080 Ext. 272
[mobile] (570-) 766-8107
