456 Topics

Member Avatar for
Member Avatar for Pundia

Hi everyone! I haven't seen this question here, so I'll give it a try. I'm from a country where some words have accents, like *MarĂ­a*. I have all this words in a database and I would like to use the Select function from a DataTable but ignoring accents in the …

Member Avatar for TnTinMN
0
2K
Member Avatar for bals
Member Avatar for mohd.sajid.3367174

In a table,in first row consist of static html control (1 select control and 5 textboxes).From second row onwards i created the rows dynamically(consist of 1 select control and 5 textboxes) on click of html button.Creation is successfull.But problem arised when i wanted to attach dataset table data to html …

Member Avatar for LastMitch
0
253
Member Avatar for LRNPHP

Hi Everyone Could someone assist me in a PHP / MySQL dropdown select menu. I want to pull info from my DB and display it, then when I select the option it need's to reload screen and add a second drop down select menu. When I select the 2nd one …

Member Avatar for amaz4u
0
2K
Member Avatar for dinhunzvi

i have the following tables in my database: CREATE TABLE `tblbrands` ( `brandid` tinyint(2) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(25) NOT NULL, PRIMARY KEY (`brandid`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; CREATE TABLE `tblcars` ( `carid` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `brandid` tinyint(2) unsigned NOT NULL, `typeid` …

Member Avatar for pritaeas
0
2K
Member Avatar for PriteshP23

I am beginner at AJAX. There are two Select Menus: Month & Year. The objective is to display data in the table **AFTER selection of YEAR**. Based upon selected values data should be displayed in the table. Thanks a lot in advanced. <!DOCTYPE html> <?php $year=$_GET["year"]; $month=$_GET["month"]; $year = array( …

Member Avatar for PriteshP23
0
562
Member Avatar for dinhunzvi

i have two tables the following structures. CREATE TABLE `tblbranches` ( `branchID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `branchCode` varchar(30) NOT NULL, `branchName` varchar(30) NOT NULL, `regionID` tinyint(3) unsigned NOT NULL, `branchAddress` varchar(400) NOT NULL, `cityID` smallint(5) unsigned NOT NULL, `countryID` smallint(3) unsigned NOT NULL, `branchContact` varchar(50) NOT NULL, `branchFax` varchar(20) …

Member Avatar for dinhunzvi
0
190
Member Avatar for ebc3142

I'm trying to use this code to populate my drop down menu from a mysql table: <select name="fileselect"> <?php $pdo = new PDO('mysql:host=localhost;dbname=contisec_portal', 'root', ''); $stmt = $pdo->prepare("SELECT dateid FROM date_header"); $stmt = $pdo->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { echo "<option value='" . $row['dateid'] . "'>" . $row['dateid'] . "</option>"; …

Member Avatar for diafol
0
6K
Member Avatar for LeslieJohn

I am trying to create an application which will send a reply back once a customer (registered user) sends a a question to the system. The application will select the correct answers (based on keywords) from a database and send it back in SMS to the customer’s mobile phone. For …

Member Avatar for ajbest
0
541
Member Avatar for eburlea

Hi. I have a select box with the id=1. I need a solution for: when changing the select box with the id=1 to appear another select box with the id=2 and when changing the select box with the id=2 to appear another with the id=3, and so on. I have …

Member Avatar for eburlea
0
277
Member Avatar for Kcachilove

Hello, please am having issues querying my reports from the database. i want to creat a reports from a number tables ( rooms ==> this table is where i have all the room numbers. bookings ==> this table is where i have all the room numbers used per each date. …

Member Avatar for LastMitch
0
164
Member Avatar for odose

How to select data from different tables in a single database and show in a single jtable.. Pls I need help

Member Avatar for peter_budo
0
169
Member Avatar for Lethugs

Query to make movement of a record I have this tables User Description Item UID Name DeID Dgroup ID DeID Name 1 Jose 1 Printer 1 1 Stylus 2 James 2 Monitor 2 1 Epson 3 2 Viewsonic Transaction Details Ttype IID UserName NewUser Release 1 Jose Release 2 Jose …

Member Avatar for Lethugs
0
279
Member Avatar for laogao99

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 …

Member Avatar for khair.ullah
0
187
Member Avatar for Lethugs

Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Styl T10 1 1 Repair 1 2 Monitor 2 MPS 1 2 Repair 3 3 ImpSonic 2 I need to count how many printers, Monitors etc. are …

Member Avatar for Lethugs
0
308
Member Avatar for Lethugs

Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Stylus T10 1 1 Repair 1 2 Monitor 2 HP 1 2 Repair 3 3 ViewSonic 2 I need to count how many printers, Monitors etc. are …

Member Avatar for john.knapp
0
184
Member Avatar for andarivaadu1

Here is my query UPDATE tracks SET People_id_Reference = (SELECT People_id FROM People RIGHT JOIN top100 ON People_name=top100.artist LIMIT 1) WHERE People_id_Reference IS NULL; But that query inserts same people_id value into all rows of People_id_reference Can some on help me with this. Thanks in advance

Member Avatar for andarivaadu1
0
195
Member Avatar for dinhunzvi

i have a form with a text box and a drop-down list. the form submits to itself. when the user submits the form for processing the form must be able to retain the selected value from the drop list if there is an error. here is the code for the …

Member Avatar for adam.adamski.96155
0
339
Member Avatar for anisha.silva

Hi I have two tables Employee and Job, Employee's prmary key is EID and in Job there is a EID that is a foreign key to Job. job has another column as the status of the employee. first the employee is added to the database and then the job detils …

Member Avatar for AleMonteiro
0
199
Member Avatar for Khav

Greetings, I have two tables named 'copyright' and 'logs'. Table : copyright Field : Copyr_md5 Table : logs Field : md5checksum Problem 1 Say i have a value stored in `$md5check` in php , now i want to check if the value stored in `$md5check` is found in field `Copyr_md5`.If …

Member Avatar for Khav
0
244
Member Avatar for phphit

I have two tables (points, pointsmatch) Table 'points' have following fields id (int) seriesid (int) team (varchar) points (int) id seriesid team points 1 9 Chennai 4 2 9 Delhi 0 3 9 Kolkata 0 4 9 Mumbai 0 5 9 Bangalore 0 6 9 Mohali 0 7 9 Rajasthan …

Member Avatar for phphit
0
662
Member Avatar for JukesK

hope i worded this well enough... :D trouble working out a query Table: weeklyrevenue Week Number||value 25||20 26||40 28||60 Table daily_totals Week Number||quantity 26||10 27||10 28||10 Need week 27 totals to be multiplyed by week 26 revenue not week 28 revenue as the revenue would have been generated by the …

Member Avatar for faroukmuhammad
0
289
Member Avatar for AndreRet

Stuck again... :) I am returning close to 60 records from a search in mysql. I want to add these records to a select box. When I am looping through the records, it adds a select box for each record. Not sure where I am going wrong. It does load …

Member Avatar for AndreRet
0
271
Member Avatar for iblend

I have a form that populates the country field dynamically using AJAX: http://interactiveblend.com/ajax/dynamic.html As you can see, this drop down is too long and runs off the bottom of the page. When I hard code the select list, it looks fine - http://interactiveblend.com/ajax/static.html Any idea on how to make the …

Member Avatar for GliderPilot
1
181
Member Avatar for keven.pirritano

I have a basic idead of jQuery and can do some basic stuff, but I can't figure out how to do the following: I need jQuery to do the following function when you SELECT an option from a form Dropdown selection... When a person selects PS3 in drop down it …

Member Avatar for pritaeas
0
211
Member Avatar for fgregory54

I have scoured the google searches and haven't run across an answer to this question. I have a Select field that gets values from a database. That part works fine. The database contains four fields: specialistid, name, cell, email I would like for the user to select from a dropdown …

Member Avatar for fgregory54
0
174
Member Avatar for bradly.spicer

Hey everyone, Been working on a php snippet which finds the names of all the files in a Directory and populates them into a drop down box. Which would then allow me to select that file, click a submit button and delete them. Here is what I have SO <?php …

Member Avatar for bradly.spicer
0
212
Member Avatar for ar123

Hi there! I am new to daniweb.com and C++ CLI. I am trying to make a program that will tell the user the text for the ListItem number they type in. The ListItem information is stored in a text file with my custom file formatting, which is: <~ListItem 1> text.... …

Member Avatar for ar123
0
279
Member Avatar for Mits14

I need help!! What I want is when I add a new teacher, it will search the tblteacher_info. If there is already a record of that teacher, it will just update his/her record. If there is no record of that teacher, it will add his/her info in the tblteacher_info. I …

Member Avatar for Mits14
0
143
Member Avatar for adishardis

Hi, I'm working on a site and but have come to an halt. http://adam.synology.me/help1.png today I have a dropdown list (circled in red) which lets the user choose a row of data from my database to visualize in the area to the right in various graphs and such. I would …

Member Avatar for adishardis
0
1K

The End.