No, I don't want to obtain multiples records from the diferent tables, I want A SINGLE RECORD with the most recent changes of ALL THE TABLES.
The admin will have a history button to obtain all the changes made if he/she want, but when presenting info I want only ONE record.
ayukawaa
Last Activity: Nov 25 '12, 05:00 PM
Joined: Sep 20 '12
Location:
-
Rabbit no, that will select multiples values from multiples tables.
One table can have 5 updates, but another table can have 23 updates, but I only want the LAST RECORD of EACH table of the id given .
That's driving me crazy.
*_*Leave a comment:
-
You have to have something on the database updated everytime the user ask for a page.
It could be a counter for the pages shown, or anything you want
In my case, I have the sessions stored in the database, and they are updated on every request so you only have to SELECT COUNT()... FROM SESSIONS WHERE the time is now minus 10 minutes...Leave a comment:
-
Mysql: How to SELECT from diferent tables...
Due to the fact of the many fields asociated with a single company for some project (200+), I've have to change from a single row to 6 tables asociated with the main table through the id of the row of the main table...
FIRST: I'm not allowed to DELETE or UPDATE ANYTHING.
Each of the tables can be updated mutiples times...
Every time a record is updated, it is INSERT as a NEW record (with the ID of the... -
Why don't you change from MYSQL to SQLITE ???????????
SQLITE is only a FILE and PHP can access it directly.
I have to done it some time ago for a CDROM and that worked FINE !!!Leave a comment:
-
There are many ways... first check with your telephone provider (NOT ISP)
I've done it sending an email to my_own_number@m y_telephone_com pany.com with some special field in the headers that let them know where to send the email as SMS.Leave a comment:
-
ayukawaa replied to Record insert, delete fetch and update through PHP coding with database connection atin PHPUse at the same time actions readed from the GET and POST.
First, look for the action in the $_GET (insert/update/delete) and show the form based in the action given (see below).
If the action does not exist, show a table with the LIST of the records from the database.
In each row, add the actions like this
...Code:<a href="index.php?action=update&id=<?php echo $row_id;?>">UPDATE</a>
Leave a comment:
-
I use the fields like this
that works fine !!!!!!!!!!!!Code:<input name="ejercicio" type="text" id="ejercicio" value="<?php echo array_key_exists('ejercicio', $_POST) ? htmlentities($_POST['ejercicio'], ENT_COMPAT, 'utf-8') : ''; ?>" size="6" maxlength="4" />Leave a comment:
-
Here's my own function for dealing with this... and works with ANY array
$iit1=read_from _array[$_POST, 'iit1'];
...Code:/* * READ A VALUE FROM AN ARRAY * param array - array from where to read * param string - key to read from the array * param string - default_value to return if the key does not exist or the it is not a valid array * param php_function - php function to execute using the key value
Leave a comment:
No activity results to display
Leave a comment: