Hello,
I'm getting confused with the array.I did them separately and it is working fine.will somebody pls help me to combine these two programs:
Handset.php
if ($HTTP_POST_VARS){
$cnt = count($HTTP_POST_VARS['id']);
for($cntr=0;$cntr<$cnt;$cntr++) {
UPDATE STATEMENT followed by ibase_query
select statement
Field headings
<?php
$counter=0;
$old_values=null;
While statement to fetch all the fields
?>
Here all the form fields(array)
<?php
$old_values.=' <input type="hidden" name="id['.$counter.']" value="'.$row->HS_ID.'">
';
$counter++;
}
?>
</table>
<?=$old_values?>
STIM.PHP
if ($HTTP_POST_VARS){
$cnt = count($HTTP_POST_VARS['id']);
for($cntr=0;$cntr<$cnt;$cntr++) {
UPDATE STATEMENT followed by ibase_query
select statement
Field headings
<?php
$counter=0;
$old_values=null;
While statement to fetch all the fields
?>
Here all the form fields(array)
<?php
$old_values.=' <input type="hidden" name="id['.$counter.']" value="'.$row->STIM_ID.'">
';
$counter++;
}
?>
</table>
<?=$old_values?>
My doubt is only with $old_values.=
because in each program, i used $row->......_ID
How can i set two id filelds(HS_ID, STIM_ID) in one step?
and the second is, how should my select statement should be??
I think the following is correct one:
$sql= 'select field1, field2 and so on ... from TBL1 inner join TBL2 on TBL1.id = TBL2.id;
I would be really greatful to somebody who can insert my code in the right way.
Thanking you in advance.