[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 pag

[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. Th

[PHP-DB] Re: [EMAIL PROTECTED] php crashes with msyql

Noah Silverman wrote: Hello, I have a mission critical problem that I cant seem to solve. Can anyone help?? I'll even offer $100 paypal if someone gives me the answer to solve this issue. You don't enable zts so I seriously doubt your php is threadsafe; you configure httpd without speci

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!

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] Request database_queryf() functions.

d=%d AND name=\'%\'.-34s\' AND account=\'%0.2f\' AND blah=%06d AND value > \'30%%\'', NULL, '1 OR', 'name\'s'); ?> Output: Query is: SELECT * FROM blah WHERE id=1 AND name='name\'s...&

[PHP-DB] Oracle and upper case field name

lower case field names even the result set is upper case?   William Cheung B.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

[PHP-DB] PHP 4.3.4 ADODB Oracle 9.2

.   William Cheung B.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

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 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 Cheung B.Sc, MCSE, MCDBA Databyte Corp.    --- Outgoing mail is certified

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:

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

d also 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

[PHP-DB] PHP4.2.3 and Oracle 9.2

ose(): Supplied argument is not a valid ODBC-Link resource in c:\inetpub\wwwroot\PHP\testora.php on line 14   William Cheung B.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 Datab

[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 your

[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 --- Wi

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

Re: [PHP-DB] MySQL Query Acting Up

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] 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 > ga

[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 Databa

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

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] 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

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

$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] 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.96

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] Sorting the result

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] 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] Displaying data as while recieving form mysql server

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] mysql connect, while and close big problem

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] 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 PROT

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

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 | F

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

Re: [PHP-DB] selecting question

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] Need smoe code examples on creating tables for mysql in php

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] Disable Right click w/ php?

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] 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] A while loop prob ?

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] 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.687

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

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] Is this possible?

(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] Updating Database problem...

-- 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] 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 P

[PHP-DB] PHP + SQL Books

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] Re: MSSQL Query - Unicode data in a Unicode-only collation or ntext data cannot be sent

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]>;

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

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

[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]

[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 wit

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

here from 0.5 - 6 seconds. Anybody have any idea why 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:/

[PHP-DB] Storeing images in a database table, should it be done?

mpact will it have. I'm just thinking that it will be easier to manage an admin system if everything is in a database and will therefore not have to worry about file permissions etc. Thanks, William. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL