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

2002-01-31 Thread William Fong
ust 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] - Original Message

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

2002-01-31 Thread William Fong
L book. Thanks. 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] PHP + SQL Books

2002-02-04 Thread William Fong
s would be great. Thanks, william -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] sybase or SQL Server

2002-02-06 Thread William Fong
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 P

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

2002-02-06 Thread William Fong
-- Also, I would suggest putting: print("Your changes have been saved to the database"); after the query has ACTUALLY 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 ser

Re: [PHP-DB] Is this possible?

2002-02-06 Thread William Fong
(id, 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]>

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

2002-02-12 Thread William Fong
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 PROT

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

2002-02-13 Thread William Fong
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.687

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

2002-02-13 Thread William Fong
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 Ca

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

2002-02-13 Thread William Fong
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] Disable Right click w/ php?

2002-02-14 Thread William Fong
I could wget these files and stick them in MySQL to organize ( had to make this a legit post in php/db )... vi them and dd out the javascript lines. There is no point in protecting html... -- 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

2002-02-19 Thread William Fong
arting place 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| Wir

Re: [PHP-DB] selecting question

2002-02-20 Thread William Fong
lding in progress, and '2' 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

Re: [PHP-DB] selecting question

2002-02-20 Thread William Fong
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

Re: [PHP-DB] selecting question

2002-02-20 Thread William Fong
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 | F

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

2002-02-21 Thread William Fong
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

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

2002-02-22 Thread William Fong
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 PROT

Re: [PHP-DB] mysql connect, while and close big problem

2002-02-22 Thread William Fong
persistent connections. -- 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: "Killer Angel Clark" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Se

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

2002-02-22 Thread William Fong
show up. Also, on those 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.

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

2002-02-26 Thread William Fong
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] Sorting the result

2002-02-27 Thread William Fong
et it already sorted. 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:

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

2002-02-28 Thread William Fong
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

2002-02-28 Thread William Fong
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.96

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

2002-02-28 Thread William Fong
$id ) ) { <-- use isset (http://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

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

2002-03-06 Thread William Fong
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

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

2002-03-06 Thread William Fong
only 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-ma

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

2002-05-09 Thread William Fong
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 > ga

Re: [PHP-DB] MySQL Query Acting Up

2002-06-21 Thread William Fong
ery: print( "$query\n" ); Then if it still looks right, try manually typing it in a CLI interface. -w -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 714.315.8954| Wireless E-mail: - Original Message - From: "Mart

Re: [PHP-DB] MSSQL

2002-06-24 Thread William Fong
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