I want to search a combination of values from any given field that has a list of items. Example: id | nume | denumiri_job 1 | my_list | chair,apple,snake,can How can I search for 2 or more elements from the field list? For example if I input in my search bar the values 'chair snake' I want to get all the rows that contain these 2 items in the denumiri_job column. Right now I can only get the results if I use one search key at a time. So far this is how I managed my code: $query = "SELECT …

Member Avatar
Member Avatar
+0 forum 7

How to remove duplicate mobile numbers from input text box1 and print the result into text box2. Example mobile nos: 7795012345 7795012345 7795012345 7411312354 7411312354 9900454321 9900454321 9632554123 9632554123 output should be: 7795012345 7411312354 9900454321 9632554123 <?php $myarray = array(); $myarray['numbers']=$_POST['numbers']; foreach($myarray as $num){ $numbers=$num; } $unique = array_unique($numbers); $output=implode("<br />",$unique); ?> <form method="post"> Result <textarea rows="5" cols="30"><?php echo $output;?></textarea><hr/> <textarea name="numbers" class="span8 note" id="numbers" rows="5" cols="30"></textarea><hr/> <input type="submit" value="ADD"/> </form>

Member Avatar
Member Avatar
+0 forum 8

Cell C4 has the expression =565+660+709+1093 Is there a function/nest of functions that can output the number of values being added? BIG NOTE: I AM NOT ASKING FOR THE SUM OF THE EXPRESSION!

Member Avatar
Member Avatar
+0 forum 1

Hi Everyone. this is the last part of my function Case "December" If cbMonthly.SelectedItem = "December" Then Dim DecStart As String = "-12-01" Dim DecFin As String = "-01-01" M12S = String.Concat(Year, DecStart) M12F = String.Concat(Year, DecFin) End If End Select Dim Places As New List(Of String) Places.Add(M12S) Places.Add(M12F) Return Places in my button click event, which calls my function, i get an out of bounds error Dim Places As New List(Of String) GetMonth() Dim M12S As String = Places.Item(0) Dim M12F As String = Places.Item(1) Can anybody tell me what i am doing wrong. Many Thanks

Member Avatar
Member Avatar
+0 forum 1

Hey guys! I am trying to map the following dictionary <int,List<T>>. I am trying to get the i-th permutation of an input array, the List<t> being the i-th perm itself. If I have: Input Array [1,2,3], the 0-th perm would be [1,2,3], the 1-st [1,3,2] and so on... So, so far, the Dict would have {[0,{1,2,3}] , [1,{1,3,2}]}. All sounds great, but after i reach i = 2 and need to carry on, I just don't seem to be able to get the next permutation list back! Help! public class LehmerCode<T> { public LehmerCode() { } private List<int> GetFactorial(int nthPerm, …

Member Avatar
Member Avatar
+0 forum 1

I am maybe blind or so... just got nearly the same problem as before. I not get the values of the selectfields. I got 0 - 8 instead of some strings. Here is the url: http://web159.login-142.hoststar.ch/memberd/de/prices/ Here is my code I use to get it: # read size of one of these arrays $count = count($_REQUEST['BX_NAME']); # loop for($i = 0, $e = 1; $i < $count; $i++, $e++) { $divers.= "Diver/PAX #{$e}: Name: $BX_NAME[$i] / Shoe-Size: $BX_shoesize[$i] / Weight: $BX_weight[$i] / Heigth: $BX_height[$i]<br />"; } I did a postdump and this works, I mean I get and see what …

Member Avatar
Member Avatar
+0 forum 1

Hi all, I am trying to compare output from DB The code below works on 1 check, but I require to do this on multiple products like so `if rowProduct("GRPCODE") <> "Cross Hire" or rowProduct("GRPCODE") <> "Boiler Ancillaries" then` etc but the above line does not work as I have coded it? What is the problem with the code. Thanks in advance if rowProduct("GRPCODE") <> "Cross Hire" then ' Elimination unwanted code if not rowStock.eof then ' stock found do while not rowStock.eof ' loop through stocl if instr(RemoveItems, "," & rowStock("ITEMNO") & ",") = 0 then ' item not …

Member Avatar
Member Avatar
+0 forum 1

Im working on a small block of code that compares a argumented value to a file seached value. Every time i run the code it and give it the argumented value either lower or higher than i know the searched value is it gives me the opisite answer of what i want. import requests, shutil, datetime, glob, os, csv,fnmatch,StringIO,smtplib,argparse from email.MIMEMultipart import MIMEMultipart from email.MIMEText import MIMEText from os import path parser = argparse.ArgumentParser(description='Search art folders.') parser.add_argument('-b', help='The base path', required=False, dest='basePath', metavar='Base directory path',default='/home/hatterx/Desktop') parser.add_argument('-s', help='Change File size', required=True, dest ='changesize', metavar='Change size', default='0') parser.add_argument('-S', help='Change File Size', required=True, …

Member Avatar
Member Avatar
+0 forum 1

Salam... I have SQl Database...And i am using visual basic 2010 i have a problem with Null values.When in my database data have some null values then data not showing in my crystal report ...crystal report showing blank..I want '0' when data is null..for example my table name is (meetings with organization) and field name (Nature of meeting) which has 3 types 1 meetings 2 school visit when in these types have no meetings data not showing in crystal report.please help me ...how to show '-'/'0' in crystal report when data have null values,please send me code..and sorry for my …

Member Avatar
Member Avatar
+0 forum 4

Hi all. Have been racking my brains about how to go about creating a multidimensional array dynamically from an array of keys. Something like... $keys = array('key1', 'key2', 'key3'); $value = 'some value'; // $md = ...???!!!... I need the $md multidimensional array to have the keys thus... $md['key1']['key2']['key3'] = $value; Obviously that could be hardcoded quite easily, but my problem it that the $keys array is variable - it can hold different values and the number of items can vary. So how to build an md array? I'm looking for a generic routine. I've come close a few times, …

Member Avatar
Member Avatar
+0 forum 9

how to pass the value of one webpage to another at same project i mean me have to webpage one have item and the second for a cart mean to add these item to the cart on one click.me have the following control in item webpage image,lblName,lblPrice,lblQuantity me want to add or show these values to a repeater on cart webpage. best Regard Mian Sahib Jan

Member Avatar
+0 forum 0

Am doing an application to allocate the seats to the students in a building with rooms. I have almost done to allocate the students appropriatly in the rooms. The problem now is convert them to a single variable. So here is the place am struck with: I have these data in a rich textbox: 1 11 200 1 12 201 1 13 202 2 11 203 2 12 204 2 13 205 1 21 100 1 22 101 1 23 102 2 21 103 2 22 104 2 23 105 3 21 106 now I need the string as follows: …

Member Avatar
Member Avatar
+0 forum 5

i want to get table-tr-td values without any id,class.

Member Avatar
Member Avatar
+0 forum 1

Hi, i'm trying to select two values from my database. $nc ='North Carolina'; $t ='Hello'; $q = 'SELECT COUNT(state, title) AS c FROM all WHERE state = "' . mysql_real_escape_string($nc) . '" AND title = "' . mysql_real_escape_string($t) . '"'; $rq = mysql_query($q); $fetch = mysql_fetch_assoc($rq); $count = $fetch['c']; echo = "$count"; I need it so it will only echo out the number of posts from North Carolona and with the title Hello. It doesn't echo out nothing.

Member Avatar
Member Avatar
+0 forum 3

Hi All having a problem with the following statement " Notice: Undefined index: Username in C:\wamp\www\david\remoteaccess\index.php on line 6". I have tried defining Username in a number of ways, but I seem to missing something. Any help would be great Thanks in advance Thanks <?php session_start(); include("includes/utilities.php"); include("includes/functions.php"); $username = $_POST['Username']; var_dump($_POST); $Errors = ""; $_SESSION['LoggedIn'] = false; $_SESSION['UserID'] = ""; $_SESSION['UserAdmin'] = false; $_SESSION['Username'] = $username; if (isset($_POST["Username"])) { SQLUser(); }else{ loginForm(); } ?>

Member Avatar
Member Avatar
+0 forum 8

This is my display page <label for="City">City</label> <div id="city"> <select id="city" name="city" onChange="display(this.value)"> <option value="" selected="selected">-- Select city --</option> <?php include("getcitylist.php");?> </select> </div> this is my ajax page // JavaScript Document var XMLHttpRequestObject=false; function display(state_id) { if(window.XMLHttpRequest) { XMLHttpRequestObject=new XMLHttpRequest(); } else if(window.ActiveXObject) { XMLHttpRequestObject=new ActiveXObject("Microsoft.XMLHTTP"); } XMLHttpRequestObject.onreadystatechange=function() { if (XMLHttpRequestObject.readyState==4 && XMLHttpRequestObject.status==200) { document.getElementById("city").innerHTML=XMLHttpRequestObject.responseText; } } XMLHttpRequestObject.open("GET","getcitylist.php?state_id="+state_id,true); XMLHttpRequestObject.send(); } This is my connection page <?php include("config.php"); $state_id=$_REQUEST['state_id']; $query='SELECT tbl_city.* FROM tbl_city WHERE tbl_city.state_id =''; echo $query; ?> <select id="city" name="city" onChange="display(this.value)"> <option value="" selected="selected">-- Select city --</option> <?php $query_result=mysql_query($query)or mysql_error(); while($row=mysql_fetch_array($query_result)) { ?> <option value="<?php echo $row['id']; ?>"><?php echo …

Member Avatar
Member Avatar
+0 forum 1

Hello, How can I search for specific proccesses example "abc.exe" and add it to a listView and read values in it like an specific labels to add the processes on a specific group in the listView. Any articles would be nice.

Member Avatar
Member Avatar
+0 forum 3

i stored few values through input form. (for example tax and rate field) if i entered tax = 777.77 and rate = 10000 it stored the details to db successfully. retrieve function also done successfully. but i want to show add these two values(tax+rate = total) from db when i am retrieved these values? i tried few methods. but its not working. how to do that?

Member Avatar
Member Avatar
+0 forum 2

i have the db with serial no and reference no. serial no is auto_increment value. it is worked perfectly. but i want ref no column also as auto_increment value start with 0000001,0000002,0000003...., how to do that? i cannot able to add two auto_increment values in mysql.

Member Avatar
Member Avatar
+0 forum 2

Dear All, I'm working on application in C# which needs to filter "blanks" in one column and copy some value from other column instead. Filtering works perfectly, but copying is not so cool.. It copies some lines, but rest left blank. I cant find out where is problem. If possible please check my function below and if you have some idea, please let me know. Thank you Very much, Alan private void fill_blank_pn() { //set filter Excel.Range rg_Set_Filter = (Excel.Range)xlWorkSheet.Rows[1]; rg_Set_Filter.Activate(); rg_Set_Filter.Select(); rg_Set_Filter.AutoFilter(17, "=", Excel.XlAutoFilterOperator.xlAnd, Type.Missing, true); Excel.Range visibleCells = xlWorkSheet.UsedRange.SpecialCells(Excel.XlCellType.xlCellTypeVisible, Type.Missing); for (int area_Id = 1; area_Id <= visibleCells.Areas.Count; …

Member Avatar
+0 forum 0

$a = array(000,400,000,500); $b = array(300,400,450,500); $i=0; foreach($b as $k=>$v) { if($v==$a[$i]) { $b[$k]='000'; } $i++; } print_r($b); i want same thing in two dimensional array $a = Array ( [0] => Array ( [0] => 000000 [1] => 000400 [2] => 000450 ) [1] => Array ( [0] => 000350 [1] => 000400 ) ) $b = array(0=>000350,1=>000400,2=>000450) //pre-defined installment amount values

Member Avatar
Member Avatar
+0 forum 4

Hi, i want to create a query which select three columns from a table on certain condition now i have got certain with three columns and i can bind this data to a datagridview but before this i want to add a column to dgv say col_new and fill its cell with a variable value here's my query `SELECT PID, Name, FName FROM Tbl_Products WHERE PID = '" + PID.ToString()` iwant to do somthing like this `SELECT '"+ Col_New.text +"' PID, Name, FName FROM Tbl_Products WHERE PID = '" + PID.ToString()` and when ill bind my data to dgv then …

Member Avatar
Member Avatar
+0 forum 3

Hello DaniWebers! I'm absolutely shocking when it comes to JavaScript/JQuery and have run into an occurance when I would like to use it. Now before you slap me on the wrist I **DO** intend to learn JS in 2014 (Scouts honour!). I am using this slider: [JQuery - Snap To Increments](http://jqueryui.com/slider/#steps) # HTML # <div id="slider-snap-inc" class="slider bg-green"></div> <div class="slider-value"> Days: <span id="slider-snap-inc-days"></span> | Cost: <span id="slider-snap-inc-amount"></span> | Savings: <span id="slider-snap-inc-savings"></span> </div> # JS: # // snap inc $("#slider-snap-inc").slider({ value: 50, min: 50, max: 1300, step: 50, slide: function (event, ui) { $("#slider-snap-inc-amount").text("$" + ui.value); } }); The above works …

Member Avatar
Member Avatar
+0 forum 2

Hi Can anyone please help me.Im new to coding.Sorry i dont have any code to post.I would try to explain my problem in words.can please some one help me. I have a jsp in which i'm populating a table.In that table i have a column for checkboxes for each row.when i select that checkbox i need to get the 3rd column value of that row. this should even happen on multiple check box selections even.I have to all that values into an array.how? And also can some one explain me how can i pass that array to a java class …

Member Avatar
Member Avatar
+0 forum 1

Hey I have dictionary like following one dicts = {'met_293': ['81.0175','4','7','7','29.76','23','1','0','22','28.57','2','[KG]EHY'],'met_394': ['79.9579','4','7','7','29.76','18','3','0','15','28.57','2','EHY[ILV]'],'met_309': ['81.0175','4','7','7','29.76','23','1','0','22','28.57','2','[KG]EHY'],'met_387': ['79.9579','4','7','7','29.76','18','3','0','15','28.57','2','EHY[ILV]']} I want to remove keys which have same value like 'met_293' and 'met_309' those two keys have same value at 12th position which is '[KG]EHY' so i want my dictionary like this {'met_293': ['81.0175','4','7','7','29.76','23','1','0','22','28.57','2','[KG]EHY'],'met_394': ['79.9579','4','7','7','29.76','18','3','0','15','28.57','2','EHY[ILV]']} any help!!! thanks

Member Avatar
Member Avatar
+0 forum 2

<label class='colwidth' for='selectc' >Select Courses*: </label> <form action="send.php" name="course" id="states"method="post"> <Select name="States" id="State" style="width:40px;" > <option value=></option> <option value="1">HTML 5</option> <option value="2">JQuery</option> <option value="android">American Samoa</option> <option value="flash">Flash</option> <option value="flex">Flex</option> <option value="javascript">Javascript</option> </Select> <input type='submit' name='course' value='Submit' /> </form> And my php file is this <?php //Place state array at the top of the file $states = array( 1 => "html5", 2 => "jquery", 3 => "android", 4 => "flash", 5 => "flex", 6 => "javascript" ); //Generate select box if(!is_array($states)) { echo "<select name='states' id='states' style='width:40px'>"; foreach($states as $id => $name) { echo "<option value='$id'>$name</option>"; } echo "</select>"; } //Form …

Member Avatar
Member Avatar
+0 forum 16

Hi! I have a form in Drupal that is filled up by an user and sent as email to the server. I have created a new module to modify the values in the form after the user submit it and to send them to the server with new values. Here is my code: function medilux_cm_form_alter (&$form, $form_state, $form_id) { if ($form_id == "webform_client_form_59") { $form['#submit'][] = 'medilux_custom_webform_submit'; } } function medilux_custom_webform_submit($form, $form_state){ foreach($form_state['values']['submitted'] as $key => $value){ $form_state['values']['submitted'][$key] = 'new_value_' . $key; }; } Please advise what is wrong in this code.

Member Avatar
Member Avatar
+0 forum 1

I have data in which column 'C' have cells which contain multiple values separated by (,).Now I want to get atomic values in all cells of column 'C'. i.e. that for a cell when there is more than one value; separated by (,) it should be copied in the next row with all the other columns of that row copied with the value we want to separate, in the next row... In simple I want my data to be in 1NF.

Member Avatar
Member Avatar
+0 forum 8

hi, i have some logic but unfortunatly m weak in programing need your help guys i am working on a MIS using c# i have a drop down list which display the course id and in my course table one course id could have many student id i want to select all student id of selected course id to be filled in attendance table which has a column student id i have four columns in attendance table student id, course id, attendance is there any way that i can get student id >>>>>> all from seleceted dropdown list as i …

Member Avatar
Member Avatar
+0 forum 1

Hi, I've problem on the coding to save form values and display on the next page (without database). The code shown here is inside "catalog.html" Onclick image, the input will be saved and display on the next page i.e. "cart.html" I don't need a database. Just temporary save like storing it in cookies. So, how do I do that?? <tr id="m16d" class="submenu"> <td><form action="qty_form.asp"> Qty<input type="text" name=""> <img src="images/cartbtn.jpg" width="30" height="30" /></td>

Member Avatar
Member Avatar
+0 forum 5

The End.