Posts by Shanti C Page 7

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: sample code needed to auto update price when form field value are changed

try this:
and change according to your requirement.

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<script type="text/javascript">
function changeValue(x)
{
	var divEls = document.getElementsByTagName("div");
	var i = 0;
	
	for(i=0;i<divEls.length;i++)
	{
	divID=divEls[i].id;
	//alert(divID);
	//alert(x);
	if(divID == x)
		document.getElementById(divID).style.visibility = "visible";
	else
		document.getElementById(divID).style.visibility = "hidden";
	}
}
</script>
</head>
<body>
<select name="htmlcombo" id="htmlcombo" onChange="changeValue(this.value);">
 <option  value="0">Select</option>
    <option  value="1">Display Text1</option>
    <option  value="2">Display Text2</option>
    <option  value="3">Display Text3</option>
</select>

<div id="1" style="visibility:hidden" >hello1</div>
<div id="2" style="visibility:hidden">hello2</div>
<div id="3" style="visibility:hidden">hello3</div>
</body>
</html>

Web Development javascript

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Entry in database is 0

correct this line like:

tbl_sql="INSERT INTO tbl_user_post_requirement(user_id,verb_id,item_code,post_description,posted_on)VALUES('".$user_id."','".$vrb_id['verb_id']."','".$itm_code['item_code']."','".$post_description."','".$posted_on."')";

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: error can anyone help

and also check this link:
http://www.programmingfacts.com/solved-warning-session_start-function-session-start-cannot-send-session-cache-limiter-headers-already-sent/

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Blank Entry in database

once check your database table column data type once for these two fields : verb_category,added_on.

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: wysiwyg editor for mysql

and also check this:
http://www.openwebware.com/wysiwyg/demo.shtml

Web Development mysql php ui-ux

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Thoughts Of The Day.

Procrastination is like a credit card, fun until get the bill.

Geeks' Lounge

iamthwee commented: nice +0

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: adding row to a table(without refresh) using ajax/jquery

just change your code like this:

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js">
</script>
<script type="text/javascript">
function addRow(tableid)
{	

	  $(document).ready(function(){

      $("button").click(function(){
  	  var clonedRow = $("#" + tableid + " tr:last").clone(); //this will grab the lasttable row.
	  $("#" + tableid + " tr:last").append(clonedRow); //add the row back to the table
      });
    });
	
}
</script>
</head>

<form action="test.php" method="POST" >
<table id="bill">
<tr>
	<th>Quantity</th>
	<th>Rate</th>
	<th>Total</th>
</tr>
<tr>
	
	<td><input type="text" id="quantity" name="quantity"/></td>
	<td><input type="text" id="rate" name="rate"/></td>
	<td><input type="text" id="total" name="total"/></td>
</tr>

<tr>
<td><input type="submit" name="submit" value="Save" ></td>
<td><button type="button" name="addrow" value="Add Row" onclick="addRow($('.bill'));">Add Row</button></td>
</tr>

</table>
</form>

Web Development javascript javascript-jquery

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: table links

try with this:

<?php
$mosttracks = mysql_query ("SELECT *, member_id as mem_id, name as n, COUNT(name) as cn, MIN(date_added) FROM tracks GROUP BY name ORDER BY COUNT(name) DESC, date_added asc LIMIT 3");

$number=1;
while($row = mysql_fetch_array($mosttracks))
{
echo "<tr>";
echo "<td align=left><a href=\"generic profile.php\" onclick=\"createcookie(" . $row['n'] . " )\">" . $number . ". " . $row['n'] . " (" . $row['cn'] . ")" . "</a></td>";
echo "</tr>";
$number++;
}
?>
<SCRIPT LANGUAGE="JavaScript">
function createcookie(x)
{
document.cookie = "UMAlink="+x;
}
</script>

Web Development javascript seo

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: What New Thing Did You Learn Today??

