Search Results

Search found 23568 results on 943 pages for 'select'.

Page 540/943 | < Previous Page | 536 537 538 539 540 541 542 543 544 545 546 547  | Next Page >

• Getting single value from a single row with Mysql/PHP

  - by Ghostrider

  Often I just need to get a single value from MySQL that I know exists there. I use the following construct: $result = end(mysql_fetch_array(mysql_query('SELECT FOUND_ROWS()', $db))); Is there a proper single function in PHP that would do this?

  Read the article

• Selecting a random result from Simple Database (SDB) on AWS

  - by benr

  Anyone know how to do this - just what would be the equivalent to this: "select * from YOUR_TABLE order by rand() limit 1" in mysql?? Maybe not possible in SDB?

  Read the article

• loading of data using jquery

  - by pradeep

  hi, i have a proj where on change of select box i am loading data from server. how do i make sure that until the data is loaded user cant do anything else on the page ..

  Read the article

• [PHP] converting mysql data into array?

  - by Mahmoud

  i have an ajax script that check if the user name is available or not, but it keeps taking the newest user name and the rest are out $result = mysql_query("Select username from customer"); while ($row = mysql_fetch_array($result)){ $existing_users=array(''.$row['username'].','); } i know i am doing something worng

  Read the article

• Copying an entire table with Postgres

  - by NudeCanalTroll

  Hello, I'm trying to copy the contents of one table into another in Postgres, however it appears some rows aren't being copied correctly: ActiveRecord::StatementInvalid: PGError: ERROR: column "email_date" is of type timestamp without time zone but expression is of type character varying HINT: You will need to rewrite or cast the expression. Is there any way I can have it automatically skip (or ignore) invalid rows? Here's the query I'm using: SET statement_timeout = 0; INSERT INTO emails3 SELECT * FROM emails

  Read the article

• mysql query results sorting

  - by user329094

  I am calling the results form a query to a list on my site based on if the item is "downtown_hosted". This works fine but I would now like to sort that list DESC, but can't seem to get the syntax correct. Below is what I have: $result_events = mysql_query("SELECT * FROM events WHERE downtown='downtown_hosted' ORDER BY date DESC LIMIT 5 ");

  Read the article

• How to display mysql rows that contain certain data?

  - by user272899

  I have a table in mysql with a row called 'newrelease'. If the item is a new release my form posts it as 'yes' if no 'no'. How would i display all items that contain the data 'yes'? $query = "SELECT * FROM movielist ORDER BY newrelease DESC LIMIT 4";

  Read the article

• Which method is best method for speed? in SQL Server, stored procedure

  - by AjmeraInfo

  I have select, insert, update and delete query. If I have to write all queries in the same stored procedure that is good for performance or should I write all queries in separate stored procedures?

  Read the article

• Sql string adding problem

  - by Woland

  SELECT a.one + ' test ' +b.two from table1 a right join table1 on a.id =b.id The problem is that when one is null then it the whole string is null, is there some kind of trick to bypass this problem msSQL 2005

  Read the article

• Php function within SQL statement syntax

  - by Vafello

  I have the following code. I would like username to take the value of the getUserName function however I am fighting with syntax. Can anybody tell me what should be the correct one? $query = "SELECT user FROM users_entity WHERE username = getUserName()";

  Read the article

• How do I combine two rows of same part, but add quantities?

  - by Tom

  I have table "PICKITEM" PARTID QTY A 1 A 3 B 11 C 8 D 5 D 3 I need a select statement that will return one line for like PARTIDs and add the qty field to together, yet also return the rest of the lines in the table as is PARTID QTY A 4 B 11 C 8 D 8 Probably a newb question, but I am new to SQL syntax and queries. Any help in getting me on the right path would be appreciated!

  Read the article

• What's wrong with my using pdo this way?

  - by user198729

  $sql = "SELECT * FROM table ORDER BY :sort :dir LIMIT :start, :results"; $stmt = $dbh->prepare($sql); $stmt->execute(array( 'sort' => $_GET['sort'], 'dir' => $_GET['dir'], 'start' => $_GET['start'], 'results' => $_GET['results'], ) ); I tried to use prepare to do the job,but $stmt->fetchAll(PDO::FETCH_ASSOC); returns nothing.

  Read the article

• how to check whether the item in the combo box is selected or not in c#?

  - by zoya

  im having a combo box in which i have to display dates from database...user have to select a date from the combo box to proceed further...but im not able to make the user aware of selecting the item from the combo box first to proceed further...what is the process so that a user can get a message if he has not selected the date from the combo..

  Read the article

• Using JQuery to Style form elements

  - by John

  Hi, I've seen jquery used to change a form select drop down box in to a 'pretty' drop down list widget. I can't remember where I saw this but does anyone have any links or example code which show examples of how to use jquery to style form elements? I'd prefer it if it was code rather than a built in plug in. Thanks

  Read the article

