"select" query dies, not sure why

[Phil Powell]

$sql = 'INSERT INTO fs_usermetadata (' . substr(trim($co ls), 0,
strrpos(trim($c ols), ',')) .
') VALUES (' . substr(trim($va lues), 0, strrpos(trim($v alues),
',')) . ')';

if (!mysql_query($ sql)) {
$hasSubmittedUs er = 0;
$errorMsg .= $font . '<font color=cc0000><l i>Could not insert record
into db</li></font>' .
'</font><p>';
}

if ($hasSubmittedU ser) {
// THIS BLOCK WILL ENSURE THAT THE ID WILL BE PASSED AND ALL DATA
GATHERED FOR EDITING
// OF RECENTLY SUBMITTED INFORMATION
$willEditUser = 1;
$sql = 'SELECT fs_userid FROM fs_usermetadata ' .
'WHERE fs_username = \'' . $fs_username . '\' ' .
' AND fs_password = \'' . $fs_password . '\' ';
$query = mysql_query($sq l) or die('Could not run updated data select
query: ' . $sql);
while ($row = mysql_fetch_arr ay($query, MYSQL_ASSOC)) $id =
$row["fs_userid"];
}

On occasions the "select" query will die for no apparent reason. The
"insert statement" is nullified and not done either. However, upon the user
hitting the back browser button and resubmitting both work fine and then
continue to work fine for an indeterminate amount of time.

Perhaps I'm missing something here: what I'm trying to do is insert a new
record and immediately obtain the id column field value from the new record.

Thanks
Phil

[E-Star]

Re: &quot;select&qu ot; query dies, not sure why

In article <9z91b.4614$xf. 592@lakeread04> , Phil Powell
<soazine@erols. com> wrote:
[color=blue]
> $sql = 'INSERT INTO fs_usermetadata (' . substr(trim($co ls), 0,
> strrpos(trim($c ols), ',')) .
> ') VALUES (' . substr(trim($va lues), 0, strrpos(trim($v alues),
> ',')) . ')';
>
> if (!mysql_query($ sql)) {
> $hasSubmittedUs er = 0;
> $errorMsg .= $font . '<font color=cc0000><l i>Could not insert record
> into db</li></font>' .
> '</font><p>';
> }
>
> if ($hasSubmittedU ser) {
> // THIS BLOCK WILL ENSURE THAT THE ID WILL BE PASSED AND ALL DATA
> GATHERED FOR EDITING
> // OF RECENTLY SUBMITTED INFORMATION
> $willEditUser = 1;
> $sql = 'SELECT fs_userid FROM fs_usermetadata ' .
> 'WHERE fs_username = \'' . $fs_username . '\' ' .
> ' AND fs_password = \'' . $fs_password . '\' ';
> $query = mysql_query($sq l) or die('Could not run updated data select
> query: ' . $sql);
> while ($row = mysql_fetch_arr ay($query, MYSQL_ASSOC)) $id =
> $row["fs_userid"];
> }
>
> On occasions the "select" query will die for no apparent reason. The
> "insert statement" is nullified and not done either. However, upon the user
> hitting the back browser button and resubmitting both work fine and then
> continue to work fine for an indeterminate amount of time.
>
> Perhaps I'm missing something here: what I'm trying to do is insert a new
> record and immediately obtain the id column field value from the new record.
>
> Thanks
> Phil
>
>[/color]
What kind of error handling are you doing? You aren't using
Dreamweaver are u?

[Phil Powell]

Re: &quot;select&qu ot; query dies, not sure why

No this is all freehand, cannot afford Dreamweaver.. error handling is a bit
dodgy since it's not set up on the hosting service other than what you throw
in your die() statements and mysql_error().

Phil

"E-Star" <unix_core@linu xmail.org> wrote in message
news:2108200314 19197203%unix_c ore@linuxmail.o rg...[color=blue]
> In article <9z91b.4614$xf. 592@lakeread04> , Phil Powell
> <soazine@erols. com> wrote:
>[color=green]
> > $sql = 'INSERT INTO fs_usermetadata (' . substr(trim($co ls), 0,
> > strrpos(trim($c ols), ',')) .
> > ') VALUES (' . substr(trim($va lues), 0, strrpos(trim($v alues),
> > ',')) . ')';
> >
> > if (!mysql_query($ sql)) {
> > $hasSubmittedUs er = 0;
> > $errorMsg .= $font . '<font color=cc0000><l i>Could not insert[/color][/color]
record[color=blue][color=green]
> > into db</li></font>' .
> > '</font><p>';
> > }
> >
> > if ($hasSubmittedU ser) {
> > // THIS BLOCK WILL ENSURE THAT THE ID WILL BE PASSED AND ALL DATA
> > GATHERED FOR EDITING
> > // OF RECENTLY SUBMITTED INFORMATION
> > $willEditUser = 1;
> > $sql = 'SELECT fs_userid FROM fs_usermetadata ' .
> > 'WHERE fs_username = \'' . $fs_username . '\' ' .
> > ' AND fs_password = \'' . $fs_password . '\' ';
> > $query = mysql_query($sq l) or die('Could not run updated data select
> > query: ' . $sql);
> > while ($row = mysql_fetch_arr ay($query, MYSQL_ASSOC)) $id =
> > $row["fs_userid"];
> > }
> >
> > On occasions the "select" query will die for no apparent reason. The
> > "insert statement" is nullified and not done either. However, upon the[/color][/color]
user[color=blue][color=green]
> > hitting the back browser button and resubmitting both work fine and then
> > continue to work fine for an indeterminate amount of time.
> >
> > Perhaps I'm missing something here: what I'm trying to do is insert a[/color][/color]
new[color=blue][color=green]
> > record and immediately obtain the id column field value from the new[/color][/color]
record.[color=blue][color=green]
> >
> > Thanks
> > Phil
> >
> >[/color]
> What kind of error handling are you doing? You aren't using
> Dreamweaver are u?[/color]

[Phil Powell]

Re: &quot;select&qu ot; query dies, not sure why

I refined the code to the following:

$sql = 'INSERT INTO fs_usermetadata (' . substr(trim($co ls), 0,
strrpos(trim($c ols), ',')) .
') VALUES (' . substr(trim($va lues), 0, strrpos(trim($v alues),
',')) . ')';

if (!mysql_query($ sql)) {
$hasSubmittedUs er = 0;
$errorMsg .= $font . '<font color=cc0000><l i>Could not insert record
into db: ' .
mysql_error() . '</li></font></font><p>';
} else {
$willEditUser = 1; // BE SURE TO SWITCH MODE TO EDIT UPON SUCCESSFUL
INSERT TO EDIT NEW USER
$id = mysql_insert_id (); // OBTAIN ID IMMEDIATELY AFTER INSERT QUERY
$tableHTML .= "\n<p>${font}<f ont color=000099>Ne w User: <b>" .
$fs_user_firstn ame .
' ' . $fs_user_lastna me . '</b> added to the
database</font></font><p>';
}

So far everything seems stable.

Phil
"E-Star" <unix_core@linu xmail.org> wrote in message
news:2108200314 19197203%unix_c ore@linuxmail.o rg...[color=blue]
> In article <9z91b.4614$xf. 592@lakeread04> , Phil Powell
> <soazine@erols. com> wrote:
>[color=green]
> > $sql = 'INSERT INTO fs_usermetadata (' . substr(trim($co ls), 0,
> > strrpos(trim($c ols), ',')) .
> > ') VALUES (' . substr(trim($va lues), 0, strrpos(trim($v alues),
> > ',')) . ')';
> >
> > if (!mysql_query($ sql)) {
> > $hasSubmittedUs er = 0;
> > $errorMsg .= $font . '<font color=cc0000><l i>Could not insert[/color][/color]
record[color=blue][color=green]
> > into db</li></font>' .
> > '</font><p>';
> > }
> >
> > if ($hasSubmittedU ser) {
> > // THIS BLOCK WILL ENSURE THAT THE ID WILL BE PASSED AND ALL DATA
> > GATHERED FOR EDITING
> > // OF RECENTLY SUBMITTED INFORMATION
> > $willEditUser = 1;
> > $sql = 'SELECT fs_userid FROM fs_usermetadata ' .
> > 'WHERE fs_username = \'' . $fs_username . '\' ' .
> > ' AND fs_password = \'' . $fs_password . '\' ';
> > $query = mysql_query($sq l) or die('Could not run updated data select
> > query: ' . $sql);
> > while ($row = mysql_fetch_arr ay($query, MYSQL_ASSOC)) $id =
> > $row["fs_userid"];
> > }
> >
> > On occasions the "select" query will die for no apparent reason. The
> > "insert statement" is nullified and not done either. However, upon the[/color][/color]
user[color=blue][color=green]
> > hitting the back browser button and resubmitting both work fine and then
> > continue to work fine for an indeterminate amount of time.
> >
> > Perhaps I'm missing something here: what I'm trying to do is insert a[/color][/color]
new[color=blue][color=green]
> > record and immediately obtain the id column field value from the new[/color][/color]
record.[color=blue][color=green]
> >
> > Thanks
> > Phil
> >
> >[/color]
> What kind of error handling are you doing? You aren't using
> Dreamweaver are u?[/color]