Posts by urtrivedi

Visit following post and go through all comments, I think you will find proper solution

http://www.daniweb.com/web-development/php/threads/366629

i think you do not have null vales in your database. What you have is 'NULL' word in columns, thats why my query did not show any result.

So now you can remove such rows by following query

delete from tablename where TRIM(grade)='NULL'

first select whether your table has null rows or not.
run following queries one by one.

SELECT name, grade, age FROM education 
WHERE (grade IS  NULL )

SELECT name, grade, age FROM education 
WHERE ( name is null )

SELECT name, grade, age FROM education 
WHERE (age is null)

see whether you get any row(s) (having null value)

You are expecting a solution but not following what people asking you to do. Have you read my previous post

http://www.daniweb.com/web-development/databases/oracle/threads/366673/1573429#post1573429

write first two lines shown below in code part, in the begining of your code and then try to run your page.

Also echo your query before inserting, copy that from browser, run that prepared query in your second database directly using phpmyadmin (or any other tool). Then check whether you are getting any error there or not.

<?php

error_reporting(E_ALL); 
ini_set("display_errors", 1);
        
$con1 = /*connect to server 1*/
$con2 = /*connect to server 2*/
.
.
.
.
$query="INSERT INTO table2 (col1, col2, col3, col4, col5)
		VALUES('$one','$two','$three','$four','$five')";
echo $query;

mysql_query($query, $con2)
	or die(mysql_error());

.
.
.

?>

write two php files, one for showing all other data

file 1.php
1)fetch data from mysql with primary key
2) show all columns
3) <img src='file2.php?imgid=currid'>

file2.php //it will contain code you have written to show image in your post above, but it will use one get parameter to load specific single image.

$sql = "SELECT image,size,format FROM img_tbl where record_id='{$_GET['imgid']}'";
 
        // the result of the query
        $result = mysql_query($sql) or die("Invalid query: " . mysql_error());
 
        // Header for the image
        header("Content-type: image/jpeg");
        echo mysql_result($result, 0,'imageData');

\ this is used to escape a character.

if you want to substitute variable value in string then you must prepare string in double quotes as i did.

$name="mikcy";
$mymessage= "welcome $name";  //'welcome $name'  will not substitute name.
echo $mymessage;

//output is 
welcome micky

Now you want name to be printed in double quotes, then you can not directly use it in string. if you use directly then php will think its end of string, so we use escape character

$name="mikcy";
//$mymessage= "welcome "$name" ";  //this will not work
$mymessage= "welcome \"$name\" ";  //this will work
echo $mymessage;

//output is 
welcome "micky"

I hope its clear now, If yes then mark this thread solved

myquery="INSERT INTO PR_REC(pr_no,item1,price1,qty1,item2,price2,qty2,item3,price3,qty3,item4,price4,qty4,item5,price5,qty5,item6,price6,qty6,item7,price7,qty7,item8,price8,qty8,item9,price9,qty9,item10,price10,qty10,Pur_reason,pr_date,Status) VALUES ('" & Me.txtprno.Text.TRIM & "','" & Me.txtitm1.Text.TRIM & "','" & Me.txtprc1.Text.TRIM & "', '" & Me.txtqty1.Text.TRIM & "','" & Me.txtitm2.Text.TRIM & "', '" & Me.txtprc2.Text.TRIM & "','" & Me.txtqty5.Text.TRIM & "','" & Me.txtitm3.Text.TRIM & "','" & Me.txtprc3.Text.TRIM & " ','" & Me.txtqty9.Text.TRIM & "','" & Me.txtitm4.Text.TRIM & " ','" & Me.txtprc4.Text.TRIM & " ','" & Me.txtqty2.Text.TRIM & "','" & Me.txtitm5.Text.TRIM & " ','" & Me.txtprc5.Text.TRIM & " ','" & Me.txtqty6.Text.TRIM & "','" & Me.txtitm6.Text.TRIM & " ','" & Me.txtprc6.Text.TRIM & " ','" & Me.txtqty6.Text.TRIM & "','" & Me.txtitm7.Text.TRIM & " ','" & Me.txtprc7.Text.TRIM & " ','" & Me.txtqty10.Text.TRIM & "','" & Me.txtitm8.Text.TRIM & " ','" & Me.txtprc8.Text.TRIM & " ','" & Me.txtqty3.Text.TRIM & "','" & Me.txtitm9.Text.TRIM & " ','" & Me.txtprc9.Text.TRIM & " ','" & Me.txtqty7.Text.TRIM & "','" & Me.txtitm10.Text.TRIM & " ','" & Me.txtprc10.Text.TRIM & " ','" & Me.txtqty11.Text.TRIM & "','" & Me.txtpr.Text.TRIM & "',to_date('" & textDateTime & "','mm/dd/yyyy hh24:mi:ss'),'" & ComboBox1.Text.TRIM & "')"

