Re: [PHP-DB] MSSQL

User setup depends on how you configured MS SQL. IIRC, MS SQL defaults (during installation) to use Windows user accounts. MS SQL is a lot nicer to work with IMO than MySQL, but I can't justify the $12k+ price tag for a majority of my operations (unlimited Net license). -w -- William Fong

Re: [PHP-DB] produce auto mails by using PHP

http://www.php.net/mail ? - Original Message - From: Georg [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 09, 2002 1:49 PM Subject: [PHP-DB] produce auto mails by using PHP Hi folks, Is there any possibility to send mails directly by using PHP. I need to gather mail

Re: [PHP-DB] 2 mysql connections to same server?

I've never tried this before, but couldn't you use $db1 = mysql_connect(); and $db2 = mysql_connect();? -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] - Original Message - From: Tom

Re: [PHP-DB] Secure PHP to remote Sybase server

login from the Web box (restricted by IP). So even if anyone found out the password, they wouldn't be able to use it. Maybe you could do the same thing? -w -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL

Re: [PHP-DB] accessing system cmds w/ PHP

Just remember you will be running those commands as the web server, which usually have limited access rights. -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] - Original Message

Re: [PHP-DB] accessing system cmds w/ PHP

NOT a good idea. You would have to run Apache as root (or whatever that SUID stuff is all about). I've been able to manage keeping all the users 'virtual' and not needing to hand out shell accounts. -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless

Re: [PHP-DB] I'm really stuck!

://www.php.net/isset ) $data = mysql_query($result,0,bin_data); $type = mysql_query($result,0,filetype); -- is that supposed to be query or result? HTH, -w -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail

Re: [PHP-DB] Sorting the result

. Is that what you wanted? -w -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] - Original Message - From: Kristjan Kanarik [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February

Re: [PHP-DB] variable interpolation in mysql queries

Would it be faster if all you wanted was one variable, or your SQL statement only returned on cell? -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] - Original Message - From

Re: [PHP-DB] PHP and big production database apps ?

We use PHP and MySQL as helper applications (since we've implemented an ERP solution). Basically, we run everything off HTML. It works great because we have both PCs and MACs in house. Having this run through a browser keeps my development time really low. -- William Fong - [EMAIL PROTECTED

Re: [PHP-DB] Displaying data as while recieving form mysql server

old dialup modems, it would show part of the table before it is finished. I believe this is a browser issue. I don't know how the current versions handle this. -w -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail

Re: [PHP-DB] RE: [PHP] Help needed - need to access a value from DB into all pages

Sessions seems to be the popular way to go. It's stored at the server, so you don't have to worry about any clients disabling cookie support. -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED

Re: [PHP-DB] selecting question

' for finished buildings. ??? -w -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] - Original Message - From: ACEAlex [EMAIL PROTECTED] To: Rick Emery [EMAIL PROTECTED]; php-db [EMAIL

Re: [PHP-DB] selecting question

Ok... so tbl.building_info contains all the different types of buildings. Didn't get that... :) So what are the other types for then? They seem to be identical. -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail

Re: [PHP-DB] selecting question

That's what I'm talking about. Make that one table and put a 'status' column. Because then, wouldn't you be concerned on adding an entry to tbl.buildings and removing one from tbl.building_queue. -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless

Re: [PHP-DB] Need smoe code examples on creating tables for mysql in php

to look if you run into problems. I'd also suggest picking up an SQL book. Knowing SQL is very important for writing 'good' PHP / DB apps. -w -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED

Re: [PHP-DB] Passing form values with quotes, to itself

Doesn't PHP have something that will automatically do this? I can't remember, but I think you had to enable it in php.ini or when you compile. (just like to know for future reference). thx. -w -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless

Re: [PHP-DB] A while loop prob ?

== - is to compare two things Not sure why you are hitting the Error. Maybe its my inexperience. HTH -w -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] - Original Message - From: Dave Carrera

Re: [PHP-DB] A while loop prob ?

Heh, with the help from Mr. Emery, I see the/a part of the problem now. You have to fetch the results before you can extract the data into variables. After you do the query, you must run a/the mysql_fetch_array. HTH -w -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax

Re: [PHP-DB] Required pages...

in? If a session has not been started, it shouldn't be displaying anything (or redirect to the login page). Sessions is probably the way to go... HTH -w -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED

Re: [PHP-DB] sybase or SQL Server

You need to enable the MSSQL modules in php.ini or when you compile PHP. -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] - Original Message - From: ip [EMAIL PROTECTED] To: [EMAIL

Re: [PHP-DB] Updating Database problem...

finished. That way if for some reason it didn't work, your visitor doesn't feel Well, you told me it was completed! Why isn't???. Like if the DB server was down or something. -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732

Re: [PHP-DB] Is this possible?

, item_name, price, option, option_cost, quantity_discount) ? -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] - Original Message - From: Hugh Bothwell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent

Re: [PHP-DB] Re: MSSQL Query - Unicode data in a Unicode-only collation or ntext data cannot be sent

if that works. I just wanted to do a quick test to grab data. I see it'll take me a little longer to learn MSSQL. Thanks! william -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED

Re: [PHP-DB] Re: MSSQL Query - Unicode data in a Unicode-only collation or ntext data cannot be sent

. will -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] - Original Message - From: Oliver Cronk [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Php-Db ML [EMAIL PROTECTED] Sent: Thursday