471,320 Members | 2,051 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,320 software developers and data experts.

"select" query dies, not sure why

$sql = 'INSERT INTO fs_usermetadata (' . substr(trim($cols), 0,
strrpos(trim($cols), ',')) .
') VALUES (' . substr(trim($values), 0, strrpos(trim($values),
',')) . ')';

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

if ($hasSubmittedUser) {
// 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($sql) or die('Could not run updated data select
query: ' . $sql);
while ($row = mysql_fetch_array($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
Jul 16 '05 #1
3 2741
In article <9z91b.4614$xf.592@lakeread04>, Phil Powell
<so*****@erols.com> wrote:
$sql = 'INSERT INTO fs_usermetadata (' . substr(trim($cols), 0,
strrpos(trim($cols), ',')) .
') VALUES (' . substr(trim($values), 0, strrpos(trim($values),
',')) . ')';

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

if ($hasSubmittedUser) {
// 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($sql) or die('Could not run updated data select
query: ' . $sql);
while ($row = mysql_fetch_array($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

What kind of error handling are you doing? You aren't using
Dreamweaver are u?
Jul 16 '05 #2
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" <un*******@linuxmail.org> wrote in message
news:210820031419197203%un*******@linuxmail.org...
In article <9z91b.4614$xf.592@lakeread04>, Phil Powell
<so*****@erols.com> wrote:
$sql = 'INSERT INTO fs_usermetadata (' . substr(trim($cols), 0,
strrpos(trim($cols), ',')) .
') VALUES (' . substr(trim($values), 0, strrpos(trim($values),
',')) . ')';

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

if ($hasSubmittedUser) {
// 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($sql) or die('Could not run updated data select
query: ' . $sql);
while ($row = mysql_fetch_array($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

What kind of error handling are you doing? You aren't using
Dreamweaver are u?

Jul 16 '05 #3
I refined the code to the following:

$sql = 'INSERT INTO fs_usermetadata (' . substr(trim($cols), 0,
strrpos(trim($cols), ',')) .
') VALUES (' . substr(trim($values), 0, strrpos(trim($values),
',')) . ')';

if (!mysql_query($sql)) {
$hasSubmittedUser = 0;
$errorMsg .= $font . '<font color=cc0000><li>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}<font color=000099>New User: <b>" .
$fs_user_firstname .
' ' . $fs_user_lastname . '</b> added to the
database</font></font><p>';
}

So far everything seems stable.

Phil
"E-Star" <un*******@linuxmail.org> wrote in message
news:210820031419197203%un*******@linuxmail.org...
In article <9z91b.4614$xf.592@lakeread04>, Phil Powell
<so*****@erols.com> wrote:
$sql = 'INSERT INTO fs_usermetadata (' . substr(trim($cols), 0,
strrpos(trim($cols), ',')) .
') VALUES (' . substr(trim($values), 0, strrpos(trim($values),
',')) . ')';

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

if ($hasSubmittedUser) {
// 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($sql) or die('Could not run updated data select
query: ' . $sql);
while ($row = mysql_fetch_array($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

What kind of error handling are you doing? You aren't using
Dreamweaver are u?

Jul 16 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

23 posts views Thread by ian justice | last post: by
2 posts views Thread by Vic Spainhower | last post: by
1 post views Thread by Mr.KisS | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.