1,257 Posted Topics
 | line 62 and 63. comment line 63 and echo emilto as done below [code] $emailto = $db->loadResult(); //QuoteHunterHelper::dispatchEmail($emailto,$body); echo $emailto; [/code] See whether you are getting expecting email ids on screen or not; |
| | |
| | I think you can do 1/0 using only left outer join (creaing views) instead of using nested stored procedure. If you could post structure of your table, then I could help you to create view for it. |
| | You may use OR operator, Kindly note the positions of paranthesis. [code] 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; [/code] My query may cause you problem if there are two enteries for same route, I … |
| | [code] select a.id, a.name,count(*) total from games a left outer join ( select favorite_game_01 id from persons union select favorite_game_02 id from persons union select favorite_game_03 id from persons union select favorite_game_04 id from persons union select favorite_game_05 id from persons ) b on a.id=b.id where b.id is not null … |
 | Re: HTML forms Only HTML will not help If you want to show images on next page, You have to upload it first, Or you may give comments and title fields along with browse button on first page itself. To upload and store comments you need to use php/mysql (or any other alternative). |
| | This query is assuming that your table will have only one record for each year, that is for 2001 there is only 1 record in your table and like that for every year. [code] SELECT a.id, a.date, a.value, SUM( b.value ) prev FROM `tablename` a LEFT OUTER JOIN prevsum b … |
 | |
| | Re: query problem try with giving name of columns in query, do not use *, [code] select sectionid, SurveyID, sectionTitle from section where where SurveyID =".$_GET['survey']; [/code] or if you are using two tables, then post code and table structure of that table |
| | Re: find time <script lang='javascript'> var d = new Date(2011,04,11,15,33,43); //month index starts from 0-11 d.setHours(12); alert(d) </script> [url]http://www.w3schools.com/jsref/jsref_obj_date.asp[/url] |
| | Do not use any font, Unicode is best option for storing data in local languages. |
| | How you can you verify and charge card without using payment gateway (intermediate service). As far as I know, direct payment is not at all possible. |
| | you must post your whole code, do not post part code. |
| | [QUOTE]document.createElement("div");[/QUOTE] DO no create new div, rather use existing [code] . . . var divTag = document.getElementById("my_div"); // divTag.id = "div";// do change id of your div . . . //keep rest code as it is . . [/code] |
| | first of all, set id for your TR [code] <tr id=myrow style='display:block'> . . . </tr> [/code] now add few lines in calculate total function [code] function calculatetotal() { . . . . . if(text1.value==text2.value)//here use proper syntax according to your elements { ///hide row document.getElementById("myrow").style.display='none'; } else { //show … |
| | I have changed code between your if(productcount>0) [CODE] 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 … |
| | I think there is no row in your database with email id "hehe@live.com.my", if it is there then change your line number 5 in above code with following line [code] echo $qryGetName = "SELECT username FROM user_info WHERE trim(email) = trim('".$get_staffemail[$i]."') "; [/code]  |
| | [code] <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' … |
| | [CODE] "<select name='ccrseid' MULIPLE SIZE=10>"; [/CODE] If you want to do things without submitting, then you must use javascript to do so. |
| | refer your another thread [URL="http://www.daniweb.com/web-development/javascript-dhtml-ajax/threads/364662/1561706#post1561706"]http://www.daniweb.com/web-development/javascript-dhtml-ajax/threads/364662/1561706#post1561706[/URL] |
| | if you have placed checkbox chk_list[] in the html <form> element, then you can submit the form with action=some.php. Now in your php file you will get array of selected values $_POST['chk_list'][0] $_POST['chk_list'][1] $_POST['chk_list'][2] . . . . $_POST['chk_list'][n] Here n is number of selected check boxes, Here Unselected checkboxes … |
| | 1) why you are hard coding '68502' in your query. You must pass some get/post variable for getting the dynamic content. 2) $zip11 = $row['postnet ip']; // YOu are fethcing things in zip11 but then you are not making use of it, why? Also explain your problem little bit more … |
| | [code] $query="SELECT registered_members.firstname,registered_members.lastname,registered_members.member_id,friends.m_id,friends.f_id,friends.restriction FROM registered_members,friends WHERE (m_id=$id AND f_id=$x_id AND restriction='green') OR (f_id=$id AND m_id=x_id AND restriction='green')"; echo $query; $result = mysql_query($query); [/code] Echo the prepared query string before executing it. Then copy it, run in phpmyadmin. Find out the error there and then correct your php code. |
| | Re: oracle forms I think you want to do following 1) press button on form1 2) in pl sql code of button, open form2 with some parameter Steps for achiving this 1) in form two in object navigator mode you will file one node called PARAMTERS add you paratmeter as many you want … |
| | First thing is that 2 FKs on same field is not a good idea and it will never work, I do not know how mysql allowed it. Even if it work how you will know, when you look into your order, that who ordered this, customer or admin. Also why … |
| | The code is finding sum of array values using recursive method var numArray = ['1','35.4','-14','44','0.5']; Here you can change the values and check the result. as it is called onload, everytime you have to open link in fresh page, refresh may not work sumNumbers() functions accepts 3 arguments, data array, …  |
 | Re: php mysql search [code] $sql = "SELECT * FROM tbl_product where fld_type like '%{$type}%'"; [/code] |
| | [code] 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 … |
| | Re: Pop in php [QUOTE] onblur="alert('[/QUOTE] Above is nothing but javascript. I think you want to say that, you do not want to use javascript function. |
| | You may also try xajax ready to use library. Its good and fast. |
| | 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 … |
| | this is just overview who you can get your result. Your case is dynamic, so you may build following query in you code page using for loop and iterating through function master table. [code] SELECT a.USERID, b.username, min(case when a.functionid=3 then a.functionid else null end) f1, min(case when a.functionid=5 then … |
| | you must use form tag in between, then define one hidden input. When user submits the form, set hidden input using your myfunction, and then process the form(insert the submited hidden value) in the form action page. |
| | |
 | I think coach is not directly related to member, coach is related to member through sport. |
 | post following 1) full structure of your views with sample data. 2) full query you are trying to get result 3) sample result expected from sample data above  |
| | I have added ID PART, you have kept it blank. [code] <form id=frmContactUs name="frmContactUs" action="ContactUs" method="post"> [/code] |
| | I think you should not play with your javascript, instead you must use your post variable with html input element. like <input name="chooseDonation" type="radio" id="chooseDonation" onClick="showhidefield('once')" onmouseup="" value="onetime" [B][COLOR="Red"]<?php=($_POST['freq']=="once")?checked:'';?>[/COLOR][/B] /> -or- Monthly Donation: <input name="chooseDonation" id="many" type="radio" value="monthly" onmouseup="" onclick="showhidefield('monthly')" [B][COLOR="Red"]<?php=($_POST['freq']=="monthly")?checked:'';?>[/COLOR][/B] />  |
| | Re: Leap Year in PHP Do not restrict select element by user choice. You must try to to validate date after user submits the form using some javascript function. [code] <script lang='javascript'> var daysOfMonth = new Array( 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 ); var daysOfMonthLY = new Array( … |
| | on submit you can go on appending content to outerdiv by keeping currentframeno variable. everytime user submit, increment your currentframeno by one and append [code] document.getElementById("outerdiv").innerHTML=document.getElementById("outerdiv").innerHTML+"<iframe name='frame"+currentframeno+"' id='frame"+currentframeno+"'>your content</iframe>" [/code] |
| | Re: Object Expected 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) [code] <head> <SCRIPT text/javascript> function Check1() { var intCounter … |
| | [code] <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> … |
| | http://api.search.yahoo.com/WebSearchService/rss/webSearch.xml?appid=yahoosearchwebrss&query=originurlextension%3Apdf+$search&adult_ok=1&start=$start your above is not returning proper output, there is error on that server |
| | Here is your query [code] $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"); [/code] |
| | index.php [code] <iframe src='all.php' > </iframe> [/code] OR [code] include('all.php'); [/code] |
 | if you are looking for $tld in your server list then you can do it directly [code] $serverlist=array(........);.//your serverlist array $tld="org"; $key = array_search($tld, $array); echo $key;//returns 3 [/code] |
| | 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 … |
| | [code] $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")); [/code] 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 |
| | [code] $myurl="About us"; $mynewurl=strtolower(str_replace(" ","",$myurl)); [/code] |
| | Somebody will only able to help you, if you do not post your code or sample here. No body can visualize by just reading the statement. |
The End.