1,257 Posted Topics
 | I agree with the solution provided by adam_k [CODE]SELECT Col1 + CHAR(13) + CHAR(10) + Col2 FROM test[/CODE] It may not shown in query result. but in text area or in your multi line text box new line will be visible. |
 | Re: session Start with php tag. Do not keep any space, newline or any Character in the beginning. Here <body> and newline creating problem. [CODE]<?php //start session session_start(); include("includes/header.php"); //unset any session data until user submits valid username and password // this is correct way not unset($_SESSION), sorry my mistake // see … |
| | Re: Get Total [CODE]<html> <head> </head> <script lang='javascript'> var amount1=12345678.10; var amount2=87246125.00; var d=amount1.valueOf()+amount2.valueOf(); alert(d); </script> </html>[/CODE]  |
| | YOu should also tell what is the problem in displaying. Whats happening and whats NOT happening. |
| | 1) open formularz.php in line number 2 set action to jak_kupic.php [code]<form action="jak_kupic.php" method="post" id="form1">[/code] save formularz.php and upload on server 2) [COLOR="Red"][B]DO NOT[/B][/COLOR] open jak_kupic.html. now open [url]www.hogar-biokominki.pl/formularz.php[/url]  |
| | Problem is in your primary key. I guess you want to update all item related to say body number 1 at the same time. But you must also need one key to identify row in the table paint shop. So your update statement is using only one where condition. You … |
| | remove SRC tag, HREF itself is enough. [CODE]<html> <head> </head> <body> <a href ="what_the.html">go </a> </body> </html> [/CODE] |
| | [CODE] $memque="select * from tblevent where member like '%5%' ";[/CODE] OR [CODE]$filter="5"; $memque="select * from tblevent where member like '%{$filter}%' ";[/CODE]  |
| | Re: Add a new column [CODE]ALTER TABLE tbl_oppourtunities ADD col1 varchar(20), add col2 varchar(25);[/CODE]  |
| | what is ur sample data in tbldepositpaymentdetails, then also what u want as output post sample input and sample output here |
| | [CODE]Select sum(od.unitprice * od.quantity) as Amount, ContactName as customername from [Order Details] as od inner join orders as o on o.orderid = od.orderid inner join customers as c on o.customerid = c.customerid group by o.customerid,ContactName order by amount desc limit 1 [/CODE] |
| | I hope you will get your model here [url]http://www.databaseanswers.org/data_models/[/url] More precisely [url]http://www.databaseanswers.org/data_models/libraries_and_books/index.htm[/url] |
| | change your line with line given below [CODE]echo $buyer_query="select * from buyer_detail where company_id='{$row['c_id']}' AND buyer_id='{$_GET['buyer_id']}'"; [/CODE] |
| | Re: Date_format SINGLE QUOTE IS INVALID AROUND DATEFIELD, its a column name not a text, so remove single quote surronding 'datefield' [CODE] $query="SELECT * FROM table DATE_FORMAT(datefield,'%d-%m-%Y')AS datefield FROM table";[/CODE] |
| | |
 | Best is to use paypal, they have api and manuals to integrate any web application with their payment gateway. |
