Traducción
Establecer como idioma predeterminado
por
Archivo de la etiqueta: 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.
Mi código PHP(funciona bien… Sigue leyendo
Etiquetado Androide, imagen, php, sql
Deja un comentario
Fastest random selection WHERE colum X is Y
Actualmente estoy 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
…
Etiquetado mysql, php, sql
Deja un comentario
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… Sigue leyendo
Etiquetado base de datos, Java, NoSQL, php, sql
Deja un comentario
How to pause a loop after 2 runs, 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 (salida 2 results/items), and THEN insert a banner ONCE right after the 2nd result, and THEN let loop continue from… Sigue leyendo
Etiquetado bucles, php, sql
Deja un comentario
Hacer mis propios análisis de sitios web
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.… Sigue leyendo
Etiquetado analytics, php, sql
Deja un comentario
¿Cómo lidiar con FECHA tipo en 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… Sigue leyendo
Etiquetado fecha y el formato, mysql, php, simpledateformat, sql
Deja un comentario
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, así que aquí va…
I have four tables, let’s simplify them:
players
=======
id name surname
1 John Arbuckle
2 Walter White
3 Don …
Etiquetado unirse, php, sql
Deja un comentario
How can I print the field of the table [cerrado]
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');
…
Etiquetado base de datos, php, fila, sql
Deja un comentario
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, en… Sigue leyendo
Etiquetado html, mysql, php, sql
Deja un comentario
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… Sigue leyendo
Etiquetado mysql, php, sql
1 comentario
60 páginas