print myquery // keep break point here in dubugger

com = NEW OleDbCommand(myquery, con)

go to debugger, copy value of variable myquery and post it here.

<?php
    //replace line 19
    echo $comma."[\"$imagefolder/$imagefilename\", \"$imageurl\", \"_new\"]" ;

   //add new line 20
    $comma=", ";
?>

change your line no 10

$i = 0;

set $i to 1

$i=1;

Dear arsenalfun, MARK IT SOLVED, so that others do not trouble them.

I think on second verision of your code line no 13,25,26 is having un wanted paranthesis. Your effort is in right direction, but I think you need to do proper code indentation as I did below

while($row = mysql_fetch_array($result))
{
	$src = '';
	switch( $row['speed'] ) 
	{
		case 'fast':
			$src = 'fast.png';
			break;
		case 'slow':
			$src = 'slow.png';
			break;
		default:
			$src = 'default.jpg';
	}
	
	
	$ico = '';
	switch( $row['icon'] ) 
	{
		case 'icon1':
			$ico = 'icon1.png';
			break;
		case 'icon2':
			$ico = 'icon2.png';
			break;
		default:
			$ico = 'icondefault.jpg';
	}
	



	echo "<tr>";
	echo "<td><a href='http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF'])."/hits.php?id=".$row['id'] . "'>".$row['proxy']."</a></td>";
	echo "<td>" . $row['hits'] . "</td>";
	echo "<td>" . $row['age'] . "</td>";
	echo "<td>" . $row['country'] . "</td>";
	echo "<td><img src=\"". $src."\" /></td>";
	echo "<td><img src=\"". $ico."\" /></td>";
	echo "</tr>";
}
echo "</table>";


?>

Also You may write mysql case statment in your query, so that you need not to use switch statment for displaying dynamic images.

set id for DIV not for FORM, as i did in following code

<form >
    <div id="he">
    <input name="regPictures1" type="file" size="12"/>
 
    <br/>
    <input type="button" id="btnAdd" value="More" onclick="newUpload();" />
    </div>
    </form>

I think you are looking for this.

<?php
$firstday="Tuesday";
$secondday="Saturday";

$today=date("l");

$nextdate1=strtotime("next $firstday");
$nextdate2=strtotime("next $secondday");


if ($today==$firstday || $today==$secondday)
{
	echo "Today: ".date("m-d-Y")."<br>";
}
if ($nextdate1<$nextdate2)
{
	echo "Next: ".date("m-d-Y l",$nextdate1)."<br>";
	echo "Next: ".date("m-d-Y l",$nextdate2)."<br>";
}
else
{
 	echo "Next: ".date("m-d-Y l",$nextdate2)."<br>";
	echo "Next: ".date("m-d-Y l",$nextdate1)."<br>";
}


?>

line 62 and 63. comment line 63 and echo emilto as done below

$emailto = $db->loadResult();
//QuoteHunterHelper::dispatchEmail($emailto,$body);
echo $emailto;

See whether you are getting expecting email ids on screen or not;

Make sure you make column of your table PK or unique, so when u insert any duplicate number, query will fail.

do
{
   $no=rand(300,1000);
   $insert="insert into table(column)values ($no)";
   $query=mysql_query($insert);
   if($query)//
   {
     $found=true;
   }
   else 
   {
     $found=false;
   }
}while(!found);

Kindly check mysql syntax, My code may have syntax error;

storing multi values in single field cell is not normalised way of storing data.
YOu must keep table with columns (eventid,user).

Another doubt
you are fetching event id using date. Now if there are two events on same date, then Which event is to be considered.

You may use OR operator, Kindly note the positions of paranthesis.

SELECT SUM(dist)FROM distance dd, tripleg t 
WHERE 
( (t.origin=dd.destination AND t.destination = dd.origin) or  (t.origin=d.origin AND t.destination = d.destination) )

AND t#=1;

My query may cause you problem if there are two enteries for same route, I mean
Adelaide , Melbourne, 400
Melbourne , Adelaide , 400

I hope your table do not have such duplicate values

document.createElement("div");

DO no create new div, rather use existing

