I have the following tables: CREATE TABLE `attendance_event_attendance` ( `id` int(11) NOT NULL AUTO_INCREMENT, `talk_id` varchar(200) NOT NULL, `membersAttended_id` varchar(200) NOT NULL, PRIMARY KEY (`id`), KEY `attendance_event_attendance_9ace4e5a` (`talk_id`), KEY `attendance_event_attendance_3c0dadb7` (`membersAttended_id`) ) ENGI...
Like facebook, everyone has messages on the wall. Are all messages stored in only one table? And it will only display messages belong to the user's ID when loading the page? And if it is then there will be so many rows in that table. Is there any limit of the rows in one table? Or every user has one table only store their own messages? ...
I have been backing up a MySQL database for several years with the command: mysqldump myDatabaseName -u root > myBackupFile.sql The backups have appeared to work fine... I then wanted to restore one of the backups to a different named database so I did: mysql myNewDatabaseName -u root < myBackupFile.sql I got some errors about logfi...
I need to be able to store something like this: where the green is a template type, the gray is a field container type, and the white is field. (That being, a field has a label and some text, both mediumtext for simplicity; and a field container can store other field containers or text, and a template is a top-level field.) Now, let's...
I have a facebook like system, I want the DIV containing the messages to automatically update when a new message is posted. Is this possible? If so, how would i go about doing this? <?php include('config.php'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html> <head> ...
I need to display a particular column in my SQL result only if it is not null. If it is null, I don't want that column to appear at all in my result. Is there a way to express this condition in SQL? ...
Hello, the table looks like this: tag | entryID ----+--------- foo | 1 foo | 2 bar | 3 And now i want to get all tags with its usage: foo | 2 bar | 1 How can I do this? Thank you ...
This is eluding me. I am trying to pull meta data about players that I have matched against each other in a game. Eg: Player 22 vs. Player 54 I have 2 mysql tables. Table: players (id, name, image_url, etc) 1 | John | john.jpg | etc 2 | George | george.jpg | etc 3 | Ian | ian.jpg | etc 4 | Steve | steve.jpg | etc Table: matchups (i...
I know it's such a basic thing, but a google search hasn't shown me how to resort the rows after clicking the 'th' links. I've got this: <table border="1"> <tr> <th>Type:</th> <th>Description:</th> <th>Recorded Date:</th> <th>Added Date:</th> </tr> <?php while($row = mysql_fetch_array($result)){ ?> <tr> ...
Assume I have a table that has the following structure: ================= | Id | ParentId | ================= | 1 | 0 | | 2 | 1 | | 3 | 1 | | 4 | 2 | | 5 | 2 | | 6 | 3 | | 7 | 3 | ----------------- This results in a tree like this: 1 / \ 2 3 / \ / \ 4 5 6 7...
I have a problem using the heroku db:push command to transfer a MySQL database to heroku. I've tried using the same command for another app with a sqlite3 database and everything went fine. C:\Users\reg\Team-Omni>heroku db:push Loaded Taps v0.3.9 Auto-detected local database: mysql://127.0.0.1/omni_dev?encoding=utf8 Warning: Data in t...
For the same data set, with mostly text data, how do the data (table + index) size of Postgresql compared to that of MySQL? Postgresql uses MVCC, that would suggest its data size would be bigger In this presentation, the largest blog site in Japan talked about their migration from Postgresql to MySQL. One of their reasons for moving aw...
Hi All, Just a quick question here: If I choose the object oriented style to interact with my database, ie... $mysqli = new mysqli("localhost", "my_user", "my_password", "world"); And I then use $mysqli->close(); to close the connection at some point... Can I reopen that connection by simply initiating another query $mysqli->quer...
I was just kindly helped to get the rows in a table to display using ORDER BY. Then I realized I also want to click the same link to decrement if desired. I tried to set up a conditional, but it's not working as I expected: <?php $orderBy = array('type', 'description', 'recorded_date', 'added_date'); $order = 'type'; if (isset($_GET...
hi, ive written a pagination class and it looks like its not outputting the correct amount of rows. i have a table full of 51 records and instead it shows only 30 records and as for the pages it shows only page 1 where it should show page 1 and 2. the pages are viewed by going to page=1 as a browser param. when i try to view page=2 i see...
I have a table which stores high-scores, along with player ids. I want to be able to extract a record by a players id, and then get the rank, or position of their score in the table. Means, Basically I want to be able to say "you are in Nth" position, purely based on the players score against all other scores. For Example: if i am at 46t...
I am running IIS and WAMP on same PC. The IIS is running on localhost and Wamp is running on localhost:8080. Now the problem is that when i strat to install joomla in WAMP, the installation is not proceeding from database configuration step. I enter the host name as localhost:8080 on database configuration step. ...
MySQL uses TinyINT to serve as a boolean field. Given the possible options of 0 and 1, I decided that I'd flip values like this: UPDATE table SET boolean_field = ABS(boolean_field - 1) WHERE Circle-K = 'Strange things are afoot' So you either go 1 -> 0 -> ABS(0) = 0 or 0 -> -1 -> ABS(-1) = 1 now I'm curious if this is acceptable or ...
The following query gives the error "#1241 - Operand should contain 1 column(s)" because of the (Department_Code, Course_Code) line. When I replace that with just (Course_Code) it works. However, that's not what I want SELECT * FROM Classes GROUP BY CASE WHEN (1) THEN Department_Code ELSE CASE WHEN (2) THEN (Department_Code, Cou...
i am new in php and want to know the code for php mysql database connection code ...