|
I have a table of pages in my database, each page can have a parent as below:
id parent_id title 1 0 Home 2 0 Sitemap 3 0 Products 4 3 Product 1 5 3 Product 2 6 4 Product 1 Review Page
What would be the best MySQL query to select all pages ordered by ...
Started by Swanny on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Well, you can always get it all in one query and process it in PHP....
To any number of levels, you won't do it with a single query, you'll use a few building up the tree of the node, and then sort your query by level then by parent.
|
|
Hi, I am making a website where users add the place where they have visited.
There is 4 main tables
users (user_id,name ) places (place_id,type_id,place_name, city_id) user_place (user_id,place_id, date ) city(city_id,city_name)
Now I need to take with...
Started by DR.GEWA on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
C.city_name, placeCount.Cnt FROM places p INNER JOIN user_place up ON p.place_id = up.place_id INNER p.place_id, p.place_name, c.city, placeCount.Cnt FROM places p INNER JOIN user_place up ON p.place_id ( SELECT place....
|
|
SQL query for a carriage return in a string and ultimately removing carriage return
I have some data in a table and there are some carriage returns in places where I don't want them. I am trying to write a query to get all of the strings that contain ...
Started by Maestro1024 on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
LIKE '%\n%'
Something like SELECT.
Omit the double quotes from your first query.
|
Ask your Facebook Friends
|
Hi,
I'm having a problem with a query prepared in PHP with PDO. The code:
$link = new PDO("mysql:dbname=$dbname;host=127.0.0.1",$username,$password); $link->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $query = $link->prepare("SELECT...
Started by benjy on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Refman/5.0/en/mysql-stmt-prepare.html says: The markers are legal only in certain places in SQL) As a rule of thumb I use: "if you can't wrap it in single-quotes in an ad-hoc query string you can't.
|
|
Hi, I'm looking for an API or a combination of API's where I can send "Anjuna, India" and get back a list of places nearby. The data is mostly for "third world" countries, less so for Europe/US. Any suggestions/ideas about how to structure this?
Answer Snippets (Read the full thread at stackoverflow):
Then go trought that list and calculate distance On Earth Identifier) for input location(s) Determine neighboring places A quick example, combining those APIs together with Yahoo's YQL would provide....
You would need place lists with coordinates.
|
|
Hi all, I am curious if is out-of-date to use query string for id. We have webapp running on Net 2.0. When we display detail of something (can be product) we use query string like this : http://www.somesite.com/Shop/Product/Detail.aspx?ProductId=100
We...
Started by Xabatcha on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
A lot of sites change :) Seems to me a ... .
Simple to create and understand.
However, never place anything in the query string that could be a securityNothing wrong with query string parameters.
To be used in the right places.
|
|
I created a simple MySQLi class for a project I'm working on to make it easier and more streamlined to pull from and push to the DB. ( also to get more familiar with OOP in PHP )
A problem I keep running into is in an effort to make it as efficient as...
Started by anomareh on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
However, you should close it if you fetch, let's say, only the first ... .
So, if you iterate through the whole result set, there's no need to call mysqli_result .
I think that if there are no rows left in the result set, it should be closed automatically .
|
|
Hi,
I have three models: Product, Category and Place. Product has ManyToMany relation with Category and Place. I need to get a list of categories with at least on product matching a specific place. For example I might need to get all the categories that...
Started by pablo on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Generally.
So there is no need for the distinct() call in this query.
To handle this would be to use Django's excellent caching mechanism on this query, assuming will never be duplicated anyway.
|
|
Hello, I want my app to do something when the last NSLog has a certain string. I thought I could realize this with an if-query and isEqualtoString, but how can I make this?
Sorry for my bad English ;)
Started by Flocked on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
In multiple places and also allows you to easily extend the logging function further if desired..
|
|
I am working on optimizing one of the SQL Job.
Here I have few places where we have used <> operator. THe same query can be replaced using NOT EXISTS operator. I am just wondering which is better way of doing it.
Sample Query
If(@Email <> ...
Started by noob.spt on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Almost always you should use EXISTS/NOT EXISTS for queries in which you're trying to find out whether a certain record ....
NOT EXISTS is generally better (although in your case if the table is small and/or indexed properly it may not be the case) .
|