.
.
.
var divTag = document.getElementById("my_div");
//       	divTag.id = "div";// do change id of your div
.
.
.
//keep rest code as it is
.
.

Two separte loops executing one by one will always give you unexpected results, in your case. Thats why follow my steps, given in my previous post above.
You need loop in loop (nested loop).

<html>

<script language="javascript">
var curr=0 ;
function addradio()
{
    document.getElementById("my_div").innerHTML=document.getElementById("my_div").innerHTML+
"<br><input type='radio' id='my"+curr+"'  value='Male' name='my"+curr+"'>Male "+
"<input type='radio' id='my"+curr+"' value='Female' name='my"+curr+"'>Female ";
  curr=curr+1;
}
function changeIt()
{

my_div.innerHTML = my_div.innerHTML +"<br>Skills<input type='text' name='mytext[]' value='mytext'>";
my_div.innerHTML = my_div.innerHTML +"<br><input type='radio' id='my' value='mytext' value='male' name='radio[]'>";
my_div.innerHTML = my_div.innerHTML +"<input type='radio' id='my' value='Female' name='radio[]'>";


//var el = document.getElementById('my');
//el.name = 'level';
}
</script>

<body>
<form name="form" action="homep.php" method="">

<input type="button" value="test" onClick="addradio()">
<div id="my_div"></div>
  <input type="submit" name="Submit" value="Submit">



</form>
</body>
</html>

I have changed code between your if(productcount>0)

if ($productcount > 0) {

		 	$colindex=1;
		 	$totcols=2;
		 	$rowclosed=false;
  		    //$totrows=ceil($count/$totcols);
  		    
			$dynamicList .= "<table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"6\">";		 
			
			while($row = mysql_fetch_array($sql)){ 
		             $id = $row["id"];
					 $productname = $row["productname"];
					 $price = $row["price"];
					 $dateadded = strftime("%b %d, %Y", strtotime($row["dateadded"]));
				
				if($colindex==1)
				{
				 
			        $dynamicList .= "<tr>";
			        $rowclosed=false;
		        }
		        $dynamicList .= '<td width="9%" valign="top"><a href="product.php?id=' . $id . '"><img style="border:#666 1px solid;" src="inventoryimages/' . $id . '.jpg" alt="' . $productname . '" width="77" height="102" border="1" /></a></td>
		          <td width="41%" valign="top">' . $productname . '<br />
		            £' . $price . '<br />
		            <a href="product.php?id=' . $id . '">View Product Details</a></td>';
		        
		        $tmp='<td width="17%" valign="top"><a href="product.php?id=' . $id . '"><img style="border:#666 1px solid;" src="inventoryimages/' . $id . '.jpg" alt="' . $productname . '" width="77" height="102" border="1" /></a></td>
		          <td width="83%" valign="top">' . $productname . '<br />
		            £' . $price . '<br />
		            <a href="product.php?id=' . $id . '">View Product Details</a></td>';

				if($colindex==$totcols)
				{

		        	$dynamicList .= " </tr>";
		        	$colindex=1;
		        	$rowclosed=true;
				}
				else
				{
					$colindex++;
				}		     
		    }
			if(!$rowclosed)
			{
	        	$dynamicList .= " </tr>";		    
	        }
		     $dynamicList .= "</table>";
		} else {
			$dynamicList = "We have no Birthday Cards listed in our store yet";
		}

I think you need loop into loop

a) section query
secion loop
{
    display section title
    question query where section =section_loop_variable
    question loop
    {
        display question title
    }
}

try with giving name of columns in query, do not use *,

select sectionid, SurveyID, sectionTitle from section where  where SurveyID =".$_GET['survey'];

or if you are using two tables, then post code and table structure of that table

$sql = "SELECT * FROM tbl_product where fld_type like '%{$type}%'";

select response_id, count(*) tot_questions from 
(

select distinct response_id, question_id from response_bool 
union
select distinct response_id, question_id from response_date
union
select distinct response_id, question_id from response_multiple 
union
select distinct response_id, question_id from response_rank
union
select distinct response_id, question_id from response_single 
union
select distinct response_id, question_id from response_text

)
 WHERE question_id > 118 AND question_id < 148 
group by response_id
ORDER BY response_id;

You just see following line number in my code
10,14,15,18,64,66,68,73

problems
You have not closed your function {}
you are using $password in javascript
you are calling getelementbyID, but you have not set id for your form, name, password element

Also you must ignore using standard html attributes names as name and ID of your elements

<!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=utf-8" />


