Posts by urtrivedi Page 22

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

<input type=checkbox name=chk1 id=chk1 value='Yes' 
<?php 
   if ($_SESSION['last_data']['chk1']=='Yes')
    echo "checked";
?>   > Check here


<input type=radiobutton name=rad1 id=rad1 value='No' 
<?php 
   if ($_SESSION['last_data']['rad1']=='No')
    echo "checked";
?>   > No


<select name=sel id=sel >
<option value='v1' <?php echo ($_SESSION['last_data']['sel']=='v1'?"selected":"") ?>     > One</option>

<option value='v2' <?php echo ($_SESSION['last_data']['sel']=='v2'?"selected":"") ?>     > Two</option>


<option value='v3' <?php echo ($_SESSION['last_data']['sel']=='v3'?"selected":"") ?>     > Three</option>

</select>

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Having trouble with CONCAT_WS, unable to store data in the text field...please help

it should not show <br/> is it part of your note

Web Development javascript-jquery mysql php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: redirect php form to html

change your main form file like this

<div><?php echo $_GET['message']?> </div>
<form action='mail.php' >
.
.
.

</form>

Web Development html-css php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Passing form value with Session

I will give one example to set value using session

<input type = "text" name="data_nc" id = "data_nc"  size = "30" value='<?php  echo $_SESSION['last_data']['first_form']['data_nc']?>'/>

in your form2.php you must write

$_SESSION['last_data']['first_form']=$_POST;

also start all pages with session_start()

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: redirect php form to html

attach mail.php file here using advance editor

Web Development html-css php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Rating System PHP SQL

You will always find that username or userid or loginid are always unique for that particular website.
If username of your site is not unique (I am sure it is unique) then then you should find another unique column to rate it distinctly.

do not use

rated  LIKE '%$_SESSION[username]%'

instead use

rated  = '$_SESSION[username]'

Web Development php sql

karthik_ppts commented: useful post +6

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Passing form value with Session

better you post your code for at least form 1, that you have written

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Having trouble with CONCAT_WS, unable to store data in the text field...please help

on display page add function nl2br as shown here

<td><textarea rows="15" style="width: 99%" readonly><?php echo nl2br($row_Recordset1['Notes']); ?></textarea></td>

You should also change way you update note, new line must be between old note and new note

CONCAT_WS( Notes,'\r\n\r\n', %s)

Web Development javascript-jquery mysql php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Having trouble with CONCAT_WS, unable to store data in the text field...please help

You are displaing link to note, where and how you display note?

<a href="test5.php?Id=<?php echo $row_Recordset1['Id']; ?>" class="submodal"><img src="Images/editnote.png" /></a>

Web Development javascript-jquery mysql php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: redirect php form to html

I have removed <html><body>, spaces, new lines from your mail.php, to avoid header erros.

<?php

  //send email

  $from = 'enquiry@webzymes.com';
  $name = $_REQUEST['txtName'] ;
  $subject = $_REQUEST['txtSubject'] ;
  $company = $_REQUEST['txtCompany'] ;
  $number = $_REQUEST['txtNumber'] ;
   $email = $_REQUEST['txtEmail'] ;
  $msg = $_REQUEST['txtarMessage'] ;
  $message= " Name : " .$name." \n Company : ".$company." \n Contact Number :".$number." \n Email : ".$email." \n Message : ".$msg;
 $mailsent= mail("nikita.chandra@webzymes.com", "$subject",
  $message, "From:" . $from);
if($mailsent)
   $msg1="Mail sent succefully";
else
   $msg1="Error occured while sending mail";
 
header("location:contactUs.html?message={$msg1}");
exit;
?>

Web Development html-css php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Having trouble with CONCAT_WS, unable to store data in the text field...please help

you must replace $note with variable of your data fetch array

Web Development javascript-jquery mysql php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Parse error: syntax error, unexpected T_ECHO in

1 removed () around echo
2 merged two lines,
3 changed " to '

echo "<br>You left out some required dields. <STRONG>Record NOT added</STRONG>. Enter this record again, please <P align='center'><A HREF='http://www.kotw.net'><STRONG>Go Back</STRONG></A></P> ";

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: redirect php form to html

your form page, say myform.html.

<div><?php echo $_GET['message']?> </div>
<form action='mail.php' >
.
.
.

</form>

your mail.php

<?php
$mailsent=mail('som@g.com','hi','how are you');

if($mailsent)
   $msg="Mail sent succefully";
else
   $msg="Error occured while sending mail";

header("location:myform.html?message={$msg}");
exit;

?>

Web Development html-css php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Having trouble with CONCAT_WS, unable to store data in the text field...please help

two lines after note and then add current note

CONCAT_WS( Notes,'\r\n\r\n', %s)

then when you display note in html page. you may use
nl2br function to convert new line to html break
<?php
echo nl2br ($note);
?>

Web Development javascript-jquery mysql php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: over themouse view the links + javascript

<div><b><a href='edit.php?articleid=1'>My article 1</a> </b>
content 1 content 1 content 1 content 1 content 1
 
</div>


<div><b><a href='edit.php?articleid=2'>My article 2</a> </b>
content 2 content 2 content 2 content 2 content 2
 
</div>

<div><b><a href='edit.php?articleid=3'>My article 3</a> </b>
content 3 content 3 content 3 content 3 content 3
 
</div>

Web Development javascript php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Having trouble with CONCAT_WS, unable to store data in the text field...please help

Still a small problem

I am not able to understand your problem.

Web Development javascript-jquery mysql php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Why does array from a JOIN display incorrectly?

I have selected only required columns and echoed query before running it.
When you run this page, copy the query output from browser and run it in phpmyadmin, and see what comes as result

<?php
$query="SELECT topics.quizId, topics.title, quiz.passState' FROM topics LEFT JOIN quiz ON topics.managerId = quiz.managerId WHERE quiz.userId = '$userId' AND userId= '$userId' AND $egroup = 1 GROUP BY topics.title";

echo $query;//when you run this page, copy the query output from browser and run it in phpmyadmin, and see what comes as result

$result = mysql_query($query)OR die(mysql_error());
?>

Databases mysql

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Having trouble with CONCAT_WS, unable to store data in the text field...please help

try to do without sprintf,

$notes=addslashes($_POST['Notes']);
$updateSQL = "UPDATE Leads SET Notes = CONCAT_WS(Notes,'\r\n', '{$notes}') WHERE Id='{$_POST['Id']}'";

Web Development javascript-jquery mysql php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: PHP validation issue

in your post handler form you check errors

<?php
unset($_SESSION['last_data']);
unset($_SESSION['errors']);
if(errors)
{
//set error session here
$_SESSION['last_data']=$_POST;
}
else
{
//update/insert database
}

header("location:myform.php");
exit;
?>

Now in your main form
you can diplay session errors if session errors is set, and use last data to set back values

