Traduzione
Configura come lingua predefinita
da
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.
My php code(funziona bene… Continua a leggere
Tagged android, immagine, php, sql
Lascia un commento
Fastest random selection WHERE colum X is Y
Currently I am using:
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
Lascia un commento
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… Continua a leggere
Tagged banca dati, Giava, NoSQL, php, sql
Lascia un commento
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 (produzione 2 results/items), and THEN insert a banner ONCE right after the 2nd result, and THEN let loop continue from… Continua a leggere
Tagged loops, php, sql
Lascia un commento
Fare le mie analisi dei siti web personali
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.… Continua a leggere
Tagged analytics, php, sql
Lascia un commento
Come comportarsi con DATE-tipo in 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… Continua a leggere
Tagged date-formatting, mysql, php, simpledateformat, sql
Lascia un commento
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, quindi ecco qui…
I have four tables, let’s simplify them:
players
=======
id name surname
1 John Arbuckle
2 Walter White
3 Don …
Tagged unire, php, sql
Lascia un commento
How can I print the field of the table [chiuso]
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 banca dati, php, fila, sql
Lascia un commento
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, in… Continua a leggere
Tagged html, mysql, php, sql
Lascia un commento
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… Continua a leggere
60 pagine