Tagged Questions

DO NOT USE THIS TAG! In most cases, you just want the [[sql]] tag instead. See http://meta.stackoverflow.com/questions/183419/kill-the-query-tag.

learn more… | top users | synonyms (3)

0
votes
1answer
21 views

Retrieving and Count no. of rows in birthdate to Age with multiple WHERE clause in a single query?

Well, lets say I have this list of birthdates And I want to count the data with corresponding ages like, ages 10 - 15 ages 16 - 20 ages 21 - 30 and so on... Well, I found this piece of code ...
1
vote
3answers
37 views

Choosing the right data from a table using SQL

Lets say I have this table name "Stuff" ╔════╦═════╗ ║ ID ║ VAL ║ ╠════╬═════╣ ║ 1 ║ A ║ ║ 2 ║ B ║ ║ 3 ║ C ║ ║ 4 ║ C ║ ║ 5 ║ C ║ ║ 6 ║ D ║ ║ 7 ║ B ║ ║ 8 ║ E ║ ╚════╩═════╝ I ...
0
votes
2answers
17 views

mysql_query to only show posts by the user

I'm creating a twitter-like stream of posts using PHP. If the user only wants to see posts that he created, how should I write the mysql query? Here's what I have now: mysql_query("SELECT * FROM ...
-2
votes
0answers
25 views

PHP Update Table Where It mathes GET request?

I'm new to MySQL and currently messing with a side project. Basically, it's for an application I'm working on and I will use this for basic authentication. ie. if what the user enters in the GET ...
1
vote
1answer
24 views

Selecting a subset of rows from a PHP table

I'm pretty new to using SQL, so I was hoping someone could point me in the right direction for setting up a slightly more complex query than I have needed to use in the past. I have a simple mySql ...
1
vote
1answer
24 views

SQL Query How to get the next row date using the temp field value?

Here's my original query.... If you can see the date of the next_row_date '2013-01-01' which is not the last record of fld_date and the last record of the next_row_date is '2013-01-15' must be 0. ...
0
votes
0answers
11 views

SQL code generation from table-free boolean queries?

Given string input such as: foo=5 AND a=6 AND date=now OR date='2013/6' AND bar='hello' I am going to implement: boolean understanding (which operator takes precendence) spliting off of ...
0
votes
1answer
14 views

How to search & extract from Parse.com data for android?

I would like to send a query and get return from Parse.com data table for android.Kindly provide with an example or snippet to achieve this.Thank you.
0
votes
3answers
48 views

Querying the database with double or check in AND check

so I've been trying to query the database with this line of code: $query_check = mysql_query("SELECT * FROM chat WHERE sent_by_id || sent_to_id = '$user' AND sent_by_id || sent_to_id = ...
0
votes
2answers
19 views

How to make multiple group counts in MySQL

I want to display counts for 2 fields using group query. Here is the table and the scenario: TABLE email campaign [email protected] 25 [email protected] 25 [email protected] 26 The query ...
0
votes
1answer
39 views

MySQL query with multiple tables for autocomplete

I've got some SQL code which is used for jQuery Autocomplete. At this point there is a query which gets the name of the product: SELECT DISTINCT name AS name FROM products_names WHERE (name LIKE ...
0
votes
0answers
12 views

mysql match fname with post search

Ok so i am trying to do a match against as fscore but I am having issues and I am wondering if anyone can help - I have not done a match in a long time I do have fname however as a fulltext index ...
-3
votes
2answers
46 views

Calculate number of days in a month [on hold]

Hey guys On my web page I have 2 text boxes from which I enter the Year and Month. Now Can you tell me a mysql query which will get the number of days in that month. I want to use that in my code ...
-2
votes
3answers
39 views

SQL Query Balance

I have query like this one... +-----+------------+--------+---------+---------+ | seq | fld_Date | CBU_IN | CBU_OUT | Balance | +-----+------------+--------+---------+---------+ | 41 | 2012-10-08 ...
0
votes
1answer
36 views

Need to show alert message when clicking on a tabpane inside an ajax tab container

<asp:TabContainer ID="tcMain" runat="server" ActiveTabIndex="0" Width="986px"> <asp:TabPanel ID="tp1" HeaderText="H1" runat="server"> </asp:TabPanel> <asp:TabPanel ID="tp2" ...

1 2 3 4 5 … 2064
15 30 50 per page