<script language="javascript" type="text/javascript">
function button1(){
	var user =document.getElementById("go-btn").value;
	if(document.getElementById("password").value!="amry")
alert('You are very brave!');
else 
{
  alert('A wise decision!')
document.getElementById("frm").submit();

}
}
</script>
<title>Login</title>
<link rel="stylesheet" type="text/css" href="1css/css.css" />
<style type="text/css">
<!--

#image{
	
	
	    margin-top: 7px;
}


#images{
	
font-family: fantasy;
    font-size: 8px;	
	
}
-->
</style></head>

<body >

	<div class="login-form">
    	<div id="hedding">
        	<div class="left"></div>
            <div class="main">
            	<div class="text">
                    <span class="heding-txt1">LOGIN AREA</span>
                    <span class="heding-txt2">FOR</span>
                    <span class="heding-txt3">ZMS</span>
                </div>
                
            </div>
            <div class="right"></div>
        </div>
        
            
        </div>
        <div class="enter">
        
        	<div class="form-lft"></div>
            <div class="form-main">
            	<div class="inner-form">
                <form name=frm id=frm action="logindb.php" method="POST" >
                    <label>Username</label>
                    <input type="text" class="input" name="name" id=name/>
                    <label>Password</label>
                    <input type="password" class="input" name="password" id=password />
                </div>
                <div class="buttns">

               /////////// here is the go btn /////////////////
                	 <input type="button"  class="go-btn" value="go-btn" id="go-btn"  onclick="javascript:button1()"/>
                     <input type="submit" class="lost-btn" value="go-btn" id="lost-btn" />
                </div>
                </form></div>
			<div class="form-rght"></div>
        
        </div>
    </div>	
        
        
        
</body>
<div id="image"><center><img src="222071_1941814027700_1312940202_2218448_386665_n.jpg"/></center>
</div>
<div id="images"><center>Developed by AMRY Soft</center></div>
</html>

what I have suggested will be done at client side using javascript and without submitting a form. In my code case user may select invalid date but can not submit that invalid date.

if you want to use php then you must use ajax or you must submit form.

Do not restrict select element by user choice. You must try to to validate date after user submits the form using some javascript function.

<script lang='javascript'>

var daysOfMonth = new Array(
  31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31
);

var daysOfMonthLY = new Array(
  31, 29, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31
);
function isLeapYear(year) {
  year = year - 0;
  if ((year/4)   != Math.floor(year/4))   return false;
  if ((year/100) != Math.floor(year/100)) return true;
  if ((year/400) != Math.floor(year/400)) return false;
  return true;
}

function isValidDate(day, month, year) {
  day = day - 0; month = month - 0; year = year - 0;
  if ((isLeapYear(year) && day > daysOfMonthLY[month-1]) ||
     (!isLeapYear(year) && day > daysOfMonth[month-1]))
    return false;
  else
    return true;
}


function checkdate()
{


	if (!isValidDate(document.register.day.value, document.register.month.value, document.register.year.value))
	{
	 	alert('Invalid Date');
		document.register.day.focus();		 	
		return false;
	}
}
</script>

no its javascript syntax we can not play with it. You may learn it at

http://www.w3schools.com/jsref/jsref_obj_regexp.asp