<?php
if(isset($_SESSIONS['errors'])
{
//display errorrs at the top of page
}

.
.
.
.
<input type=text name=txt1 id=txt1 value='?php echo  $_SESSION['last_data']['txt1']?>' >
.
.
.
.
?>

Web Development php

AngelicOne commented: Redirecting a form is something new to me using PHP! Thank you very much! +3

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: How to compare two time in javascript?

Hi almostbob, I overlooked that sentence but this code should work in either way you
want.
anandhikrishnan, here is final code

<html>


<script language="javascript">

	function validate(dt1,dt2)
	{
		
		var jdt1=Date.parse('20 Aug 2000 '+dt1);
		var jdt2=Date.parse('20 Aug 2000 '+dt2);
		
		if(isNaN(jdt1))
		{
			alert('invalid start time');
			return false;
		}
		if(isNaN(jdt2))
		{
			alert('invalid end time');
			return false;
		}
	  	if (jdt1>jdt2)
		{
			alert('start is greater');
		}
		else
		{
			alert('start is less equal');
		}
	
		
	}
	
</script>

<body>
<div>


<form name=frm id=frm action=temp.php method="get" accept="text/csv">
<P>&nbsp;</P>
start <INPUT id=txt1 name=txt1 value='10:30:05 am'>&nbsp; <br>
end <INPUT id=txt2 name=txt2  value='10:40:05 am'>&nbsp; 
<input type=button value=ok id=button2 name=button2 onclick ='validate(document.frm.txt1.value,document.frm.txt2.value)'>&nbsp;&nbsp; 
 </P>
</form></div>
<script language='javascript'>
</script>
<div id="txtHint">&nbsp;
</div>
<P></P>

</body>
</html>

Web Development javascript

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: How to compare two time in javascript?

<html>


<script language="javascript">

	function validate(dt1,dt2)
	{
		
		var jdt1=Date.parse('20 Aug 2000 '+dt1);
		var jdt2=Date.parse('20 Aug 2000 '+dt2);
		
	/*	if(jdt1=='NaN')
		{
			alert('invalid start time');
			return false;
		}
		if(jdt2=='NaN')
		{
			alert('invalid end time');
			return false;
		}*/
	  	if (jdt1>jdt2)
		{
			alert('start is greater');
		}
		else
		{
			alert('start is less equal');
		}
	
		
	}
	
</script>

<body>
<div>


<form name=frm id=frm action=temp.php method="get" accept="text/csv">
<P>&nbsp;</P>
start <INPUT id=txt1 name=txt1 value='10:30:05 am'>&nbsp; <br>
end <INPUT id=txt2 name=txt2  value='10:40:05 am'>&nbsp; 
<input type=button value=ok id=button2 name=button2 onclick ='validate(document.frm.txt1.value,document.frm.txt2.value)'>&nbsp;&nbsp; 
 </P>
</form></div>
<script language='javascript'>
</script>
<div id="txtHint">&nbsp;
</div>
<P></P>

</body>
</html>

Web Development javascript

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: How to prevent duplication using dropdownlist click

I assume gid is number

so pass one more parameter test.jsp?gid=1&gidlist=-1,2,3,
track entered ids using javascript store it some where.

then in your query you may write

"select gid, sgg_eng_nm from test where gid not in ($gidlist)"

Web Development html-css java-jsp

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: mysql Fetch array (rows as columns)

Explain in detail. post acutally table structure and sample data (preferably in sql format)
Then post expected output.

Web Development mysql php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: How to use the implode function?

implode works on array not on string
so you need to replace spaces with hyphen.

I am assuming only one space between all ids

$id1 = str_replace(" ","-", $id);

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: browse image from server

I have sever browsing code, but you need to find some way that how to select file and copy path to server. also find 2 images below for better view.

<?php



	session_start();
	

	if (trim($_POST['dirname'])=="")
		$currdirectory=dirname($_SERVER['DOCUMENT_ROOT']);
	else
		$currdirectory=$_POST['dirname'];
	$_SESSION['dirname']=$currdirectory;			

	
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.2900.2180" name=GENERATOR></HEAD>
<script lang=javascript>
	function link_click(dname)
	{
		document.frmdir.dirname.value=dname;
		document.frmdir.submit();
	}
</script>
<BODY>

<?php
	
	$files = scandir($currdirectory);
	print "<b><BR>{$currdirectory}</b><br>";
	
	if (!(substr(strrev(trim($currdirectory)),0,1)=='/' ||substr(strrev(trim($currdirectory)),0,1)=='\\'))

		
	print "<a href=\"javascript:link_click('".str_replace('\\','',dirname($currdirectory))."')\">Up</a><br>";
?>

<?php


	print "<form method='post' name=frmdir id=frmdir action='{$_SERVER['PHP_SELF']}'>";
	print "\n<table border=0>";
	for ($i=0;$i<count($files);$i++)
	{
		
		$content=$currdirectory."/".$files[$i];
	 	
	 	if (is_dir($content) && trim($files[$i])!="." && trim($files[$i])!="..")
	 	{
			print "\n<tr>";	 	 
			print "\n\t<td valign=bottom><img src='./folder.jpg' border=0 >	</td>";
			print "<td><a href=\"javascript:link_click('".$content."')\">{$files[$i]}</td></a>";	 	
	 		print "\n</tr>";
		}

	}

	for ($i=0;$i<count($files);$i++)
	{
		 $content=$currdirectory."/".$files[$i];
	 	if (is_file($content))
	 	{
 			print "\n<tr>";
			print "\n\t<td valign=center align=right><img src='./file.jpg' border=0></td>";	 	 
			print "\n\t<td><span >{$files[$i]}</span>";
	 		print "\n</td></tr>";
		}

	}
	print "\n</table>";
?> 
<input name=dirname id=dirname type=hidden>
</form>


</BODY></HTML>

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: retrieve data from array

TRY CHANGE FOLLOWING LINES

LINE 26

$querymain="SELECT substrING(C1.GroupID,1,3) GroupID,

LINE 42

GROUP BY  substrING(C1.GroupID,1,3) ";

LINE 100

where  groupID like '{$rowmain['GroupID']}%'

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: retrieve data from array

if database is readonly for you then. there is not alternative, if you can update triagroup column with some data then it could be fine.

But in case of readonly database we do following.

Identify common pattern in groupname. like lets take first 3 character from group name
so hopefully we get ABP, CIB, BAF (not BAFF as we take only 3 chars)
then this way we can expected output.
but are you sure first 3 letters will be our required master groups?

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: retrieve data from array

i will say ABP, CIB, BAFF as CATEGORY
and ABP(JUN-2010), BAFF -JUN-JUL-10 AS GROUPID.

in your reg_group table you do not have category, so for precise report, you must add one column to reg_group that is CATEGORY.

groupid, groupname, category
ABP(JUNJUL10), ABP(JUNJUL10), ABP
BAFF-JUL 10, BAFF-JUL 10, BAFF

IF YOU DO NOT WANT TO ADD MORE COLUMN THEN you may use trialgroup column if it is blank. you can add ABP, BAFF in trialgroup column.

Then we have to just modify query at few places.

So tell me what are you going to do now.

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: arsala

HERE IS THE CODE

<html>
<head>
<script lang=javascript>
isEmail1    = /^\w+([\.\-]\w+)*\@\w+([\.\-]\w+)*\.\w+$/;
isEmail2    = /^.*@[^_]*$/;

function isEmail(s) 
{
  return (isEmail1.test(s) && isEmail2.test(s));
}


function validate(what) {


 if (!isEmail(what.txtemail.value))
 {
    alert('Invalid email id');
    return false;
 }
 else
 {
	  alert('WELCOME ID IS VALID');
}
//return true;
}

</script>
</head>
<body>
<form name=frm id=frm onsubmit='return validate(this);'>
<input type=text name=txtemail id=txtemail >
<input type=submit name=btnsub id=btnsub >
</form>
</body>
</html>

Web Development javascript

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: retrieve data from array

check this

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with zip files.

e4.zip (1.32 KB)

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: retrieve data from array

wait this is very poor query. We will get the optimzed one soon.

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: retrieve data from array

I was in impression that you are using MYSQL. In MSSQL "if" will not work, we need to change it to "case when then". Ok let me check and I will come back soon.

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: delete data dynamically+ mysql + php

You mean what is not working.
1) you are not able to delete record now after adding post id in delete.php
2) or you are able to delete record but you are not able to update contentbox
3) or both things not working

