Subject RE: [firebird-php] auto increment last insert
Author Johan van Zyl
Will this never end?<g>
No error in that line anymore - but UserID =
and new problem in line 121

$ret = ibase_query( 'SELECT GEN_ID( G_USERS, 1 ) FROM RDB$DATABASE');
$userid = $ret->fields[0];

echo 'UserID = '.$userid.'<br/>';
$sql = ibase_query("INSERT INTO users (userid, first_name, last_name,
email_address, username, \"PASSWORD\", info)
VALUES('$userid', '$first_name', '$last_name', '$email_address',
'$username', '$db_password', '$info2')") or die (ibase_errmsg()); //line 121

UserID =

Warning: InterBase: conversion error from string "" in
/home/e-smith/files/ibays/Primary/html/mc/register.php on line 121
conversion error from string ""

Johan van Zyl
-----Original Message-----
From: Lester Caine [mailto:lester@...]
Sent: 24 November 2004 12:40
Subject: Re: [firebird-php] auto increment last insert

Johan van Zyl wrote:

> Thx!
> What is $conn ?
> $ret = $conn->Execute( 'SELECT GEN_ID( G_USERS, 1 ) FROM

ADOdb ;) I just cut and pasted without thinking :)

$ret = ibase_query( 'SELECT GEN_ID( G_USERS, 1 ) FROM RDB$DATABASE');

Lester Caine
L.S.Caine Electronic Services

Yahoo! Groups Sponsor

Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.799 / Virus Database: 543 - Release Date: 2004/11/19

[Non-text portions of this message have been removed]