Geeklog Forums

Hi,
Is anyone else having the same problem as me with php 4.3.10
I've rebuild php from scratch, and still have the same problem.
My problem is that DB_insertID doesn't return anything.
I have to replace all calls to DB_insertID with calls to last_insert_id()
DB_insertID calls mysql_insert_id() which doesn't seem to work.

Jon

---

www.plymouthcricketclub.com - providing cricket for all ages in the Plymouth area.

I've now replaced the actual DB_insertID function (in lib-database.php) with:
$sql="select last_insert_id()";
$result = DB_query($sql);
$ID=DB_fetchArray ($result);
return $ID[0];

I'm still not certain if this is applicable to all installations of php 4.3.10 or not.
Jon

---

www.plymouthcricketclub.com - providing cricket for all ages in the Plymouth area.

What version of mysql are you using. I'm thinking it's more a mysql issue is it not?

---

Geeklog components by PortalParts -- www.portalparts.com

Wanted to thank you!!! This is exactly the problem I have been having with my installation, and your snippet of code seems to have worked.

I have PHP Version 4.3.11 on the server I'm hosted on. And the calls to DB_InsertID were returning zeros.

---

T.Marquez Jr. -
Webmaster -
www.indianapolisfilm.net - Geeklog 1.4.0sr5-1