Web Development mysql php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: retrieve data from array

copy this and see are you able to run this query in your phpmyadmin, I do not have all data as you so it is not giving any error to me.

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: retrieve data from array

echo the query and post its output here

echo $querymain;
$resultmain=mysql_query($querymain);

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Days Calculation

Use OR very carefully, CRA is applicable in all cases so no need to use it in query.
We must simply find in which case we will need recepitdate then for rest case we will use returndate

find the simplest conditions (only guess cases for returndate) then I will help you more on it.

Databases mssql

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: retrieve data from array

You please simply run my original e3.php(do not add anything except orgname and mysql login values), it is already formatted in that format. You do not have to worry about query.

PLEASE DO NOT CHANAGE ANYTHING (except orgname and mysql login values).

Here is output(output.jpg) for what you send me in sql file and main php file (e3.txt)(attaching again).

e3.txt (5.12 KB)

<?php 		
//	error_reporting(E_ALL); 
//	ini_set("display_errors", 1); 
$dblink = mysql_connect("sever","user","pwd") or die(mysql_error());
mysql_select_db("dbname");

$orgname="SCSJ";


$query1="SELECT     COUNT(*) AS count1, Reg_Group.RegID, Reg_Group.GroupName, Reg_Group.GroupID, Reg_Group.UserType, 
                      Reg_Group.Domainid, Reg_Group.trialgroup, Reg_Group.orgid, Reg_User.ID, Reg_User.UserID, Reg_User.atype, 
                      Reg_Org.orgid AS orgzid, Reg_Org.orgname, Reg_Org.domainid AS domain, Reg_Org.create_date, 
                      Reg_Org.usertype AS usertype1, LoginLog.logintime AS logtime
