Tradução
Definir como idioma padrão
por
Tag Archives: sql
How can I send an image from an sql database to an android client?
I’m trying to send an image from an sql database to an android client. I’m doing this by way of a php middleman. The code stops working due to a null returning of the method below.
Meu código php(funciona bem… Continue lendo
Tagged Andróide, imagem, php, sql
Deixe um comentário
Fastest random selection WHERE colum X is Y
Atualmente estou usando:
SELECT *
FROM
table AS t1
JOIN (
SELECT (RAND() * (SELECT MAX(id) FROM table where column_x is null)) AS id
) AS t2
WHERE
t1.id >= t2.id
and column_x is null
ORDER BY r1.id ASC
…
Tagged mysql, php, sql
Deixe um comentário
What is the best architecture to use at the back end for a java client based client/server setup?
I’m fairly new to programming and have been focussing a great deal on Java in recent months. I would like to write an application with a Java applet front end which will capture information about my users and allow for… Continue lendo
Tagged banco de dados, Java, nosql, php, sql
Deixe um comentário
How to pause a loop after 2 corre, insert code in between once, then continue loop where it left off?
I currently have a loop of items being shown on a page.
I would like to run the loop twice (saída 2 results/items), and THEN insert a banner ONCE right after the 2nd result, and THEN let loop continue from… Continue lendo
Tagged loops, php, sql
Deixe um comentário
Fazendo minhas análises próprio site
I decided that Google Analytics isn’t the best way to go around getting accurate numbers, as users who don’t have JavaScript enabled in their browser wont be counted. So therefore I would like to go around making my own Anylytics.… Continue lendo
Tagged analytics, php, sql
Deixe um comentário
Como lidar com o tipo DATE em MYSQL & PHP?
I’m building a website with php and i’m using the DATE-type in my MYSQL table to store dates. The problem that i have is that this stores the dates by default in the format YYYY-MM-DD. But i need this format… Continue lendo
Tagged data-formatação, mysql, php, simpledateformat, sql
Deixe um comentário
SQL/ PHP Joining table, ignoring multiple records
I don’t really know how to even search for resolution of this problem, didn’t find anything specific, então aqui vai…
I have four tables, let’s simplify them:
players
=======
id name surname
1 John Arbuckle
2 Walter White
3 Don …
Tagged juntar, php, sql
Deixe um comentário
How can I print the field of the table [fechado]
I want to print beyond the picture, the name of its. The field name is on the sql table at the bottom.
To explain i want to print on this site and picture and the name.
http://kosar.comule.com/category.php
<?php require_once ('connect/connect.php');
…
Tagged banco de dados, php, linha, sql
Deixe um comentário
SQL SELECT query causing different column error
i am trying to sort out the mail trash section of my site and it is proving troublesome, i had problems with the query before and finally got it to work, but now the pagination is also causing trouble, em… Continue lendo
Tagged html, mysql, php, sql
Deixe um comentário
Mysql row always = 1
Hello i am trying to check to see if there is a row in the db but for some resson it keeps saying there is but is not. I have loads of if staments in side one so i think… Continue lendo
60 páginas