[PHP-DB] Problem with passing variable to mssql

I have issues I cant understand passing a sql statement to mssql, most of which work fine, however in some cases, a statement like SELECT * FROM tblX where value like 'variable%' will return 0 records when I know they are there. No errors, just 0 records. When I echo the sql string to the

[PHP-DB] App. design help

Hello, I need to write a php/mysql application for managing a website for a sportsclub. At his point I need some designin tips how to implement the user and team administration. At the moment the club consists of about 30 teams. There are usually 1-2 web admins per team to update the pages.

Re: [PHP-DB] Global Peace output

Hi! Do the addresses begin with http:// If not, I think the exact protocol must be specified in order to work!..good luck! - Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage!

[PHP-DB] Request database_queryf() functions.

'); ? Output: Query is: SELECT * FROM blah WHERE id=1 AND name='name\'s...' AND account='0.00' AND blah=00 AND value '30%' - -- Regards, William Bailey. Pro-Net Internet Services Ltd. http://www.pro-net.co.uk/ -BEGIN PGP SIGNATURE- Version: GnuPG

Re: [PHP-DB] Request database_queryf() functions.

If you need a better source example/layout goto: http://nopaste.php-q.net/59720 William Bailey wrote: Hi All, After having been talking to lots of people in irc lately who are haveing problems with SQL injection etc i think that haveing a *_queryf() function would be really useful to help

[PHP-DB] Oracle and upper case field name

with lower case field names even the result set is upper case? William CheungB.Sc, MCSE, MCDBA Databyte Corp. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.567 / Virus Database: 358 - Release Date: 1/24/2004

RE: [PHP-DB] PHP 4.3.4, ADODB and Oracle9.2

Thanks, I found out that the TNS name in ADODB is wrong. After I fixed it, the error gone. William Cheung B.Sc, MCSE, MCDBA Databyte Corp. -Original Message- From: Christopher Jones [mailto:[EMAIL PROTECTED] Sent: January 19, 2004 12:14 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED

[PHP-DB] PHP 4.3.4 ADODB Oracle 9.2

. William CheungB.Sc, MCSE, MCDBA Databyte Corp. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.560 / Virus Database: 352 - Release Date: 1/08/2004

[PHP-DB] Re: PHP4.2.3 and Oracle 9.2

the command line and both works fine. I have used php.exe and php4isapi.dll in the web server and both return the same error. William Cheung B.Sc, MCSE, MCDBA Databyte Corp. -Original Message- From: Justin Patrin [mailto:[EMAIL PROTECTED] Sent: January 15, 2004 11:53 AM To: [EMAIL PROTECTED

RE: [PHP-DB] Re: PHP4.2.3 and Oracle 9.2

I finally found out it is related to the permission of Oracle folder. After making Everyone to have full control to the folder, the ODBC connection works. William Cheung B.Sc, MCSE, MCDBA Databyte Corp. -Original Message- From: Justin Patrin [mailto:[EMAIL PROTECTED] Sent: January 15

[PHP-DB] PHP 4.3.4, ADODB and Oracle9.2

.inc.php on line 128 Fatal error: Call to a member function on a non-object in C:\inetpub\wwwroot\PHP\flximage0.php on line 36 Any idea if adodb-oci8.inc.php will work on Oracle 9.2 database? William CheungB.Sc, MCSE, MCDBA Databyte Corp. --- Outgoing mail is certified Virus Free

[PHP-DB] PHP4.2.3 and Oracle 9.2

resource in c:\inetpub\wwwroot\PHP\testora.php on line 14 William CheungB.Sc, MCSE, MCDBA Databyte Corp. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.560 / Virus Database: 352 - Release Date: 1/08/2004

[PHP-DB] Re: MySQL Returns Error

Jeff, First, let me apologize if I'm reiterating something already said, but I'm new to the newsgroup. What does mysql say the problem was? That is, if you put echo mysql_error(); immediately after the query, what does it say? Is it possible you have one of the fields set to be unique in

[PHP-DB] MySQL password protection?

Hi all I was wondering if it is possible to protect my password to the MySQL-server from being in a PHP-script. Now I can't do that, so everybody who gets to see my php-sourcecode also can see my (not protected/not encrypted) password. How can I change this? Thanks, William --- William

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

[PHP-DB] mssql_fetch_row() failed to get data with float data type ??

I use PHP 4.0.6 on linux (Red Hat 7.0) to access MS SQL Server 7.0. I can connect to database and get the correct data with char or int data type, but it showed '0' if data type is float or real. Did any one know why it happened ? Thanks in advance. William Hung -- PHP Database Mailing

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

[PHP-DB] LOAD DATA LOCAL ERROR

Every time I use the command LOAD DATA LOCAL INFILE C:WINDOWS:Desktop:db.txt INTO TABLE booktest; I get this error message... ERROR: File 'C:WINDOWS:Desktop:db.txt' not found (Errcode: 2) How can I load my file to the database??? --Will

Re: [PHP-DB] How to select [please HELP]

Hi David, Perhaps you can modify your second query to the following way. SELECT recordid,uid,info FROM userstuff WHERE uid LIKE '$uid' AND recordid NOT LIKE '$recordid' -- Regards, William Lai -Original Message- From:David Tandberg-Johansen [EMAIL PROTECTED] Sent:Wed, 25 Apr

[PHP-DB] Re: All mysql.sock error help requests

I just made a php module with mysql support and had the couldn't connect to /var/lib/mysql/mysql.sock problem. Not looking at the basics as the RedHat 7 did the mysql install I figured it was more in mysql or php config. I checked out the archive for this list and found a fair number of people

[PHP-DB] MySQL strangeness with joins and keys.

this is happening and how i can get a constant, and hopefully quick, speed across a number of different searches? If its any help im currently running MySQL 3.23.31 for freeBSD 4.2 Thanks, William. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED