Find solution

How to arbitrariarly sort MySQL result set?

Let’s learn how to arbitrariarly sort MySQL result set. The most accurate or helpful solution is served by Stack Overflow.

There are ten answers to this question.

Best solution

How to combine, paginate, and sort an external API with MySQL result set

I am looking for an efficient way to combine results from a REST API with results from a query to a hosted MySQL database. I need the ability to paginate and sort through the results, but am having trouble determining the best approach such that the order of records is maintained. I am using PHP and Curl to send a rest request to the service. The external API I am using is eventful (http://api.eventful.com/), and my MySQL database stores basically the same event information. I'd like to pull from...

Answer:

How about pulling data from both sources, storing all in the database and then query that database using...

Read more

CloudSurf at Stack Overflow Mark as irrelevant Undo

Other solutions

MySQL SELECT from different tables into one result set?

Hello, I have a jQuery autocomplete "search" input. So you can type in something and it will suggest you results from a MySQL database. Now I have two tables in that database; table 'aliases' with columns 'alias', 'steamid', 'timesused' and...

Answer:

I *think* this is what you are after, but not positive (and it's definitely untested): SELECT alias...

Read more

Alexej at Yahoo! Answers Mark as irrelevant Undo

How to set mysql date from a result set to a php datetime object?

i am trying to set the date and time (DateTime stored in mysql database) to a php DateTime object, one way is to override the class some how to make that happen, but is there any easier way than that? e.g. $date = new DateTime(); $date->setDate($mysql...

Answer:

$date = date('Y-m-d',strtotime($date_from_mysql)… you can use any date formatting as first parameter...

Read more

Ayub Zafar at Yahoo! Answers Mark as irrelevant Undo

Please help me connecting to mysql database using php.?

Hi guys, I have designed a very simple guestbook using a mysql database and php to link to my website but am having problems getting it going. Am fairly new to this kind of programming so I am sure its something simple ..... Basically ..... I have a...

Answer:

The code should work (I believe) so perhaps you have the wrong name of the database? I would suggest...

Read more

Yiaggi at Yahoo! Answers Mark as irrelevant Undo

Php mysql syntax help?

basically i get the following error returned "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1" and my code is " <?php include'conn.php...

Answer:

To access HTTP parameters, you need to use capital letters, eg -> $_POST['usid'] instead of $_post...

Read more

Bat at Yahoo! Answers Mark as irrelevant Undo

Why does MySQL perform poorly with nested indices?

I have a mysql table (articles) with a nested index (blog_id, published), and performs poorly. I see a lot of these in my slow query logs: - Query_time: 23.184007 Lock_time: 0.000063 Rows_sent: 380 Rows_examined: 6341 SELECT id from articles WHERE category...

Answer:

Did you try: "EXPLAIN SELECT id from articles WHERE category_id = 11 AND blog_id IN (13,14,15,...

Read more

Kellan Elliott-McCrea at Quora Mark as irrelevant Undo

Do you put the whole DB at risk by enabling transaction log flush delay - e.g set innodb_flush_log_at_trx_commit to 0?

Is it true that risks of having such an option turned on are actually higher than loosing just last N seconds of transactions? Let me explain why I'm asking this question. Imagine that DB server just processed a transaction T, and modified a set of index...

Answer:

Checkpoints (dirty page flushing) fsync transaction log too, to avoid the situation you mentioned. The...

Read more

Domas Mituzas at Quora Mark as irrelevant Undo

Is there a way to lock one/more rows in MySQL?

I have written a client-server program in JAVA, connected to MySQL database. The server handles each client in a separate thread. Now, at most each thread might lookup/edit only one row of the table. In order to promote better concurrency, it should...

Answer:

Using "SELECT FOR UPDATE" should be used for indexed column in your where clause, without...

Read more

Motasem Abuaker at Quora Mark as irrelevant Undo

In how many ways can you retrieve the date in the result set of MySQL using PHP?

Answer:

If you store MKTIME or date("z") then there are unlimited ways. Simply use date("d/m...

Read more

wiki.answers.com Mark as irrelevant Undo

How do you set the sort order when you select data from a Joomla MySQL table? I didn't find any answer in the developer wiki.

Answer:

Hi... Kinda of a loaded question. If you are using the raw mysql data via something like phpadmin thats...

Read more

tompet at Answerbag.com Mark as irrelevant Undo

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.