FROM         Reg_Group INNER JOIN
                      Reg_User ON Reg_Group.RegID = Reg_User.RegID INNER JOIN
                      Reg_Org ON Reg_Group.orgid = Reg_Org.orgid INNER JOIN
                      LoginLog ON Reg_User.UserID = LoginLog.userid INNER JOIN
                      User_Login ON Reg_User.UserID = User_Login.UserID
WHERE    (Reg_Org.usertype = 's') AND (Reg_Org.orgname ='{$orgname}')                     
GROUP BY Reg_Group.RegID, Reg_Group.GroupName, Reg_Group.GroupID, Reg_Group.UserType, Reg_Group.Domainid, 
                      Reg_Group.trialgroup, Reg_Group.orgid, Reg_User.ID, Reg_User.RegID, Reg_User.UserID, Reg_User.atype, 
                      Reg_Org.orgid, Reg_Org.orgname, Reg_Org.domainid, Reg_Org.create_date, Reg_Org.usertype, LoginLog.logintime";
                      

$querymain="SELECT C1.GroupID,
sum(if(MONTH(C1.logtime)=1,count1,0))  January, 
sum(if(MONTH(C1.logtime)=2,count1,0))  February, 
sum(if(MONTH(C1.logtime)=3,count1,0))  March, 
sum(if(MONTH(C1.logtime)=4,count1,0))  April, 
sum(if(MONTH(C1.logtime)=5,count1,0))  May, 
sum(if(MONTH(C1.logtime)=6,count1,0))  June, 
sum(if(MONTH(C1.logtime)=7,count1,0))  July, 
sum(if(MONTH(C1.logtime)=8,count1,0))  August, 
sum(if(MONTH(C1.logtime)=9,count1,0))  September, 
sum(if(MONTH(C1.logtime)=10,count1,0))  October, 
sum(if(MONTH(C1.logtime)=11,count1,0))  November, 
sum(if(MONTH(C1.logtime)=12,count1,0))  December,
sum(count1) total from
 ({$query1}) as C1

GROUP BY  C1.GroupID ";
//echo $querymain;
//where orgname='{$orgname}'