Trying to learn: Mysql Replication
http://dev.mysql.com/doc/refman/5.0/en/replication.html

Geeks' Lounge

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: need help to echo a $row[image] ... if there is an image in the variable

check this:

while ($row = mysql_fetch_assoc($query))

{	echo 
	"<div style='border:solid 1px #cccccc; float:left; width:700px; height:150px; margin:10px;'>
			<table cellpadding='0' cellspacing='0' border='0'>
            <tr>
			<td width='200px'>
			<div>
			<a href='cars/$row[image1]' rel='lightbox' title='$row[make] $row[model]' ><img src='cars/{$row['image1']}' width='200px' height='150px'; border='0'/></a>
			</div>
			</td>
            <td valign='top' style='padding:0px 5px 0px 0px; font-size:12px; width:280px; background-color:#ffffff;'>
            <div style='text-align:left; padding:5px;'>
			  <div style='text-decoration:underline; font-size:13px; font-weight:bold;'>{$row['make']}&nbsp;{$row['model']}</div>
			  <div style='height:108px; padding-top:2px;'>{$row['description']}</div>
			  <div>Price: R.{$row['price']} | Colour: {$row['color']} | Year: {$row['yearmodel']}</div>
            </div>
			
            </td>
            <td width='120px'>";

if($row["image1"]!="")
$image1=$row["image1"];
else
$images1="../no_im_found.jpg";// your image with path.
if($row["image2"]!="")
$image2=$row["image2"];
else
$images2="../no_im_found.jpg";// your image with path.
if($row["image3"]!="")
$image3=$row["image3"];
else
$images3="../no_im_found.jpg";// your image with path.
echo "<!-- here i need to first check if the variable $image2 contains an image other was its shows that icon of no image found -->
            <img src='cars/$image2' width='120px' height='90px'; border='0'/>
            </td> 
            <td width='120px'>
<!-- here i need to first check if the variable $image3 contains an image other was its shows that icon of no image found -->
            <img src='cars/$image2' width='120px' height='90px'; border='0'/>
            </td>
            </tr>
            </table>
	</div>"; 
}

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: php subtotal

then mark this thread as solved.

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Multiple Image Selection Atonce

yes,generally <input type="file" multiple="true" /> will not be used much.
and also check:
http://developer.yahoo.com/yui/examples/uploader/uploader-simple-button.html

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: php subtotal

i have some work now, please check this small issue yourself, it is not much difficult to do. Its a just our login mistake.
Whenever i got time, then i will work on this.
Sorry and thanks.

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: php subtotal

