madolia
-
Posts
3 -
Joined
-
Last visited
Never
Posts posted by madolia
-
-
I've been trying to solve this problem but I can't.
I hv two seperate tables A and B.
TABLE A
[table][tr][td]ID[/td][td]ticketNO[/td][td]ProgramID[/td][td]Approval[/td][/tr]
[tr][td]1[/td][td]41[/td][td]ABC124[/td][td]Approved[/td][/tr]
[tr][td]2[/td][td]41[/td][td]GHJ489[/td][td]Approved[/td][/tr]
[/table]
TABLE B
[table][tr][td]ProgramID[/td][td]Description[/td][td]OwnerID[/td][/tr]
[tr][td]ABC124[/td][td]Swimming[/td][td]N77893987T[/td][/tr]
[tr][td]GHJ489[/td][td]Cycling[/td][td]N35267141H[/td][/tr]
[/table]
I have two select queries which I need to use cos I have to look up the tables based on the [b]ticketNO[/b] and [b]OwnerID[/b].
1) Select * from TABLE A where ticketNO="41" and ProgramID="ABC124";
2) Select * from TABLE B where ProgramID="ABC124" and OwnerID="N77893987T";
I do not know how to combine this query so that I can retrieve the datas using PHP and use it in my program. NOTE : There can be the same ticketNO with different ProgramID. -
I have this code which genetares radio buttons using a loop with $i the variable. what i want to do is to create another "select all" button so that when a user clicks, it automatically selects all either approved or reject radio buttons. How to do that?
[code]if(($rowPS["STATUS"] == "") && ($rowLAST["OWNER"] == "-"))
{
echo"
<td align=center><input type=radio name=appr[$i] value='Approved' style=background:#FFFFFF></td>
<td align=center><input type=radio name=appr[$i] value='Rejected' style=background:#FFFFFF></td>";
}
<td colspan=6 align=center>Approve All Request ? <input type='checkbox' name='a1r1' value='Yes' style=background:#FFFFFF onClick='yesALL()';>Yes</td>[/code]
script to automatically replace variable name in all files in a directory
in PHP Coding Help
Posted
i have a directory with about 25 php files. instead of manually changing one by one, is there anyone who knows how to generate a script which could open each file, search for the variable name and replace it with the new one and save the script.
kindly advice.
thanx