$resultmain=mysql_query($querymain);
echo "<table border=1>";
echo "<tr><td>group</td>";
echo "  <td>jan</td>  ";
echo "<td>feb</td>";
echo "<td>mar</td>";
echo "<td>apr</td>";
echo "<td>may</td>";
echo "<td>jun</td>";
echo "<td>jul</td>";
echo "<td>august</td>";
echo "<td>sep</td>";
echo "<td>oct</td>";
echo "<td>nov</td>";
echo "<td>dec</td>";

echo " <td>Grand total</td>  </tr>";
while($rowmain=mysql_fetch_array($resultmain))
{


   echo "<tr><td><font color='red'>{$rowmain['GroupID']}</font></td>";
   echo "  <td><font color='red'>{$rowmain['January']}</font></td> ";
   echo " <td><font color='red'>{$rowmain['February']}</font></td>";
   echo " <td><font color='red'>{$rowmain['March']}</font></td>";
   echo " <td><font color='red'>{$rowmain['April']}</font></td>";
   echo " <td><font color='red'>{$rowmain['May']}</font></td>";
   echo " <td><font color='red'>{$rowmain['June']}</font></td>";            
   echo " <td><font color='red'>{$rowmain['July']}</font></td>";   
   echo " <td><font color='red'>{$rowmain['August']}</font></td>";
   echo " <td><font color='red'>{$rowmain['September']}</font></td>";
   echo " <td><font color='red'>{$rowmain['October']}</font></td>";
   echo " <td><font color='red'>{$rowmain['November']}</font></td>";            
   echo " <td><font color='red'>{$rowmain['December']}</font></td>";   
   
   echo "<td><font color='red'>{$rowmain['total']}</font></td>   </tr>";

   $querysub="SELECT C1.GroupName ,
	sum(if(MONTH(C1.logtime)=1,count1,0))  January, 
	sum(if(MONTH(C1.logtime)=2,count1,0))  February, 
	sum(if(MONTH(C1.logtime)=3,count1,0))  March, 
	sum(if(MONTH(C1.logtime)=4,count1,0))  April, 
	sum(if(MONTH(C1.logtime)=5,count1,0))  May, 
	sum(if(MONTH(C1.logtime)=6,count1,0))  June, 
	sum(if(MONTH(C1.logtime)=7,count1,0))  July, 
	sum(if(MONTH(C1.logtime)=8,count1,0))  August, 
	sum(if(MONTH(C1.logtime)=9,count1,0))  September, 
	sum(if(MONTH(C1.logtime)=10,count1,0))  October, 
	sum(if(MONTH(C1.logtime)=11,count1,0))  November, 
	sum(if(MONTH(C1.logtime)=12,count1,0))  December,
  sum(count1) total

   from ({$query1}) as C1
   where  groupID='{$rowmain['GroupID']}'
   GROUP BY  C1.GroupName ";
//orgname='{$orgname}' and


   $resultsub=mysql_query($querysub);
   while($rowsub=mysql_fetch_array($resultsub))
   {
   echo "<tr><td>{$rowsub['GroupName']}</td>";
   echo "  <td>{$rowsub['January']}</td> ";
   echo " <td>{$rowsub['February']}</td>";
   echo " <td>{$rowsub['March']}</td>";
   echo " <td>{$rowsub['April']}</td>";
   echo " <td>{$rowsub['May']}</td>";
   echo " <td>{$rowsub['June']}</td>";            
   echo " <td>{$rowsub['July']}</td>";   
   echo " <td>{$rowsub['August']}</td>";
   echo " <td>{$rowsub['September']}</td>";
   echo " <td>{$rowsub['October']}</td>";
   echo " <td>{$rowsub['November']}</td>";            
   echo " <td>{$rowsub['December']}</td>";   
   
   echo "<td>{$rowsub['total']}</td>   </tr>";

   }
}
echo "</table>";
?>

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: browse image from server

I think we can do that, but making your own browse window. as you find on browser based ftp managers. where user will browse server directories.

