On Sun, 28 Sep 2003 21:32:51 GMT,
ng@lycaus.plusYOURSHIT.com (Dariusz) wrote:
[color=blue]
>I have PHP code (below) which reads data from a MySQL format database. The
>problem I am having is trying to find out when the last ID entry was made.[/color]
From the 'when' above, it sounds like you want date and time?
[color=blue]
>When the script is executed, the $gbID is supposed to be read and display
>the last entered ID number ($How_many_entries) - the ID number is entered /
>updated automatically in another PHP script which deals with data entry to
>the database.[/color]
But now you say you only want the last allocated ID number?
[color=blue]
>But instead of displaying the result of the query, it displays the ID
>number ($How_many_entries) as "Resource id #4", and looking around the
>search engines, no page makes particular sense as to what I've done wrong.[/color]
That would mean you're using a result set resource directly in a print
statement, rather than fetching rows from it.
[color=blue]
>Does anyone know how to get the $gbID number from the database and into
>$How_many_entries so I can perform some math work on it?[/color]
Another confusion from your choice of variable name; the last allocated ID
number may have no relation to how many entries there actually are, for various
reasons.
When the last entry was entered: SELECT MAX(date_field) FROM table. Relies on
there actually being a date field in there, of course.
The last allocated ID: This is part of the table metadata in MySQL, which you
can get from SHOW TABLE LIKE 'name'. A less reliable method could be SELECT
MAX(id) FROM table, but the last allocated ID could (a) have been deleted or
(b) be well below the most recent ID, if the auto_increment number had been
reset for that table.
[color=blue]
>// Display database entries in reverse order (remove 'DESC' to have forward
>display of results)
>$sql = "SELECT gbID, gbDate, gbIP, gbURL, gbName, gbComment FROM
>$table_to_look_for ORDER BY gbid DESC";
>
>$result = @mysql_query($sql, $connection) or die("<B>Problem reading from
>database: </B>".mysql_error());
>
>while ($row = mysql_fetch_array($result))
>{
>$gbID = $row['gbID'];
>$gbDate = gmstrftime('%A %d %B %Y at $T',strtotime($row['gbDate']));
>$gbURL = $row['gbURL'];
>$gbName = $row['gbName'];
>$gbComment = nl2br($row['gbComment']);
>
>$display_entry .= "$gbID:<BR><B>Posted on: </B>$gbDate <B>IP:
></B>Logged<BR><B>Posted by: </B>$gbName<BR><B>Personal website:
></B>$gbURL<BR><B>Comment: </B>$gbComment<BR><BR>";
>}
>
>$sql = "SELECT last_insert_id($gbID) FROM $table_to_look_for";[/color]
This will not work. LAST_INSERT_ID returns the ID value that was generated in
the previous INSERT statement involving an AUTO_INCREMENT column, for this
connection only.
[color=blue]
>$How_many_entries = @mysql_query($sql, $connection);
>
>// $How_many_entries = $How_many_entries / 5;
>echo "Entries: $How_many_entries<BR>";[/color]
You have to fetch from the resource returned by mysql_query, as you did above.
You can't use it directly, it's just a resource handle.
--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (
http://www.andyh.co.uk)
Space: disk usage analysis tool (
http://www.andyhsoftware.co.uk/space)