again try with this:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>PACKING GUIDE</title>
<style type="text/css">
<!--
#Layer1 {
position:absolute;
left:601px;
top:157px;
width:81px;
height:22px;
}
#Layer2 {
position:absolute;
left:84px;
top:458px;
width:62px;
height:13px;
z-index:1;
}
.style4 {font-family: Tahoma; font-size: 9px; }
.style5 {font-size: 9px}
.style7 {font-family: Tahoma}
#Layer3 {
position:absolute;
left:88px;
top:346px;
width:80px;
height:17px;
z-index:1;
}
.style8 {
font-size: 7px;
font-weight: bold;
}
#Layer4 {
position:absolute;
left:35px;
top:137px;
width:103px;
height:16px;
z-index:2;
}
.style16 {font-family: Tahoma; font-size: 8px; }
.style17 {font-size: 8px}
.style18 {font-family: Tahoma; font-size: 8px; font-weight: bold; }
.style19 {font-family: Tahoma; font-size: 8px; color: #FFFFFF; }
-->
</style>
</head>

<body>
<?php packing_guide(); ?>
<?php packing_guide_detail(); ?>
<?php total_pg(); ?>
</body>
</html>
<?php
function packing_guide()
{
include("db_PSIS.php");
$sql="SELECT tblPackingGuide.SANo,
tblPackingGuide.DeptID,
tblPackingGuide.DevCategory,
tblPackingGuide.PONo,
tblPackingGuide.PackingCategory,
tblPackingGuide.DateEncoded,
tblPackingGuide.TimeEncoded,
tblPackingGuide.ShipmentDate,
tblPackingGuide.Status,
tblDepartment.DepartmentName
FROM tblDepartment
INNER JOIN (tblDetails INNER JOIN tblPackingGuide ON tblDetails.SANo = tblPackingGuide.SANo) ON tblDepartment.DepartmentID = tblPackingGuide.DeptID
WHERE tblPackingGuide.SANO = (SELECT SANo FROM tblSANo_print)
ORDER BY tblDetails.MasterBoxNo, tblDetails.InnerBoxNo, tblDetails.NoOfLots";
$res=mysql_query($sql);
$rec=mysql_num_rows($res);
$row=mysql_fetch_array($res);
?>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0" >
<tr>
<td align="center"><h2><b>AMERTRON INCORPORATED</h2></b>PACKING GUIDE</td>
</tr>
<tr>
<td align="center"><b><?php print $row["DepartmentName"] ?></b></td>
</tr>
</table>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0" >
<tr>
<td>SA Number:</td>
<td><?php print $row["SANo"] ?></td>
<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td>Device Category:</td>
<td><?php print $row["DevCategory"] ?></td>
</tr>
<tr>
<td>Shipment Date:</td>
<td><?php print $row["ShipmentDate"] ?></td>
<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td>Shipment Category:</td>
<td><?php print $row["PackingCategory"] ?></td>
</tr>
<tr>
<td>PO Number:</td>
<td><?php print $row["PONo"] ?></td>
<td colspan="3">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
</tr>
</table>
<br>
<?php
}

function packing_guide_detail()
{
include("db_PSIS.php");
$sql_det="SELECT pg1.MasterBoxNo,
pg1.InnerBoxNo, …

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: PHP mySQL

in this piece of code

$query = "SELECT types_id,gender FROM types ";
$result = mysqli_query ($dbc, $query);
while ($row = mysqli_fetch_array ($result, MYSQLI_ASSOC)) {
echo "<option value=\"{$row ['types_id']}\">{$row['gender']}</option>\n";

try to retrieve types_id in select query.

Web Development mysql php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: php subtotal

try with this:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>PACKING GUIDE</title>
<style type="text/css">
<!--
#Layer1 {
position:absolute;
left:601px;
top:157px;
width:81px;
height:22px;
}
#Layer2 {
position:absolute;
left:84px;
top:458px;
width:62px;
height:13px;
z-index:1;
}
.style4 {font-family: Tahoma; font-size: 9px; }
.style5 {font-size: 9px}
.style7 {font-family: Tahoma}
#Layer3 {
position:absolute;
left:88px;
top:346px;
width:80px;
height:17px;
z-index:1;
}
.style8 {
font-size: 7px;
font-weight: bold;
}
#Layer4 {
position:absolute;
left:35px;
top:137px;
width:103px;
height:16px;
z-index:2;
}
.style16 {font-family: Tahoma; font-size: 8px; }
.style17 {font-size: 8px}
.style18 {font-family: Tahoma; font-size: 8px; font-weight: bold; }
.style19 {font-family: Tahoma; font-size: 8px; color: #FFFFFF; }
-->
</style>
</head>

<body>
<?php packing_guide(); ?>
<?php packing_guide_detail(); ?>
<?php total_pg(); ?>
</body>
</html>
<?php
function packing_guide()
{
include("db_PSIS.php");
$sql="SELECT tblPackingGuide.SANo,
tblPackingGuide.DeptID,
tblPackingGuide.DevCategory,
tblPackingGuide.PONo,
tblPackingGuide.PackingCategory,
tblPackingGuide.DateEncoded,
tblPackingGuide.TimeEncoded,
tblPackingGuide.ShipmentDate,
tblPackingGuide.Status,
tblDepartment.DepartmentName
FROM tblDepartment
INNER JOIN (tblDetails INNER JOIN tblPackingGuide ON tblDetails.SANo = tblPackingGuide.SANo) ON tblDepartment.DepartmentID = tblPackingGuide.DeptID
WHERE tblPackingGuide.SANO = (SELECT SANo FROM tblSANo_print)
ORDER BY tblDetails.MasterBoxNo, tblDetails.InnerBoxNo, tblDetails.NoOfLots";
$res=mysql_query($sql);
$rec=mysql_num_rows($res);
$row=mysql_fetch_array($res);
?>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0" >
<tr>
<td align="center"><h2><b>AMERTRON INCORPORATED</h2></b>PACKING GUIDE</td>
</tr>
<tr>
<td align="center"><b><?php print $row["DepartmentName"] ?></b></td>
</tr>
</table>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0" >
<tr>
<td>SA Number:</td>
<td><?php print $row["SANo"] ?></td>
<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td>Device Category:</td>
<td><?php print $row["DevCategory"] ?></td>
</tr>
<tr>
<td>Shipment Date:</td>
<td><?php print $row["ShipmentDate"] ?></td>
<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td>Shipment Category:</td>
<td><?php print $row["PackingCategory"] ?></td>
</tr>
<tr>
<td>PO Number:</td>
<td><?php print $row["PONo"] ?></td>
<td colspan="3">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
</tr>
</table>
<br>
<?php
}

function packing_guide_detail()
{
include("db_PSIS.php");
$sql_det="SELECT pg1.MasterBoxNo,
pg1.InnerBoxNo,
pg1.LotNo, …

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: php subtotal

have you tried with my modified code:
http://www.daniweb.com/forums/post1466805.html#post1466805

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: php subtotal

here is the database

??????

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Store Combo Box values in an Array

post your entire code

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: php subtotal

post your database tables with data. (as .sql file)
and also try with modified code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>PACKING GUIDE</title>
<style type="text/css">
<!--
#Layer1 {
	position:absolute;
	left:601px;
	top:157px;
	width:81px;
	height:22px;
}
#Layer2 {
	position:absolute;
	left:84px;
	top:458px;
	width:62px;
	height:13px;
	z-index:1;
}
.style4 {font-family: Tahoma; font-size: 9px; }
.style5 {font-size: 9px}
.style7 {font-family: Tahoma}
#Layer3 {
	position:absolute;
	left:88px;
	top:346px;
	width:80px;
	height:17px;
	z-index:1;
}
.style8 {
	font-size: 7px;
	font-weight: bold;
}
#Layer4 {
	position:absolute;
	left:35px;
	top:137px;
	width:103px;
	height:16px;
	z-index:2;
}
.style16 {font-family: Tahoma; font-size: 8px; }
.style17 {font-size: 8px}
.style18 {font-family: Tahoma; font-size: 8px; font-weight: bold; }
.style19 {font-family: Tahoma; font-size: 8px; color: #FFFFFF; }
-->
</style>
</head>

<body>
<?php packing_guide(); ?>
<?php packing_guide_detail(); ?>
<?php total_pg(); ?>
</body>
</html>
<?php 
function packing_guide()
{
	include("db_PSIS.php");
	$sql="SELECT tblPackingGuide.SANo, 
			tblPackingGuide.DeptID, 
			tblPackingGuide.DevCategory, 
			tblPackingGuide.PONo, 
			tblPackingGuide.PackingCategory, 
			tblPackingGuide.DateEncoded, 
			tblPackingGuide.TimeEncoded, 
			tblPackingGuide.ShipmentDate, 
			tblPackingGuide.Status, 
			tblDepartment.DepartmentName
		FROM tblDepartment 
			INNER JOIN (tblDetails INNER JOIN tblPackingGuide ON tblDetails.SANo = tblPackingGuide.SANo) ON tblDepartment.DepartmentID = tblPackingGuide.DeptID
		WHERE tblPackingGuide.SANO = (SELECT SANo FROM tblSANo_print)
		ORDER BY tblDetails.MasterBoxNo, tblDetails.InnerBoxNo, tblDetails.NoOfLots";
	$res=mysql_query($sql);
	$rec=mysql_num_rows($res);
	$row=mysql_fetch_array($res);
?>
	<table width="600" border="0" align="center" cellpadding="0" cellspacing="0" >
		<tr>
		<td align="center"><h2><b>AMERTRON INCORPORATED</h2></b>PACKING GUIDE</td>
		</tr>
		<tr>
		<td align="center"><b><?php print $row["DepartmentName"] ?></b></td>
		</tr>
	</table>
	<table width="600" border="0" align="center" cellpadding="0" cellspacing="0" >
		<tr>
		<td>SA Number:</td>
		<td><?php print $row["SANo"] ?></td>
		<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
		<td>Device Category:</td>
		<td><?php print $row["DevCategory"] ?></td>
		</tr>
		<tr>
		<td>Shipment Date:</td>
		<td><?php print $row["ShipmentDate"] ?></td>
		<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
		<td>Shipment Category:</td>
		<td><?php print $row["PackingCategory"] ?></td>
		</tr>
		<tr>
		<td>PO Number:</td>
		<td><?php print $row["PONo"] ?></td>
		<td colspan="3">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td> …

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Store Combo Box values in an Array

try to print this $row , whether it is correctly printed or not.
and try this and tel me it is working or not:

$strSQL = mysql_query("SELECT * FROM member");
while($row = mysql_fetch_array($strSQL))
{
	$data .="<td>";
    $data .= "<select name='access[]'>";
    $data .="<option value='member'";
    if($row['access'] == 'member')
    $data.=" selected";
    $data.=">member</option>";
    $data .="<option value='admin'";
    if($row['access'] == 'admin')
    $data.=" selected";
    $data.=">admin</option>";

$data .="</select>";
$data .="</td>";
$data .= "</tr>";       
}

and also once check your update query is updating correctly or not in your data base table.

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: php subtotal

or tel me if this is working or not:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>PACKING GUIDE</title>
<style type="text/css">
<!--
#Layer1 {
	position:absolute;
	left:601px;
	top:157px;
	width:81px;
	height:22px;
}
#Layer2 {
	position:absolute;
	left:84px;
	top:458px;
	width:62px;
	height:13px;
	z-index:1;
}
.style4 {font-family: Tahoma; font-size: 9px; }
.style5 {font-size: 9px}
.style7 {font-family: Tahoma}
#Layer3 {
	position:absolute;
	left:88px;
	top:346px;
	width:80px;
	height:17px;
	z-index:1;
}
.style8 {
	font-size: 7px;
	font-weight: bold;
}
#Layer4 {
	position:absolute;
	left:35px;
	top:137px;
	width:103px;
	height:16px;
	z-index:2;
}
.style16 {font-family: Tahoma; font-size: 8px; }
.style17 {font-size: 8px}
.style18 {font-family: Tahoma; font-size: 8px; font-weight: bold; }
.style19 {font-family: Tahoma; font-size: 8px; color: #FFFFFF; }
-->
</style>
</head>

<body>
<?php packing_guide(); ?>
<?php packing_guide_detail(); ?>
<?php total_pg(); ?>
</body>
</html>
<?php 
function packing_guide()
{
	include("db_PSIS.php");
	$sql="SELECT tblPackingGuide.SANo, 
			tblPackingGuide.DeptID, 
			tblPackingGuide.DevCategory, 
			tblPackingGuide.PONo, 
			tblPackingGuide.PackingCategory, 
			tblPackingGuide.DateEncoded, 
			tblPackingGuide.TimeEncoded, 
			tblPackingGuide.ShipmentDate, 
			tblPackingGuide.Status, 
			tblDepartment.DepartmentName
		FROM tblDepartment 
			INNER JOIN (tblDetails INNER JOIN tblPackingGuide ON tblDetails.SANo = tblPackingGuide.SANo) ON tblDepartment.DepartmentID = tblPackingGuide.DeptID
		WHERE tblPackingGuide.SANO = (SELECT SANo FROM tblSANo_print)
		ORDER BY tblDetails.MasterBoxNo, tblDetails.InnerBoxNo, tblDetails.NoOfLots";
	$res=mysql_query($sql);
	$rec=mysql_num_rows($res);
	$row=mysql_fetch_array($res);
?>
	<table width="600" border="0" align="center" cellpadding="0" cellspacing="0" >
		<tr>
		<td align="center"><h2><b>AMERTRON INCORPORATED</h2></b>PACKING GUIDE</td>
		</tr>
		<tr>
		<td align="center"><b><?php print $row["DepartmentName"] ?></b></td>
		</tr>
	</table>
	<table width="600" border="0" align="center" cellpadding="0" cellspacing="0" >
		<tr>
		<td>SA Number:</td>
		<td><?php print $row["SANo"] ?></td>
		<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
		<td>Device Category:</td>
		<td><?php print $row["DevCategory"] ?></td>
		</tr>
		<tr>
		<td>Shipment Date:</td>
		<td><?php print $row["ShipmentDate"] ?></td>
		<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
		<td>Shipment Category:</td>
		<td><?php print $row["PackingCategory"] ?></td>
		</tr>
		<tr>
		<td>PO Number:</td>
		<td><?php print $row["PONo"] ?></td>
		<td colspan="3">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
		</tr>
	</table>
	<br>
<?php
}

function packing_guide_detail() …

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: php subtotal

yes, you just post required tables with data.

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: php subtotal

yes,do something for me,
please point out the line which you think your logic goes wrong in that attached file?

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: php subtotal

post your existing logic and error here.

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Store Combo Box values in an Array

I'm getting too many values in the $_POST even if I only put just one value. Its seems I'm getting all the values in the access field in my database.

yes, because you have written your combo box code in while loop, that's why you are getting all the values in the access files from your database.

Please clearly tell what is your required output from your code.

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Multiple Image Selection Atonce

check this link:
http://stackoverflow.com/questions/3755752/multiple-image-selection-using-ctrlclick-and-uploading-using-php
http://developer.yahoo.com/yui/uploader/

or you can do like this:

<input type="file" multiple="true" />

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Thoughts Of The Day.

It is not who is right that matters, it is what right.
-Ron Martin.

Geeks' Lounge

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: dropdown retrieve data

join the queries like:

$country2=mysql_query("select products.* from members,products where products.datanum='$localid' and members.id!=products.uid");

if not, explain your problem clearly.

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Username & password error

one small error i have found is:
you missed the '=' in form tag.

<form method="post" action="http://localhost/movie1.php">

Rest of the code working fine for me.

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Word Association Game

fiction -> Non-fiction

Geeks' Lounge posting-games

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Who is your historical hero?

Well , me historical hero is Annamayya.
His full name is Sri Tallapaka Annamacharya from INDIA.
He was the official songmaster of the Tirumala Venkateswara Temple.
He was one of the first few who opposed the social stigma towards the untouchable castes in his era,with his sankeertanas explaining that the relationship between God and human is the same irrespective of the latters' color, caste and financial status.
His choice of words gives a mellifluous tone to his songs, charming the listener. His prodigious literary career earned him a place among the all-time greats of Telugu literature.

Geeks' Lounge

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Get only updated or inserted rows.

thank you smantscheff and mwasif.

Databases mysql

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: sms Gateway

check these links:
http://www.java-samples.com/showtutorial.php?tutorialid=22
http://www.servletsuite.com/servlets/smstag.htm
http://code.google.com/p/jsmpp/

Web Development java-jsp

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Thoughts Of The Day.

The safest principle through life, instead of reforming others,is to set about perfecting yourself.
- B.R.Haydon.

Geeks' Lounge

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Modifiy .java file in webserver?

ok.thank you.

Web Development client-server java java-jsp

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Modifiy .java file in webserver?

thank you masijade,
i will check it out.

I just post a link here for readers, who will face the same problem:
http://tomcat.apache.org/tomcat-5.5-doc/appdev/processes.html

thanks again masijiade for your quick response.

Web Development client-server java java-jsp

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Textbox to be used as variable name ?

yes,
check this:

if(rs.next())
		{
                  response.sendRedirect("someUrl");
		}
                else
                {
                  //no record found.
                }

Web Development java-jsp

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Textbox to be used as variable name ?

Also i get an error while trying to use textbox names or id's inside java tags of JSP. Is there a way to access those elements.

you have to write like this:

String pword=request.getParameter("Pswd");
String uname=request.getParameter("UNam");

then your query should be like:

String s1="select * from Cat where cid='"+pword+"' and cname ='"+uname+"'";

and

I retrieve data from a table called cat and what i would like to do is , go to the action page only if there is a record for that username and password.

see this:

if(rs.next())
{
// redirect to action page..
}

Web Development java-jsp

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Modifiy .java file in webserver?

You need to restart the application after loading new classfiles. This happens automatically when you deploy a war file.

thank you masijade.
Can you tell me how to restart application in web server?

Web Development client-server java java-jsp

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: JSP: insert radio button value into mysql database

Use ajax for dynamic database insertions.

Web Development java-jsp mysql

Shanti C 106 Posting Virtuoso

14 Years Ago

Modifiy .java file in webserver?

Hello all,

I have successfully deploy my jsp project into webserver.It is running fine.
But my problem is , my project contains some .java/.class files where i have written classes and methods.
If i want to change this .java file and re-upload it to web server, it is not get updated.
Then i export my whole project into .war file and upload, then it works fine.

Please tel me how to upload modified .java/.class files into web server.

Thanks in advance.

SHAN

Web Development client-server java java-jsp

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: form

your above code is simply fine.
what your dbconnect.php page contains?
try to include dbconnect.php page (include "dbconnect.php";) at the first line of your page.

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Word Association Game

wiseman --> intelligent

Geeks' Lounge posting-games

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: 3 word story

, a little girl

Geeks' Lounge posting-games

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: Thoughts Of The Day.

A gem is not polished without rubbing, nor a man perfected without trails.

Geeks' Lounge

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: What New Thing Did You Learn Today??

Encryption & Decryption of files in java using AES.

SNIP

Geeks' Lounge

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: get value of button

i am giving you a small example, please go through this:

<table id="test" border=2>
<tr><td>SNO</td>
<td>Action</td></tr>
<?php for($i=0;$i<10;$i++){?>
<tr id=<?php echo $i;?>>
<td><?php echo $i;?></td>
<td><input type=button name=button value=Click onclick="buttonPress('<?php echo $i;?>');"></td>
</tr>
<?php }?>
</table>
<script type="text/javascript">
function buttonPress(x)
{
	var table = document.getElementById('test');   
	var rows=table.getElementsByTagName("tr");   
	for(var i=0;i<rows.length;i++)
	{
		ck=rows[i].id; 
		if(x==ck)
		alert("Row clcicked: "+ck); 
		
	}
}
</script>

Web Development php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: html entities

this code works for me:

<?php 
$str='&lt;b&gt;dog&lt;/b&gt;';
$str=htmlentities($str);
echo $q="insert into test values('$str')";
?>

Web Development html-css php

Shanti C 106 Posting Virtuoso

14 Years Ago

Re: html entities

ya, then please post post your query,
it may be because of quotes in your query.

Web Development html-css php