Browse Moodle Solutions

I have two dates of the form: ```lang-none Start Date: 2007-03-24 End Date: 2009-06-26 ``` Now I need to find the difference between these two in the f...

When running my script, I am getting several errors like this: > Warning: Cannot modify header information - headers already sent by (**output started at...

What's the best way to determine the first key in a possibly associative array? My first thought it to just foreach the array and then immediately breaking...

I have a bunch of client point of sale (POS) systems that periodically send new sales data to one centralized database, which stores the data into one big datab...

Actually I want to read the contents that come after the search query, when it is done. The problem is that the URL only accepts `POST` methods, and it does not...

I'm building a PHP script that feeds JSON data to another script. My script builds data into a large associative array, and then outputs the data using `jso...

I want to find an SQL query to find rows where field1 does not contain $x. How can I do this?

What is the best method to copy the data from a table in one database to a table in another database when the databases are under different users? I know t...

I have the following table schema which maps user_customers to permissions on a live MySQL database: mysql> describe user_customer_permission; +-...

In the footer of my page, I would like to add something like "last updated the xx/xx/200x" with this date being the last time a certain mySQL table ha...

To find out the start command for mysqld (using a mac) I can do: ps aux|grep mysql I get the following output, which allows me to start mysql server....

I am using prepared statements to execute mysql database queries. And I want to implement a search functionality based on a keyword of sorts. For that I nee...

I can't start the mysql service in Snow Leopard, and in the panel prefs appears the message, > warning the user/local/mysql/data directory is not owne...

I'm trying to finish this query; my tag field is set to UNIQUE and I simply want the database to ignore any duplicate tag. INSERT INTO table_tags (t...

I am not very familiar with databases and the theories behind how they work. Is it any slower from a performance standpoint (inserting/updating/querying) to us...

When I execute this command in MySQL: SET FOREIGN_KEY_CHECKS=0; Does it affect the whole engine or it is only my current transaction?

How to calculate the difference between two dates, in the format `YYYY-MM-DD hh: mm: ss` and to get the result in seconds or milliseconds?

So here's what I want to do on my _MySQL_ database. I would like to do: SELECT * FROM itemsOrdered WHERE purchaseOrder_ID = &#39...

How can I make a copy values from one column to another? I have: Database name: list ------------------- number | test --------------...

I am trying to make sure that my app container does not run migrations / start until the db container is started and READY TO accept connections. So I decide...