shamsidah

hello everyone, i have a problem where i cannot run a php application in the IE. when i run, all the interface not displayed and function. is it true, i need to change the setting at internet option or else...

[CODE]<form id="form1" name="form1" method="post" action="updatebodyNo.php"> <table width="356" border="0" align="center"> <tr> <td width="94"><span class="style12"><span class="style12 style57">BodyNo</span></span></td> <td width="155"><span class="style12"><span class="style12 style57">Defect Code</span></span></td> <td width="93"><span class="style12"><span class="style12 style57">Quantity</span></span></td> </tr> <tr> <?php include ("connection.php"); // get value of id that sent from address bar $bodyNo=$_GET['bodyNo']; $sq1 = mysql_query ("SELECT * FROM paintshop WHERE …

[CODE]<form method="POST" action="prosesMultiple.php"> <?php include 'connection.php'; $sql="SELECT defect_code,totalDaily FROM grandTotal ORDER BY totalDaily DESC LIMIT 10 "; $row = mysql_query ($sql); while ($check=mysql_fetch_array($row)){?> <input type="checkbox" name="defect_code[]" id="defect_code[]" value="<?php echo $check["defect_code"];?>" /> <?php echo $check["defect_code"];?> - <?php echo $check["totalDaily"]; ?> <input name="text" name="totalDaily[]" id="totalDaily[]" type="hidden" value="<?php echo $check["totalDaily"]; ?>"><br/> <?php } …

[CODE]<?php include 'connection.php'; $data = mysql_query( "SELECT Date,color_code, COUNT(color_code) FROM paintshop WHERE Date BETWEEN '$startDate' AND '$endDate'") or die('error'); while($rw = mysql_fetch_array($data)){ ?> <td width="59" height="25" class="style5Copy"><?php echo $rw['Date']; }?></td>[/CODE] i want display the dates between i post from the form.. eg: start date = 1-12-2011 until end date 7-12-2011 …

hello... i have a question about my final year project.. in my database i want to find 5 maximum values from total of defects from car's body... and the data that i'm found must valid for one year, and after one year (next year) maybe the 5 max values may …

hye.. i have a problem to display only numbers of date according the month automatically. I want to display in the table like this date 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17............31

sorry.. i want to try this coding..unfortunatelay when i run this codes, nothing was display and have syntax error..i try to identified that errors but failed..

[CODE]<?php include 'connection.php'; $qry = mysql_query( "SELECT g.totalDaily, p.COUNT(DISTINCT bodyNo) AS qty FROM grandTotal AS g, paintshop AS p ") or die('error'); while ($rows = mysql_fetch_array($qry)){ ?> <td><?php $dpu = $rows['g.totalDaily'] / $rows['qty']; echo $dpu;?></td> <?php } ?>[/CODE] i want to display the $dpu which is defect per unit..the information …

Hi.. I need some help. I have a problem to insert 2 values or variable from drop down list to database at the same time. i want to insert name_relation into db, at the same time want to insert IcNo into db. here my code: [CODE]<?php include ("ConnectDB.php"); ?> <select …

hello.. i have a table name [B]paintshop[/B] and have 4 fields for example [U][B]table:paintshop[/B][/U] bodyNo | defect_code | qty | date 58786859 | FM | 9 | 2011-11-29 58786859 | BB | 1 | 2011-11-29 58786859 | TN | 4 | 2011-11-29 58786860 | RN | 7 | 2011-11-29 58786851 …

Hi everyone. I'm new in php and need someone to help my problem. I have one table name [B]data_transaction[/B], from this table i'm want to search data between two dates that user key in. Here my code, $sum = "SELECT * , SUM(trans_charges) FROM data_transaction WHERE Location = 'HA1' AND …

hye everyone..i just want to share my problem using php..:$ i have data for field [B]total[/B] i.e total = (2,3,4,5,62,45,67,89,10,23,11,23,98,12) from all data i want 5 max values only. please help me to meet the solution.:)

[U]Table's name: grandTotal[/U] (have two fields :defect_code and total) defect_code total LM 23 FM 15 DF 5 How this data can be an array like this array("LM" >=23, "FM">=15,"DF">=5) using query? please help me..:S