[select] Forum Topics

Hey guys I have a mysql database that has an events table. The events table consists of the fields Title, Date, Place and description. I am trying to display the table on the browser using php coding. it should list important events first according to the date. so as follows …

Hello everyone. I need some help with a SELECT FROM WHERE query. Let's say I have a row named A and another row named B, and I want to select the eventual cases where values from these two rows, somewhere, match eachother. In this case, you can see, that the …

Hi, The code below selects all items in a listview control,fine,but I was wondering how I could code to select all but the very last line in the array. [CODE]Private Sub SelectAllToolStripMenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SelectAllToolStripMenuItem1.Click Dim i As Integer Dim lvItm As ListViewItem Dim …

Hey everyone, I am looking to write a query that I think can be solved a nested select but I am not yet that fluent in MySQL to be able to get the query working correctly. Basically what I want to do is this; SELECT count(*) from Inquiry Inner Join …

Hi every one, I have 3 table table temp: Name | Description A | Description A B | Description B C | Description C table temp1: Name | order A | 5 A | 4 B | 2 C | 3 table temp2: Name | Payment A | 3 B …

Hello! I need to write a query that selects TableID (a previously concatenated string) and also selects a substring of TableID as another column. All data in TableID is in the format %System.Variable, %Class.User, etc. I need to select from the % to the '.' to return something like %System …

Hi I want to display the value selected from a 3 level drop down list. Its something like this (for eg) : If a select fruit from level 1 , in level 2 i get all the list of fruits in drop down , then after selecting fruit name from …

Hi, I have this datatable that I need to loop for my excel exporting function. And I have to export data that exceeds the row limit of excel worksheet. now I want to know how to create a query of limit on the datatable.select in such way like in sql. …

$u = mysql_real_escape_string($_POST["username"]); $p = sha1($_POST["passwd"]); $q = "SELECT * FROM profile WHERE email=`$u` AND passwd=`$p`"; $run = mysql_query($q); if(!$run){ echo mysql_error(); } this creates *Unknown column 'mymail@gmail.com' in 'where clause'* error. This code is from a tutorial and a piece of a submit-new-post php page.

Hello, i need some help here, i want to change Edit,Select,Delete linkbutton in the gridview to be outside the gridview, i have tried to hide the 3 button and make another button outside gridview, but i dont know how to make a link between all the button. this is my …

Hello everyone, Im a beginner in vb.net and currently Im developing a program where i save date to a txt file like this Reminder#dinner#26-07-2012 19:52:00 and show it in a listbox(all the lines in the txt file). What i want to do is to select a line(item) in the listbox …

HI. I have a situation where we need to pull data from multiple data sources into one dataset. Once we have the data in one dataset we would like to somehow manage to execute some sort of [complex] select query on the data in order to generate a new DataTable …

Hi I know this can be done, just don't know where to start. I am creating a site and have a multiple select box in a form I am going to pass to this form data from a database to be displayed as values. I can do this no problem. …

Hi, I am trying to use mysql select query in a shell script but i need to know how to store a particular value from the output of the query in a script variable. my script file is given below. I need to store the value under field CheckSum in …

i have the code in my project- <Script language="JavaScript"> function goto(form) { var index=form.select.selectedIndex if (form.select.options[index].value != "0") { location=form.select.options[index].value;}} </SCRIPT> <FORM NAME="form1"> <SELECT NAME="select" ONCHANGE="goto(this.form)" SIZE="1"> <OPTION VALUE="">-------Choose a Purpose------- <OPTION VALUE="<?php echo base_url()."admin_panel/post_pmb/project"; ?>">Project Discussion </option> <OPTION SELECT="SELECTED" VALUE="<?php echo base_url()."admin_panel/post_pmb/general"; ?>">General Discussion</option> </SELECT> </FORM> in this code …

Well, I can't say it correctly, I'm sure the title is not what I meant, I just didn't know how to say it... But anyways, I inserted some text in a table in a dtabase, for SQL injection reasons, I stripslashed it or should I say "I used real_escape_string" But …

Hi, I've been working with Ruby on Rails to make a web application, but I've found something that I really cannot work out how to do with it, so it may be best if I do it manually. Basically, I've got a dropdown menu, that is populated with a list …

if i have roughly 25 identical tables is it possible to do the following SELECT tm_name, `tablename` as Activity from t1, t2 ,t3 where date = curdate or would it be better to add another column to the table thats hidden from the users and automatically populate with the tablename.

Hi, I have a table with a timedate collumn. I want to get the text of the article and its creation date, than to output them on my page. How can I just get only the date value from a query or php script manupulation?

Hi there, I have a Country/City list in my SQL database and access it with PHP using a select element in php. I use the Chosen Jquery Plugin for the styling of these select elements. Now my problem is that i want only the cities of the country selected to …

Hi All I'm looking for ideas or suggestions about how to implement this feature. The concept is I have 2 dropdown select boxes, with data that is not directly related (in the sense that there is no identifiers or foreign keys or anything within the data itself) but that have …

I have two RichTextBoxes in my vb.net application (rtf1 & rtf2). rtf1 is loaded with the external data. Mostly It contains para split into different sections. The paragraph is a dynamic data, hence the no. of words keep on changing. Now my question is that, I want to select a …

Hey guys I have a new problem. I am using mysql as my database. I want to get the sum of an amount between 2 dates heres my code for mysql: select sum(amount) from orderline group by orderlinedate between 'Datehere' and 'Datehere'; But my problem is how do i get …

I can't update my database by using select .. i've tried searching for different solutions but those didn't helped me .. any ideas why this doesn't update my DB?? i need to update the row with such conditions: the query/queries i used $records = mysql_query("SELECT * FROM cot_cargovolume WHERE VoyageNo …

<select name="country" id="country"> <option value="IN">India</option> <option value="PK">Pakistan</option> <option value="UK">United Kingdom</option> <option value="US">United State</option> </select> When a user selects a country and clicks submit php gets the **value=""** ie, country code instead of country name.

I have an SQL select statement that I cannot quite get working. Dim SelectStr As String = "SELECT * FROM Appointments WHERE Doctor = '" & ComboBox1.Text & "' AND AptDate = #" & DateTimePicker1.Text & "#" This works perfect ... however I have 2 more WHERE possibilities ... I …

I have four database tables locality table: localityid, locality. jobtype table: typeid, type. applywork table: id, userid, applyfor applicationsent, jobtypeid, vacancyseenon companyname, doorno buildingname, street, localityid, postcode, telephone, website, email, notes users: id, role, name, surname, gender, username, password. I have a page to edit selected field from applywork. I …

Hello all! I currently have a drop down which consists of a list of names generated from the database. My problem is that when selecting a name from the dropdown I would like to insert the name and the corresponding ID into the database table. I am not sure if …

I've looked up many different answers to the question I'm asking but none have them have seemed to work and im completely confused as to why. Here the the problem: When ever I enter the information into the form on the website, I get the message Error: No database Selected. …

What is the proper value of the multiple attribute for select tag? [url]http://www.tizag.com/htmlT/htmlselect.php[/url] says "yes" while [url]http://www.w3schools.com/tags/att_select_multiple.asp[/url] says "multiple" I did, however, tried both and worked just fine but I want to be using what's acceptable by w3c to ensure full compatibility in most major browsers.