• mySQL convert varchar to date

  - by Jeff V

  I need to convert a varchar value of 1/9/2011 to a date in mySQL and I want only the month and year. So that I can then use the PERIOD_DIFF function (so I would need the above to be converted to 201101). I've tried various ways using the STR_TO_DATE function: SELECT STR_TO_DATE(CYOApp_oilChangedDate, '%m/%Y') FROM CYO_AppInfo But I get weird results... (for example: 2009-01-00) What am I doing incorrectly?

  Read the article

• filtering problem in LINQ

  - by ognjenb

  var query = from d in testPersons.person where d.Name == txtbox select d; txtbox is text box on View page. How change this code to return all names who starts with any part of name? For example:when I type R in text box, on View page, this query should return all names who is start with character R

  Read the article

• How to reverse a string (SQL Server 2005, SET BASED)

  - by Newbie

  E.g. Declare @str varchar2(20) Set @str = 'A Student' Select Reverse(@str) Output: tnedutS A Expected being: Student A The output(using Reverse) is as expected. But my requirement is the one described. Help needed with SET BASED. I am using SQL Server 2005

  Read the article

• How to query by recent date and value in SQL?

  - by wsb3383

  I have a table with three columns: patient_id, obs_date, and weight_val. patient_id stores patient identification #, weight_val stores a weight value, and obs_date stores the date when the weight reading was taken. So, a patient can have many different weight readings at different dates. How do you write a query for: select all patients whose last weight reading is 120?

  Read the article

• how to create product references of In app purchase?

  - by RAGOpoR

  if i want to test in app purchase, how can i create product references in ITune connect? it force me to select some application in my iTune connect, or i want to create dummy App on iTune connect? could you please tell me step by step to create product references for test.

  Read the article

• Getting maximum value from table using LINQ

  - by Tena

  I have a table in my database. I want to get the maximum value of a column named NumOfView. I used this code: var advert=(from ad in storedb.Ads where ad.AdScope == "1" select ad.NumOfView).Max(); It works but when there are two or more same maximum values it doesn't work and this message appears: Sequence contains more than one element What should I do now? Your answers will be very helpfull. Thanks

  Read the article

• How to index small words (3 letters) with SQL Full-text search?

  - by Sly

  I have an Incident table with one row that has the value 'out of office' in the Description column. However the following query does not return that row. SELECT * FROM Incident WHERE CONTAINS( (Incident.Description), '"out*"' ) The word 'out' is not in the noise file (I cleared the noise file completely). Is it because SQL Full-text search does not index small words? Is there a setting for that? Note: I'm on SQL 2005.

  Read the article

• SQL - sub count

  - by Andy Clarke

  Hi I've got some SQL ... SELECT AdviceNo, Registration FROM tblSalesDetail that produces something like ... ADV00001, ABC123 ADV00001, CDE564 ADV00002, FGE432 ADV00003, HUY789 ADV00003, MJS532 ADV00003, JFY428 Can anyone tell me how I'd adjust it to see the following please? ADV00001, ABC123, 1 ADV00001, CDE564, 2 ADV00002, FGE432, 1 ADV00003, HUY789, 1 ADV00003, MJS532, 2 ADV00003, JFY428, 3

  Read the article

• help with sql query - in access 2007

  - by Gold

  hi i have 2 tables table items has 144602 records table A has 27721 records code in items = BAR8 in A i want to show all records that equal i try this: SELECT Items.Code, A.BAR8 FROM Items INNER JOIN A ON Items.Code = A.BAR8; and i get 28048 records !!! i need to get 27721 , how to do it ? thank's in advance

  Read the article

• Someone please can see why the following prepared statment returns nothing?

  - by jartaud

  $stmt = mysqli_prepare($link,"SELECT *FROM ads INNER JOIN dept ON dept.id_dept = ads.in_dpt INNER JOIN members ON members.idMem = ads.from_Mem INNER JOIN sub_cat_ad ON id_sub_cat = ads.ads_in_Cat INNER JOIN cat_ad ON idCat_ad = sub_cat_ad.from_cat_ad WHERE ads_in_Cat = ? "); if(isset($_GET['fromSCat'])){ $fromSCat = mysqli_real_escape_string($link,$_GET['fromSCat']);} mysqli_stmt_bind_param($stmt,'i',$fromSCat); mysqli_stmt_execute($stmt); mysqli_stmt_fetch($stmt); $tot=mysqli_stmt_num_rows($stmt); //Ouput: 0

  Read the article

• SQL Join only returning 1 row.

  - by kevin

  Not quite sure what I'm missing, but my SQL statement is only returning one row. SELECT tl.*, (tl.topic_total_rating/tl.topic_rates) as topic_rating, COUNT(pl.post_id) - 1 as reply_count, MIN(pl.post_time) AS topic_time, MAX(pl.post_time) AS topic_bump FROM topic_list tl JOIN post_list pl ON tl.topic_id=pl.post_parent WHERE tl.topic_board_link = %i AND topic_hidden != 1 ORDER BY %s I have two tables (post_list and topic_list), and post_list's post_parent links to a topic_list's topic_id. Instead of returning all the topics (where their board's topic_board_link is n), it only returns one topic.

  Read the article

< Previous Page | 536 537 538 539 540 541 542 543 544 545 546 547  | Next Page >