First thing is you must write
Check2(document.myform3.Check_ctr) instead of
check2(document.myform3.Check_ctr) (Capital C in check2 because javascript is case sensitive.

I have changed whole code as following, keeping name and ID same, using checkbox array (easy to process in php after submission)

<head>
<SCRIPT text/javascript>

function Check1()
{
  var intCounter = 0;
   for(intCounter=0;intCounter<=document.myform3.elements.length-1;intCounter++)
    {
      if(document.myform3.elements[intCounter].type=="checkbox")
      {
          document.myform3.elements[intCounter].checked= document.myform3.Check_ctr.checked ;
       }
   }
}

function Check2(chk)
{
	
	if (chk.checked)
  	  document.myform3.Check_ctr.checked =true;
}

</script>
<body>
<form name="myform3" method="post" action="post_php">
<table align="center" width="370px" border="0">
<tr>
	<td width="250px">Item</td>
	<td  align="center" valign="middle">Tick to Display</td>
</tr>
<tr>    
        <td>Project Name: </td>
        <td align=center valign=middle><input type="checkbox" name="Check_ctr" id ="Check_ctr" value="yes" onclick="Check1()" /></td>
</tr>
<tr>
	<td>&nbsp;</td>
	<td valign=middle align=center><input type="checkbox" name="check_list[]" value="1" id="check_list[]" onclick="Check2(this)"/></td>						
</tr>
<tr>
	<td>&nbsp;</td>
	<td valign=middle align=center><input type="checkbox" name="check_list[]" value="1" id="check_list[]" onclick="Check2(this)"/></td>
</tr>
<tr>							
	<td>&nbsp;</td>
	<td valign=middle align=center><input type="checkbox" name="check_list[]" value="1" id="check_list[]" onclick="Check2(this)"/></td>
</tr>
</table>
<input type="submit" name="submit" value="Save Changes" />

<html>
<head>
<script type="text/javascript">

isFirstName = /^[A-Za-z\ \-]+$/;
isAge       = /^[1-9]\d{0,2}$/;

function check()
{
   if (!isFirstName.test(document.getElementById("name").value))
    {
     alert("invalid age");
    
    }


   if (!isAge.test(document.getElementById("age").value))
    {
     alert("invalid age");
    }
}
</script>
</head>
<body>
<form>
Age: <input type="text" id="age" size="30"><br />
Name: <input type="text" id="name" size="30"><br />
<input type="button" value="Check" onclick=check()>
</form>
</body>
</html>

$num = "/webroot/imagerfoldername/".$files[$i];

index.php

<iframe src='all.php' > </iframe>

OR

include('all.php');

I have given infolist column alias, you can use it in your php code.

$information = mysql_query("SELECT informationtype, status ,
         GROUP_CONCAT(DISTINCT informationno 
                   ORDER BY informationno SEPARATOR ',') as INFOLIST
         FROM table
         WHERE informationtype='message' AND status='waiting'
         GROUP BY informationtype, status");

simple solution is make billnumber uniquekey

there is extra comma after dec_count,

it should look like dec_count (remove comma)

$result=mysql_query("SELECT count(*) total
, sum(if(`status` = '".constant('REFERRAL_STATUS_COMPLETED')."',1,0)) com_count
, sum(if(`status` = '".constant('REFERRAL_STATUS_DECLINED')."',1,0)) dec_count,
, sum(if(`status` = '".constant('REFERRAL_STATUS_REFERRED')."',1,0)) ref_count
FROM ".constant("TBL_USER_REFERRALS")." where `referrer_uid`='$referrer_uid' ");

post your mysql table script with some sample data of all four types

$result=mysql_query("SELECT count(*) total, sum(if(`referrer_uid`='abc',1,0) abc_count,
, sum(if(`referrer_uid`='pqr',1,0) pqr_count,
, sum(if(`referrer_uid`='xyz',1,0) xyz_count
FROM ".constant("TBL_USER_REFERRALS"));

output

total, abc_count, pqr_count, xyz_count
45, 10, 15, 20

You can access result as you access any other mysql result by using column name

if you are not keeping billnumber blank and if you can insert billnumber with orderid, then simply define billnumber as unique key. Then it will not allow duplicate billnumbers.

I faced same problem, I guess your billnumber column may remain blank for sometime.
So I created on more table say billmaster (billnumber pk). If you want to generate bill number every year then (billnumber pk, year pk).

Now in your billnumber generation. you fetch max number from billmaster table then insert it in billmaster table, return that billnumber to calling insert statment.

I am sure duplication will never happen again.

Here is your query

$information = mysql_query("SELECT informationtype, status and informationno,
         GROUP_CONCAT(DISTINCT informationno 
                   ORDER BY informationno SEPARATOR ',')
         FROM table
         WHERE informationtype='message' AND status='waiting'
         GROUP BY informationtype, status");

I have added else part

if($value != 'No Preference')    
{          
        $arrQueryParts[$key] = " AND ".ucwords($key)."='".$value."'";    
}
else
{          
        $arrQueryParts[$key] = "";    
}

I have added else part

if($value != 'No Preference')    
{          
        $arrQueryParts[$key] = " AND ".ucwords($key)."='".$value."'";    
}
else
{          
        $arrQueryParts[$key] = "";    
}

If you have more than one textbox with same id that is qty in then that may create problem

Then you need to create javascript function. and you must use on_blur even on qty textbox.

what are you expecting,

1) you want to show amount the moment user enters one qty
or
2) you want to calculate amount when user all qty, submits page, then show amount for all row

attach your php page and mysql script for this table here

do not disabled rate text box, use readonly

remove disabled="disabled"

<td class="rate"><input name="prate" type="text"             class="prate" id="prate" value="<?php echo $prate;?>" readonly="true" /> </td>