Hi,

I have 2 problems with php stuff:

1. When I use odbc_connect connect to SQL Server, I used the following statement to execute sql query:
$result=odbc_exec($con,$sqlstr);

Then if I need to execute another query, I found that I have to unset($result). It seems one connection only allows one recordset present. Why is it?

2. I tried to send out emails to myself in my php web application. Seems I never got these emails, and there is no error shows in web page. Is that due to some server configuration issue?

I appreciate any suggestion.

Cindy

Hi Cindy,

I'm guessing no one is responding to your odbc question because no one uses it or has has had much experience with it -- or at least no one on this list = ). From a purely PHP standpoint it doesn't make sense that you would have to unset a variable before being able to reuse it. Which is what I am assuming is going on. When you try to reuse the variable it should simply be overwritten. Without seeing more code I wouldn't have the foggiest.

As far as your mail concerns, how are you sending mail? Is this Windows-based or Unix. If its Windows make sure that the SMTP server is set up correctly in php.ini - or at runtime with ini_set() whichever the case may be. If you know the server to be configured correctly then it may be something in the code that you're using. Feel free to post examples which will allow us to rule out one or the other.

http://us3.php.net/mail

: )
Rich

:::::::::::::::::::::::::::::::::
Smiling Souls
http://www.smilingsouls.net
:::::::::::::::::::::::::::::::::