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

Hi I wanted to draw a field like this photo which I have attached. I would appreciate your help. I have wrote so much now: for (int x = 2; x < 12; x++) { for (int y = 2; y <= 12; y++) { g.drawRect(40*x, 40*y, 40, 40); } } ![a61a6705a7f76105f8ebab3b38dd9dcd](/attachments/large/3/a61a6705a7f76105f8ebab3b38dd9dcd.jpg "a61a6705a7f76105f8ebab3b38dd9dcd")

Member Avatar
Member Avatar
+0 forum 3

Hello All. Been playing around with some linked dropdowns. It seems to be a recurring theme here on DW, so I thought I'd offer this up as a possible solution or for discussion, to see how it could be improved. The premise for this set of linked dropdowns is that it is not dependent on php or Ajax following page load, that is to say, all the data is initially dumped into json format from the database and then everything is left to javascript. I've used jQuery to produce a plugin, but the same functionality is possible with just plain …

Member Avatar
Member Avatar
+5 forum 3

Hello Anyone could you help i have got a strange problem when i update any record i get an error 2147467259 -(8000405) Insert Field failed. Where as on the same application i can add a new record. Please see below the code i have used dont know where am going wrong. Private Sub cmdupdate_Click() Set connection = New ADODB.connection With connection .ConnectionString = "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Port=3306;Database=apbooking;User=root;Password=root;Option=3;" .Open End With Set rsupdate = New ADODB.Recordset 'Update New Actual weight and number of boxes With rsupdate If .State = adStateOpen Then .Close .Open "select * from booking where hawb_no = '" …

Member Avatar
Member Avatar
+0 forum 3

**// EDIT 2014-04-07 //** New version (1.0.3) posted at the [bottom](http://www.daniweb.com/web-development/php/code/476623/ajaxed-linked-dropdowns-select-fields-for-volatile-data#post2082327) Demo Page: http://demos.diafol.org/ajax-linked-dropdowns.php *********************************************** Hello All. Been playing around with more linked dropdowns (select form fields), following the code snippet posted for static-ish data [here](http://www.daniweb.com/web-development/php/code/475238/linked-dropdowns-select-fields-for-static-ish-data). The static-ish version is of limited use (or of no use!) if data in the DB is updated regularly. So, here goes... No data is loaded by PHP initially, everything is provided through an Ajax call, however, that could be easily modified if required. I've used jQuery once again, as my plain javascript skills just aren't up to the job, and have produced a …

Member Avatar
Member Avatar
+3 forum 4

