Posts by urtrivedi

I think its depend on how you use php or any other application to pass information to mysql server.
In phpmyadmin when i pasted नमस्कार, it is stored well in same way (i m using utf8* collation)

Also if you store codes in mysql, that also can be represented in language word on browser very well.

So just check your database updating pages, how they behaving.

try storing collation as utf8_general_ci for the varchar/text column, then normal update insert will save it in unicode

select * from table
where DESCRIPTION LIKE "%searchterm1%" or
DESCRIPTION LIKE "%searchterm2%" or
DESCRIPTION LIKE "%searchterm3%" or
DESCRIPTION LIKE "%searchterm4%"

select * from users where id not in (select userIdRec from quiz)

I think on your server created date is 000000.

AND must follow boOlean result. you are giving subquery to AND

tell us :
table strutrute
sample data
sample expected output

You should keep only one variable lik
SESS_LEVEL user that everywhere, do not user separate variables.

after header function always write exit, to avoid further execution of page

header("xy.php");
exit;

because when u pass "click" variable in fucntion, it overrides global "click". so do it without function variable.

As far as I know (my attempt failed in past) I think on network drive, you can not host apache server.

So if you have some space in your physical harddrive, there you can assing folder for hosting.

Install Apache
Install PHp
Install Mysql

All msi setups available, for windows platform, on there respetives sites.

I will use absolute position styel for all five divs like shown below, just change top left for others

#div1 {
position:absolute;
top:1px;
left:300px;
}

I hope this is what you are looking for:

select t.* from trans_table t left outer join position_table p on t.trans_id=p.pos_trans_id
where p.pos_trans_id is null

you are overwriting pervious value, keep on appending as shown below, with + before =

document.divfrm.div.value+=d;
document.divfrm.div.value+=sp;

post your code, without code no body can help.

that function if finds new line in string, it renders it to html <br> tag.

how it is stored in mysql, Is it in one column one row, or all features are in separte record?

If it is strored using textarea (with user manually breking line in textarea) then following trick may work, no need of \n

echo nl2br($features_db);

SELECT C.theDate, IFNULL( sum(case when DATE( CAST( H.timeentry AS DATE ) ) is null then 0 else 1 end), 0 ) AS countForDate
FROM calendar AS C LEFT JOIN history AS H
ON C.theDate = DATE( CAST( H.timeentry AS DATE ) )
WHERE YEAR(C.theDate) = YEAR(NOW()) AND MONTH(C.theDate) = MONTH(NOW()) and
C.theDate BETWEEN '2012-12-1' AND '2012-12-07'
GROUP BY C.theDate
ORDER BY C.theDate 

before running query echo its output and run in phpmyadmin or observe prepared query statment

echo $result;

mysql_query($result);

if u echo $txt7 alone, do it printt anything

write full code how / where u set $txt7

echo substr($txt7, 0, 200);
if(strlen($txt7)>200)
    echo "...";

echo nl2br($info['content']);

put echo /table out of while loop (see line 24,25,26 they shold look like following)

}
echo "</table>";
mysql_close($con);

but is it available in scope of setBill() function

you may debug or set print/message box in setbill fuction for txtRegistration

your query is fine. just check what you getting in POST array when you submit form place following code in the begining of your page after first php tag

<?php
echo "<pre>";
print_r($_POST);
echo "</pre>";
die('stop to check post array');

txtRegistration field is not having value , before calling function, make uset that field has some value.

what is that 3 times asterisk sign around header function on line 100?
***

what is ur table structure and what is ur purpose(what u want to update with what value)?

Only query is not enough to understand your problem.

I put group by in query and put conidtion outside of while to show "no-record"

<?php

include 'db.php';
$term = $_POST['EAN'];
$term = TRIM($term);

$sql = mysql_query("SELECT Name, Brand, EAN, sum(orderedquantity) As SumS 
FROM $salesdb 
WHERE EAN LIKE '%$term%' group by  Name, Brand, EAN Limit 0,5");
$i=-1;
while ($row = mysql_fetch_array($sql))
{
    $i++;


    Print '<table style="width:100%;margin-left:auto;margin-right:auto" border=1><font face=arial size=2 >
<tr><td>Sales 2012:<b>'.$row['SumS'].'</b></td></tr></table>';
}


if($i==-1)
{
    Print '<table style="width:100%;margin-left:auto;margin-right:auto" border=1><font face=arial size=2 > <tr><td>Sales 2012:<b>"None Sold"</b></td></tr></table>';

}


?>

line 11 must have double equal to, comparison, u put only 1

if($row['field4'] ='')

make it

if($row['field4'] =='')

post complete code

VALUES ((1, 'Port

there is extra ( after values remove one from it

var beaches = [
  ['Miskolci road / Shell Station', <?php echo $row[2]; ?> , 4],

u can close this thread now by setting solved

try this also

select  tbluser.username, tblrewards.title 
FROM tblwinners inner join tbluser on tbluser.customer_id = tblwinners.customer_id
inner join tblrewards on tblwinners.reward_id=tblrewards.reward_id

my second query failed becaseu your completereward and rblwinners having both rewardid and cust_id, the momement i join both on customer id (only diff between qery1 and query 2), query return null

This is not good way but i add distinct to first query try this

select distinct tbluser.username, tblrewards.title 
FROM tblwinners inner join tbluser on tbluser.customer_id = tblwinners.customer_id
inner join tblcompleterewards ON tblwinners.reward_id = tblcompleterewards.reward_id 
inner join tblrewards on tblcompleterewards.reward_id=tblrewards.reward_id

what is relation between reward and complete reward, how and when rows stored in them

just add distinct to my first query after select word

what error it gives?
is it syntax error in query or result not proper?

I hope this works

select tbluser.username, tblrewards.title 
FROM tblwinners inner join tbluser on tbluser.customer_id = tblwinners.customer_id

inner join tblcompleterewards ON tblwinners.reward_id = tblcompleterewards.reward_id 
and tblwinners.customer_id = tblcompleterewards.customer_id 

inner join tblrewards on tblcompleterewards.reward_id=tblrewards.reward_id

This query will list completed awards winner,

select tbluser.username, tblrewards.title 
FROM tblwinners inner join tbluser on tbluser.customer_id = tblwinners.customer_id
inner join tblcompleterewards ON tblwinners.reward_id = tblcompleterewards.reward_id 
inner join tblrewards on tblcompleterewards.reward_id=tblrewards.reward_id

post latest one

I was expecting the query u have written so far. Your efforts

post your query u have written so far

see line 64 to 68, i m updating it in our code

  while ( $row = mysql_fetch_array( $result ) ) 
  {
      if($row['bankID']==$_POST['bankID'])
         $selectbank=" selected ";
       else
         $selectbank="";
      ?>
      <option value="<?php echo $row['bankID']; ?>"  <?php echo $selectbank;?> ><?php echo $row['bank']; ?></option>
       <?php
      }

is it on live server or on your computer?
and if u click refresh its stays to same qustion or it moves to next question?

what u showing above is ur compolete code, or still u have anything more

you place limit 1 in your query so it is giving only 1 record in output

u check that query, does in mysql (may be phpmyadmin) runs and gives 2 record or 1

$evaluationid

this may be blank or not set, check how u set $evaluationid

where will come first, and order by later
SELECT * FROM questions WHERE (evaluationid=".$evaluationid.") ORDER BY id ASC LIMIT 1"

http://www.w3schools.com/php/php_file_upload.asp?output=print