Tagged Questions
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 ...