hey guys. I have a form (very much simplified): <form method="post" action="add_contact.php"> <label>House No. :</label><input type="text" name="houseno" required /> <label>Street Name :</label><input type="text" name="street" required /> <lable>Spouse ?</lable><input type="radio" id="spouse-yes" onclick="FillSpouse(this.form)">Yes<input type="radio" id="spouse-no"> <label>House No. :</label><input type="text" name="spousehouseno" required /> <label>Street Name :</label><input type="text" name="spousestreet" required /> </form> what i want is for when radion button "Yes" is clicked the two other text fields(name="spousehouseno" and name="spousestreet") will be populated by the same input values in the text fields(name="houseno" and name="street"). ive tried using from [Click Here](http://www.htmlgoodies.com/tutorials/forms/article.php/3898101): <script type="text/javascript"> function FillSpouse(f) { if(f.spouse-yes.checked == true) { f.houseno.value = f.spousehouseno.value; f.street.value = …

Member Avatar
Member Avatar
+0 forum 5

I have been stumped by this completely. Please help. I have a jQuery site that has a form with 2 hidden fields. With javascript, I get information (2 numbers from phone sensors) and set those hidden fields with the numbers. (works fine). I then automatically submit the form, and correctly get the numbers passed in through those fields into ASP on the server end. All is well so far... I then use ASP to set the value of those same hidden fields using <%=variable %> when I then generate the page via ASP....the problem is that those fields never get …

Member Avatar
Member Avatar
+0 forum 1

I have 10 field that I want to calculate the total. some of the fields take null value. I tried the codes below but the result was empty. select id, (c1+c2+c3+c4+c5+c6+c7+c8+c9+c10) as total from items order by id; the result show was null. In dreamweaver the result was blank. please kindly help me out. By Franz

Member Avatar
Member Avatar
+0 forum 1

Please find the details in Link. I an Trying To Create A sope Api The Details Are Mentioned In The LInk Below Please Help Me to Do It https://drive.google.com/file/d/0Bz6eK1ligNKUOUFwNEZvX0VpNXc/edit?usp=sharing [Click Here](https://drive.google.com/file/d/0Bz6eK1ligNKUOUFwNEZvX0VpNXc/edit?usp=sharing)

Member Avatar
Member Avatar
+0 forum 8

Hi Guys I have 2 buttons on my we page one is to save and other button to view a list ,i have applied field validator to validate form fields , but when i click the list button also the required field validator is activating how can i stop that ? i want required field validator to activate only when i press save button thanks regards sumith

Member Avatar
Member Avatar
+0 forum 3

Script i am using shown below.Date picker is showing on screen but it is applying to all input fields.( WHat should i change to get only for a particular input field. I tried with id rangeA but still it is applying to all fields. <script type="text/javascript"> $(function() { $('input').daterangepicker({arrows:true}); }); </script> <form> <li> <label for="name">Your Name:</label> <input type="text" size="40" id="name" /> </li> <li> <label for="date">Select Date</label> <input type="text" value="4/23/99" id="rangeA" /> </li> </form>

Member Avatar
Member Avatar
+0 forum 5

I'm trying to display some records which meet some certain criteria. That works fine, but I also want to retrieve the total amount of orders. These are all located in the field 'Amount' from the Orders table. So if record 1 has got '22' in it's amount field, and record 5 has got '55' in it's amount field.. the total should be 77. My sql coding looks like this: SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate, sum(Orders.Amount) as total FROM Orders INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID where customers.country='Germany' order by Orders.Orderdate But it only retrieves 1 record (due to the summage), when I …

Member Avatar
Member Avatar
+0 forum 4

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 text box and now i want to set the value of text box equal to the property value

Member Avatar
Member Avatar
+0 forum 2

I am new to perl. Is there any way that perl can detect when a field is focused in an external program? The script would just need to know when a text input field was selected. Thanks,

Member Avatar
Member Avatar
+0 forum 1

Hello Everyone, I need your help, can you please tell me how to create a text field for file upload with HTML ? I presently have this code in my form for file upload to the webserver; `<input name="userfile" type="file" size="50">`, this allows someone to browse file from their computer to upload a file. How ever this is not what I want. What I want is a form field that allows me to preset a file that can be uploaded to the server. So far this is what I have got `<input name="userfile" type="file" size="50" value="a.html">` adding value="a.html" to the …

Member Avatar
Member Avatar
+0 forum 17

Hello Friends, Can someone please advise me on how to print an array inside of a GUI text field? Thank you, Jim Here is some of my code. /** This private inorder method recursively traverses a binary tree in inorder. @param btree The root of the tree to traverse. */ private void inorder(AVLNode btree) { int [ ] arr = new int[10]; if (btree != null) { inorder(btree.left); arr[k] = (btree.value); inTextField.setText(arr[k]); //This gets me an error message. k++; inorder(btree.right); } }

Member Avatar
Member Avatar
+0 forum 3

Hi I have these two tables:Customers and Bookings;Customers has these fields CustomerId,firstname,lastname etc.Table bookings has bookingId, customerId,datebooking,startdate,enddate etc.I want to retrieve customerId,first and last name from Customers and datebooking,start and enddate from bookings, I understand I have to use a LEFT JOIN.I tried everything but it does not work, coud someone give me the right code for this? I am running MySQL 5.4.

Member Avatar
Member Avatar
+0 forum 4

How to solve the undefined index error? i have tried to make hidden field but not working also.. <?php if($nume==0) { echo "You currently have no item to show"; } else if(isset($_GET['msg'])) { $msg = $_GET['msg']; if($msg!='') { echo '<table border="1"> <tr> <td><font color="red">'.$msg.'</font></td> </tr> </table>'; } } ?></font></strong></p> <table width="680px" cellspacing="0" cellpadding="5"> <tr bgcolor="#ddd"> <th width="220" align="left">Date </th> <th width="200" align="left">Outlet </th> <th width="130" align="left">Status</th> <th width="70"> </th> </tr> <?php $start=(isset($_GET['start'])) ? (int)$_GET['start']:0; if(strlen($start) > 0 and !is_numeric($start)) { echo "Data Error"; exit; } $eu = ($start - 0); $limit = 5; $this1 = $eu + $limit; $back = …

Member Avatar
Member Avatar
+0 forum 19

Good day, I am having trouble with my dbase. i have 2 tables first is the maintenance table while the other is transactional table. on my maintenance table i have field(id, plan, material,type,percentage) while on the transaction table (id,material,description) here is my problem. on the maintenance table let say id plan material type percentage 1 1010 sample in transit 100 2 1011 example haulage 50 3 1012 mysample production 100 based on the data above i want to select type and join it on the transactional table. let say... id material description INTRANSIT HAULAGE PRODUCTION 1 sample sample description 100 …

Member Avatar
Member Avatar
+0 forum 2

Hi I am running phpMyAdmin 5.6. I have created a table as described in a tutorial. This table is supposed to have a null value in a text field, I cannot do it, I tried everything.The examples on the web refer to older versions and I keep getting error.I even tried to do it from the command propmt using alter or update but as I said the examples do not agree with this version of phpMyAdmin.Can somebody tell me how to do it?Thanks.

Member Avatar
Member Avatar
+0 forum 4

I am working with a tabbed form. On the first tab I have a datagridview with customers in it and a searching textbox. I have that working. On the second tab I am placing another datagridview with customer transactions and other data. The customer transaction table has a CustomerID Column which matches the key column in the Customer table on which the first datagridview is based. I am trying to save the key column value in a textbox so that I can use it to filter the datagridview in the second tab. I can fill in the textbox that contains …

Member Avatar
Member Avatar
+0 forum 1

Im having a problem with my input field. In firefox, it works pretty well. In chrome, its just a blank white box. Seems like the css is not connected.. but it is. See this image http://i1235.photobucket.com/albums/ff429/rakwel10/chrome.jpg [Click Here](http://www.lowermainlandrealestateinfo.net) to view our website Thank so much for your future help!

Member Avatar
Member Avatar
+0 forum 5

I want to add and delete 3nos of text field and label in a row dynamically using Add and delete button in javascript. Is any one help me in this regard...

Member Avatar
Member Avatar
+0 forum 7

Hello to everyone, im having trouble in inserting a date like "2012-12-06" into a database mysql, Im using phpmyadmin+wamp and adobe dreamweaver!I want to use 3 textfields, one for the year, other for the month and a last one for the day, but I always get an error by using this "$field_final_date1=$field2_date.'-'.$field3_date.'-'.$field4_date;" I created 4 variables 3 of them ($field2_date,$field3_date,$field4_date) to get the year,month and day and one ($field_final_date1) to join the other 3 to form this "2012-12-06". I can i do this? I made this code here: <?php include"connect_database.php"; $field2_date=$_POST['field2']; $field3_date=$_POST['field3']; $field4_date=$_POST['field4']; $field_final_date1=$field2_date.'-'.$field3_date.'-'.$field4_date; $query = sprintf("insert into despesas_casa values …

Member Avatar
Member Avatar
+0 forum 4

i want to click on a row in grid view and the details of each attribute can show separately in textbox field. i had type this in my coding part, but it doesnt work. may i know how to do it? thanks you. Dim text As New TextBox Dim sql_productname As String = " select Product_name from Product_detail where Product_name = """ & grid_bed(nowrow, 0).Value & """" txt_name.Text = sql_productname

Member Avatar
Member Avatar
+0 forum 2

how to get null field value from access in vb6 in my 2 record field the value is empty but i'm not able to get that empty field in vb6 ... .... set rs = new adodb.recordset rs.open ("select * from table1 where id = '2'") text1.text = rs!name please help me out

Member Avatar
Member Avatar
+0 forum 5

Hey guys! Im putting together a drag and drop page where a user will drag an ellement (in this case and printable pdf) over into a print field. I need blank fields on the right to return either as (void skip this) or with default pdf. Any ideas? Here is the page [Click Here](http://www.cintascsr.com/report/)

Member Avatar
Member Avatar
+0 forum 1

Hi All.. This Code Write On aspx file .This Code set the value in hidden field..But This Code Does not Work Properly <html><head></head> <body> <script type= "text/javascript"> function showDialogue() { var a = Screen.Width; var b = Screen.hieght; document.getElementById('HiddenField1').value = a; document.getElementById('HiddenField2').value = b; } </script> <form id="form1" runat="server" > <asp:HiddenField ID="HiddenField1" runat="server" /> <asp:HiddenField ID="HiddenField2" runat="server" /> </form> </body> </html> in code Behind :: On page Load Am Calling JavaScript function. `Page.ClientScript.RegisterStartupScript([GetType](), "MyKey", "showDialogue();", True)` I am also Calling Javascript in Another way: `Dim localScreenWidth As String = " <script type='text/javascript'>showDialogue();</script>"` then retrive The Hidden Field.. `Label2.Text = HiddenField1.Value` …

Member Avatar
Member Avatar
+0 forum 1

#Code for INSERT INTO into database and if fields are null, it will prompt for null fields.#

Member Avatar
Member Avatar
+0 forum 4

The End.