I have a table with the following fields: Nome(VARCHAR) , Email(VARCHAR) , Credito(INT)
I wanted to know how, or with what command, to decrease or increase the Credito field.
I know you have to use UPDATE b...
How can I get the amount of online users on my site (instantly) using only PHP MYSQL and JQUERY? and respectively get the time the user spent on my site
$a = mysql_query("SELECT * FROM catalog_items where page_id='84'") or die(mysql_error());
while ($row = mysql_fetch_array($a)){
$base_item = $row['item_ids'];
mysql_query("DELETE FROM items_rooms where base_item = '".$base_item."'")
or...
I have a form that has a field where the user's date of birth is entered, this field has a datepicker that already returns the date in year, month, day format, this date is accessed through $_GET['birthdate'] its format is strin...
I have a Bank in MySQL Workbench with the data filled in and I want to pass this all filled-in data to another MySQL Workbench, but on another computer.
Is it possible to do this, or will I have to populate the data all over again?
I have a cadre of craftsmen with about 90 thousand records. I created the SQL below to return me the total of artisans in each of the regions that they are registered. Although it works, it is slow, taking more than 30 seconds to return the reco...
I'm doing a QUIZ and at some point I have to show the percentage of the alternatives chosen by the users. I have this table:
ID RESPOSTA
1 a
2 a
3 b
4 b
5 c
6 a
The answer I need to have from MYSQL would be the percentages of choice:...
I have a table in my database and would like to mark occurrences where certain code repeats itself. Remember that this code field is not a primary key.
Example:
Data Código Repetição Status ...
25/2/2014 138863 ok...
I am trying to read a field in a table that is of integer type. And it's also a primary key and auto-increment.
The returned value is put in a label (already tried to put in an input text too).
To read the target table and put the result i...