-4
votes
0answers
33 views
How to Return Single Value for multiple same value in SQL?
I want to display something like :
Chelsea : jay,king,super
Liverpool : jaz,hitman,anchor
Here is code, which I used.
$sql = "SELECT team,uid from fflt6 where group by team";
$items = ...
0
votes
0answers
37 views
I need to refresh the page about four times to make “commit” take effect
I'm working on the controller of a distributed system that is written in php.
I'm using persistent connection using "mysql_pconnect()" because I need such a connection for distributed transactions.
...
0
votes
1answer
36 views
pageviews counter updating with false data
I have this post table set up that has a hits column in it. The hits column is to store the number of times the post is viewed. The problem however is in the update query. The database is on my ...
-2
votes
1answer
41 views
Bulk insertion in MySQL using PHP
I am working on developing an attendance management system. It has a form which shows the detail of all employees in a department and attendance can be marked via a dropdown menu for each case. The ...
-2
votes
4answers
37 views
find number in table with a particular number in php
I have a table contain field
id- No - point
1 - 10 - 23
2 - 100 - 20
3 - 200 - 30
when i search a no like 56.
Output i want.
only 100
not 100,200
3
votes
2answers
29 views
How to preserve newline between textarea and database?
I am storing the user input in a text area into a database by using nl2br().<br/>
Now the problem is that I do not want to show the "br" tags when I show this input in a text area later but as a ...
0
votes
2answers
25 views
php can`t delete more than one row
I`m using a form with several checkboxes to make the user to select which rows he want to delete. The code to generate the form is this:
if ($busqueda!=""){
$busca = mysqli_query($con, " SELECT ...
0
votes
3answers
29 views
Rename for column names in inner Join
I have 2 tables like this:
Table 'c'
| id | item_1 | item_2 |
-------------------------------
| 1 | 1 | 2 |
-------------------------------
Table 'i'
| id | name |
...
1
vote
0answers
24 views
In PHP, MySQL throws Commands out of sync error, while trying to use '$mysqli->multi_query'
In PHP, while I try to use $mysqli->multi_query second time, it throws me following error.
I looked at MySQL manual, and similar questions asked at SO, all suggest using
either ...
0
votes
2answers
22 views
Calculate Number of Occupied Days within a date period using MySQL and PHP
I have an apartment booking system and need to generate a report of number of occcupied days vs. unoccupied days within a date period on a property by property basis.
Bearing in mind within the ...
0
votes
1answer
24 views
Mysql count with descending with join and where clause ,two tables, limit?
Here i have implemented two tables (pages, pagestatistics).I need result for last five records using join from the those tables and also i need a count of cID field from second table (pagestatistics), ...
-1
votes
1answer
22 views
Send a picture from iOS app to php script to mySQL DB
I've a problem: I want to send a picture from my iOS app to a php script to insert this image in a mysql db. The field in mysql db for the image is LONGBLOB. The image that is sending is ...
0
votes
2answers
20 views
Getting data from MySQL table via Codeigniter
I'm having issues getting this data from within a codeigniter Controller.
$q = $this->db->get('offers_orders');
$this->db->select('total');
...
0
votes
2answers
32 views
php - dynamic mysql_query in for loop from url array
I've looked for something similar on stack but nothing exactly as this.
I (think I) need to generate a unique MySQL query inside a loop as each iteration needs to look up a different table. the loop ...
-2
votes
1answer
29 views
Converting Different Date format to single format using mysql and fetching today;s dateofbirth list [on hold]
I have database of users with dateofbirth field
but many peoples have entered in different format while adding date for date of birth
now i want to convert all the dates in a single format using mysql ...
