0
votes
2answers
5 views

Silverstripe get the last 8 items by date and display them in reverse order

I'm a beginner in PHP and Silverstripe so I apologise if the question has a very simple answer. I'm trying to get the last 8 items by date from a list of gigs and display them in reverse (ascending) ...
0
votes
1answer
20 views

php result within a date range

I am an absolute newbie and still working out the kinks. So spare me if the code looks amateurish. I have this form.html The user enters the date range. form action="report.php" method="post" ...
1
vote
1answer
251 views

Test Gearman/MySQL - Persistence Layer

Running Fedora, PHP/Gearman/MySQL/Drizzle. Built Gearman/Drizzle from source, and have the process running on a linux/fedora box. I created the mysql test table, and can see that the Gearman Daemon ...
0
votes
2answers
26 views

MySQL join two tables where date between two dates

I'm having a table that contains 6 columns: id (PK, A_I), systemID (varchar(32)), total (varchar(32)), difference (varchar(16)), updated (datetime), error (int). The table is updated every hour and ...
0
votes
0answers
25 views

Store a playing cards deck in MySQL (single column)

I'm doing a game with playing cards and have to store shuffled decks in MySQL. What is the most efficient way to store a deck of 52 cards in a single column? And save/retrieve those using PHP. I ...
0
votes
1answer
35 views

mysql database adding trailing 0 to decimal

I have a db storing latitude and longitude. I have the latitude column set to decimal 9,7 and longitude set to decimal 10,7. It works fine when the latitude is 9 numbers long, problem is if the ...
0
votes
5answers
146 views
+50

Image upload script only works for latest <li></li> saved in DB

Below is a script to upload images and save them to the DB. On one page of the website, there's a table and inside each <li></li>, there is an upload icon where users can add one image. ...
0
votes
1answer
23 views

Getting data-fields from td:first row

I have a table that gets created using php drawing straight out of a database. Each td is editable and, when the mouse is clicked elsewhere, the new data is sent to the database and updated ...
1
vote
1answer
11 views

Grabbing user id of current logged user and add it as foreign key value in a different table returns null - MySQL - CodeIgniter

I'm trying to insert data based on current logged in user. I'm grabbing the user email address from the session data, then I query users table for the user_id that matches the unique email address but ...
1
vote
0answers
25 views

Using result of a PHP echo in HTML/JavaScript var for Google Maps

Long time reader, first time poster. Hoping you all can help me out. I'm an absolute novice to PHP and JavaScript but am strong with HTML, and have past experience with Google Maps but this is a bit ...
1
vote
2answers
24 views

How can I select and display the maximum (and minimum) values from among several fields in a single record in mysql using php

I have a table which lists several tours and for each tour there are several categories of accommodation types with different prices, along with a lot of other fields such as dates, deadlines etc. It ...
-3
votes
1answer
41 views

To expand variables in string for PHP from a MySQL query result

The code below is a tiny version of it. My MySQL table "reports" look like this: reports rep_id rep_description rep_query varchar 3 varchar 50 varchar 50 ...
0
votes
3answers
30 views

multiple mysql statements not executed via php (statement works via phpmyadmin)

While creating a statistics program I'm keeping track how many aircraft visit an aerodrome per hour. My script calculates the number of flights in the last hour and saves this to the database. my i ...
1
vote
1answer
72 views

Problems with new users in MySQL

I'm a novice in MySql and can't solve problem I've bumped into (Google search gave me no results). The problem is "error 1045 access denied for user" for new users. I'm writing a small script on PHP ...
0
votes
0answers
15 views

Doctrine many to one relation with no additional key

I've made some projects with many-to-one/many relations, foreign keys etc in doctrine and they all worked well. At least as long as I could join them by id and some other index. This time I have a ...

15 30 50 per page