Mysql array retrieval problem

antoine

Currently I am trying to create a form which
(1)checks whether a key field ID has been entered
(2) If it is, then retrieves the record for edit mode
(3) if not uses the form for insert mode.

My problem is that if there are null values in fields, then when I do:

$row = mysql_fetch_array($result);

Then the resulting associative array does not contain the index of the field with NULL value so that I get the error:
Warning: Undefined index: app_file_css in c:\indigoperl\htdocs\admin_app_update.php on line 72

How do I resolve this problem. Can I:
(1)is there a PERL like eval statement so I could capture the error and deal with it?
(2)is there a way of forcing the NULL row still to have an associative array element for it?

Any ideas very welcome.

P.S: code attached

John_Canyon

I use something similar to the following.

if(!empty($importantvalue))
{
execute the sql statement.
}
else
{
display error
}

Actually though I use javascript now to check the values of the field elements before the page is submitted. I still use these checks however.

This was a quick example.. there are better way.. but this should get you headed in the right direction.

Cheers,

John

tomhath

you can check to see if the array entry is ther ewith the isset() function:

http://www.phpbuilder.com/manual/function.isset.php

gandalfvtx

function get_data($user_id, $db) {
$sql = "SELECT * FROM phpbb_users WHERE user_id = '$user_id'";
if(!$result = mysql_query($sql, $db)) {
die('Could not get user info'); }
$myrow = mysql_fetch_array($result);
return($myrow); }

/ Get the user level /
$sql = "SELECT user_id FROM phpbb_users WHERE username = '$username' AND user_password = '$password'";
if(!$result = mysql_query($sql)) {
die('There was a problem with the server.'); }
if(mysql_num_rows($result) == 0) {
die('The password does does not match the username.'); }
$info = mysql_fetch_array($result);
$info = $info[user_id];
$userdata = get_data($info, $db);

Work that out. It is a simple way to get a certain row and item out.