Another way we can do is instead of file field, if user knows the file path of file name(in case folder is fixed), give only text box where user will write the file path or name.

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: retrieve data from array

Now you have changed the query drastically, Now don't you want output in 12 months columns.
whenever you get error, post output query with your post.

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Help for online exam--timer needed

yes you can

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: retrieve data from array

I hope you have not changed the code, because it is working here

before this like

$resultsub=mysql_query($querysub);

add one more line it shold look like this

echo $querysub;
 $resultsub=mysql_query($querysub);

post that generated query here

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Days Calculation

Here is your query

select
ESN ,
 Supplier,
 RType ,
 WarrantyPeriod ,
 TodaysDate ,
 Returndate ,
 Receivedate ,	 
DATEDIFF(day,  case when Supplier ='AC8' OR Supplier ='BEI'THEN  returndate ELSE RECEIVEDATE END, todaysdate) TOTALDAYS,
CASE WHEN DATEDIFF(day,  case when Supplier ='AC8' OR Supplier ='BEI'THEN  returndate ELSE RECEIVEDATE END, todaysdate)<WarrantyPeriod THEN 'YES' else 'N0' END WarrantyDecision 
from mytable

Databases mssql

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: How in insert multiple textbox as date format in php/mysql

I could not insert partial date if you mysql datatype is date.

Post your code what you have done so far after my suggestion.

Web Development mysql php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: browse image from server

source and destination servers are same or different

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: retrieve data from array

have you used file i have attached in my previous post.

http://www.daniweb.com/web-development/php/threads/374124/1610733#post1610733

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: JavaScript

You must quote operators
if (ope=='+')
there no operators function

<html>
<body>
<script lang="text/javascript">

var num1, num2, ope, sum, diff, prod, quo, mod;
num1=Number(prompt("Enter First number: "));
num2=Number(prompt("Enter Second number: "));
ope=prompt("Choose Operator : + - * / %");

if (ope=='+')
{
sum=num1+num2;
document.write("The sum is: "+sum);
}

else if (ope=='-')
{
diff=num1-num2;
document.write("The difference is: "+diff);
}

else if (ope=='*')
{
prod=num1*num2;
document.write("The product is: "+prod);
}

else if (ope=='/')
{
quo=num1/num2;
document.write("The quotient is: "+quo);
}

else if (ope=='%')
{
mod=num1%num2;
document.write("The remainder is: "+mod);
}

else
{
document.write("INVALID!");
}

document.write("<br>First Number: "+num1);
document.write("<br>");
document.write("Second Number: "+num2);
document.write("<br>");
document.write("Operator Used: "+ope);

</script>
</body>
</html>

Web Development javascript

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Php timestamp date

When you are dealing with date and time, always use datatime datatype. Do not use varchar. You will always able to extract data by month, year, week, day whatever you want using certain functions.

I said anywhere you should use some names for columns and tables other than keyword like select, group, from, order, timestamp, date etc.

It is not related to security, but some time certain queries do not work just due to such colnames.
Though it is not mandatory. In mysql You may wrap such names with ``.
like `timestamp`

Web Development mysql php sql

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: browse image from server

if you know the path of the file on server, you may use

readfile('http://server/folder/image.jpg');

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Php timestamp date

As far as I know in mysql by default datatime field is stored in
yyyy-mm-dd format. Though if data is in another format then you may use mysql strtodate (some thing like that) function.

I suggest you to directly use mysql current_timestamp function

mysql_query ("INSERT INTO $tablename (timestamp,name) VALUES (current_timestamp,'$name')");

Note: you should also avoid using keywords as column or table name. Here you may change timestamp column to my_time or any other

Web Development mysql php sql

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

Re: Help for online exam--timer needed

You must also consider javascript in mind. load server time in javascript and manage countdown clock there.

http://www.w3schools.com/js/js_timing.asp

Web Development php