| | Re: Report! to convert rows to column you need to do following query [CODE]select detail.MatId, SUM( case when header.InvTransTypeId = 'in1' then Quantity else 0 end) as IN1, SUM( case when header.InvTransTypeId = 'OU1' then Quantity else 0 end) as OU1, SUM( case when header.InvTransTypeId = 'TK1' then Quantity else 0 end) … |
| | Kindly explain bit more what exactly you are looking for. because I am not able to understand your case. Another little long way to do is I suggest you one thing, If you have control over adding columns to seat master table. You add one numeric order_no column. so when … |
| | I could give you query, you find out asp.net syntax to connect it to database and fetch the total column value [CODE] select invoice_no, sum(dabit) total from table name where invoice_no=111 group by invoice_no[/CODE] |
| | where ur starttime endtime stored? In mysql or you want calculation in php |
| | This is what you are looking for, But right now its not working in IE, u may try on other browser and then later you can build your logic more using this code. [CODE]<html> <head> <style type="text/css"> .answerBtnsOff { BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #666666 1px solid; BORDER-LEFT: #666666 1px solid; BORDER-RIGHT: … |
| | I think you should get the result in some php variable. or I think follwing link may help you [url]http://devzone.zend.com/node/view/id/651[/url] |
| | why you want to add one more field, One thing I feel is that your database is not normalized. Now if this it is mandatory requirement, then you can do one thing you must be having action page to insert or update mysql data, while inserting query you join from … |
| | do not add .$salt to md5 with password [CODE]md5(mysql_real_escape_string($newpassword))[/CODE] |
| |  |
| | In the beginning of your code write following two lines, it will show ur exact error. [CODE] error_reporting(E_ALL); ini_set("display_errors", 1); [/CODE] |
| | what you have done so far? post your code, and tell whats NOT happening. |
| | Re: MS Access Query dont start form, first make clear what you want in database. post your columns you want to keep in 3 tables. if you once identify relation between the tables , your query will automatically join appropriate tables and will give you perfect result.  |
| | you should keep an index or row number [CODE]$i=0; while($row = mysql_fetch_array($result)){ echo "<form>"; $_SESSION[$i]['category'] = $predictrow['category']; echo "<input type=hidden name=clickindex id=clickindex value={$i}>"; $i++; echo "</form>"; } [/CODE] now in your action page(predictproc.php) you can use clickindex variable [CODE]<?php $index=$_POST['clickindex]; echo $_SESSION[]['category']; ?>[/CODE]  |
| | |
| |  |
| | First you create a action page in php which will return you latest info you want to display. I mean I guess you know using ajax or jquery to post and retrive data. Now You call that ajax/jquery function using timer jquery tutorial u may find here [url]http://phpacademy.org/videos/index.php?all[/url] |
| | Re: Compare 2 years I think just write -1 there in interval [CODE]SELECT monthlycommission.YearPaid, sum(monthlycommission.Amount)CommissionPaid, monthlycommission.MonthPaid FROM monthlycommission WHERE DatePaid is not null and DATE_SUB(NOW(), INTERVAL -1 YEAR) GROUP BY MonthPaid ORDER BY DatePaid ASC[/CODE] |
| | Re: unlike function Your web user on the server has no permission to access that file. So its not possible to delete file without full privilege. |
 | Capthcha is used to avoid spam generated by bots, it can not defeat or restrict a human. |
| | when you click on logout, you must call some file say logout.php in which you must destroy session like [CODE]<?php session_start(); session_unset('userid'); session_unset('username'); session_destroy(); header("Location: login.php"); ?>[/CODE] |
| | modify line 250 (prodid to prodid_h4), make sure you do not use same id for any element of html, whether div, text, para whatever [CODE]<h4 id="prodid_h4">Product ID: </h4>[/CODE] at line 340 (after sameadd function) add line [CODE]document.getElementById("prodid").value = document.getElementById("prodid_h4").value;[/CODE] |
| | [CODE]<script lang='javascript'> function makeBlank(obj,defMsg){ if(obj.value==defMsg){ obj.value=""; } } function fillDefValue(obj,defMsg){ if(obj.value==""){ obj.value=defMsg; } } </script> <input style="width:190px" onblur="fillDefValue(this,'User Name')" onfocus="makeBlank(this,'User Name')" value="Name" name="fromname" id="fromname" type="text">[/CODE] |
 | |
| | Just treat it as a button, use onclick event to do whatever you want [CODE]<div class="status"> <textarea class="input" name="status" id="content" > So whats on your mind? </textarea> </div> <div class="button_outside" id="share" onclick="javascript:alert('hi')"> <div class="button_inside">Share</div> </div>[/CODE] |
| | post whole code, and explain more what you are trying to do |
| | If following query does not work, then tbl_employee is not contaning e_name column. check spelling in your structure. [CODE] select tbl_employee.E_Name,sum(tbl_Salary.Amt),tbl_Dpt.DeptName from tbl_employee inner join tbl_Salary on tbl_employee.eid = tbl_Salary.eid inner join tbl_Dpt on tbl_Salary.eid = tbl_Dpt.eid where tbl_employee.eid ='E101' group by tbl_employee.E_Name,tbl_Dpt.DeptName [/CODE] or try query with only department … |
| | You are not loosing anything actually, at a time you can handle only one form request. If you submit form1 then only email and mail-submitting will be sent to action page If you submit form2 then only email,subject and contact-submitting will be sent to action page  |
| | Re: checked checkbox [CODE]<td> <input name="power" type="checkbox" disabled="disabled" <?php if($row['power_backup']=='on') echo "checked"; ?> /> </td> <td><?php if($row['power_backup']=='on') echo "<b>Power Backup</b>" else echo "Power Backup"; ?></td> <td style="width:25px;"> <input name="purifier" disabled="disabled" type="checkbox" <?php if($row['water_purifier']=='on') echo "checked"; ?> /> </td> <td><?php if($row['water_purifier']=='on') echo "<b>Water Purifier</b>" else echo "Water Purifier"; ?> </td>[/CODE]  |
 | Re: Form feature 1) Either you can create adminpanel for him where you create php pages (that will manage database) 2) your client directly make changes to database using available tools like phpmyadmin for mysql(this is dangerous if client is IT illiterate) |
 | 1) remove space between <? PHP, it should read <?PHP 2) add semicolon to line number 17 in above code in the end |
 | One thing is that mysql itself takes care and do not update a row if there is no change. Still if you want to include it in your code, then when you load your page with database values, then you also add one more hidden field, say original_qty, Now when … |
| | better if you keep condition in your stored procedure and not in your front end [CODE]'@category as varchar(50), Session("Category") = DDLBuildingType.Text '---------------------------------------- Dim parameterCategory As SqlParameter = New SqlParameter("@category", SqlDbType.VarChar, 50) parameterCategory.Value = Session("category") myCommand.SelectCommand.Parameters.Add(parameterCategory)[/CODE] [CODE]set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[Search_Realestate] ( @RegID as varchar(50), @category … |
 | try [url]http://localhost/password_test/index.php[/url] in browser  |
 | After completing the operation you can set format by following code. So just set your format for the range [CODE]Range("C1").Select Selection.NumberFormat = "dd/mm/yyyy hh:mm:ss" 'Date as10/06/2005 Selection.NumberFormat = "dd/mm/yyyy hh:mm" No seconds displayed Selection.NumberFormat = "dd-mmm-yyyy hh:mm:ss" 'Date as 10-Jun-2005 Range("D1").Select Selection.NumberFormat = "@" 'Text[/CODE] |
The End.