Posted by Sheldon Glickler on 03/01/06 05:05

"J.O. Aho" <user@example.net> wrote in message
news:46kgi5Fbn0u2U1@individual.net...
>> $result = mssql_query($query, $Login);
>> $result = mssql_query($query, $_SESSION['Login']);
>
> Looking at the query function in your two functions gives this main
> difference. As deleteCatalog() hasn't the variable $Login assigned any
> value, it will be the same as Null which isn't a valid resource link
> definer, either you change the function to use the following line

Cut and paste error when writing this orogonal post. Here is the latest and
greatest for the two and the results are still that the delete doesn't work
and the insert does.

$query = "DELETE FROM CatalogNames WHERE sCatalogID='" . $catalog . "'";
mssql_select_db($database_Login, $_SESSION['Login']);
$result = mssql_query($query, $_SESSION['Login']);


$query = "INSERT INTO CatalogNames (sCatalogID, sCatalogName) " .
"VALUES ('" . $cat_id . "', '" . $cat_name . "')";
mssql_select_db($database_Login, $_SESSION['Login']);
$result = mssql_query($query, $_SESSION['Login']);

[Back to original message]