Posted by Sheldon Glickler on 03/01/06 13:47

"J.O. Aho" <user@example.net> wrote in message
news:46kjr6Fbl4rbU1@individual.net...
> Sheldon Glickler wrote:
>> "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.
>
> Okey, then lets look at the $_SESSION['Login'], how do you set it and do
> you really store that in a session and reuse it? How do you make the
> mssql_connect()?

Yes, I do store it and it is there. It worked for all the others.

$hostname_Login = "localhost";
$database_Login = "the database name";
$username_Login = "the username";
$password_Login = "the password";
$apbLogin = mssql_pconnect($hostname_Login, $username_Login,
$password_Login) or die(mysql_error());

[Back to original message]