[PHP-DB] PHP and XML

2002-08-13 Thread Bernard
Hi, I am new to this list and I hope that it is the right place for a question which is plaguing me: I am using successfully the PHP XML-parser. But I have one problem. I like to include html tags into the texts and I don't want them to be interpreted by the parser. But I can't prevent it. It

RE: [PHP-DB] PHP and XML

2002-08-13 Thread Hutchins, Richard
A question better suited for the php-general list, but check out: http://www.php.net/manual/en/function.htmlspecialchars.php and/or http://www.php.net/manual/en/function.htmlentities.php hth, Rich -Original Message- From: Bernard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13,

[PHP-DB] Log Application Help...

2002-08-13 Thread NIPP, SCOTT V (SBCSI)
I have a Log Application that is fully functional, but I need to change a behavior and can't quite figure out how. This app has three pages, one for entering new entries, one to display all entries for the last 5 days, and the final page allows updating of existing entries. The problem

[PHP-DB] Re: problem with php and unixODBC

2002-08-13 Thread Nick Gorham
Marten Lehmann wrote: Hello, my unixODBC-2.2.2 installation works fine. I tested the configuration with a local and a remote ressource to a Sybase Adaptive Server Anywhere database with isql (a testing tool of unixODBC). Thus the settings in the odbc.ini and odbcinst.ini should be

[PHP-DB] Oracle 7.3 Client on Windows NT

2002-08-13 Thread twm
Can the Oracle 7.3 client used on a Windows NT system with Apache? I have tried adding the php_oracle.dll extension, but I get an error when I start Apache. Thanks, Tom -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] user authentication problem

2002-08-13 Thread chip . wiegand
I have this script which is giving me a couple of problems - 1 - I cannot use include ../connect.inc, I get headers already sent error 2 - I can use this script once, but if I try to reload the page to continue testing I get error Unable to execute query. Clearing the browsers cache does not

Re: [PHP-DB] select distinct with all columns

2002-08-13 Thread leo g. divinagracia iii
you maybe using it the wrong way. read the doc: russ arbuthnot wrote: I have a mysql table named equipment with 11 columns named: id, staff_member, class, type, manufacturer, model, description, picture, created, modified, and published. I'm trying to write a select statement similar to

[PHP-DB] oops...Re: [PHP-DB] select distinct with all columns

2002-08-13 Thread leo g. divinagracia iii
oops, i accidentally sent it without finishing... anyway, what i wanted to say was DISTINCT, at least how i learned it, was working with rows instead of colums: http://www.mysql.com/doc/en/DISTINCT_optimisation.html is there a reason why you dont want to list the columns? russ arbuthnot

Re: [PHP-DB] Re: select distinct with all columns

2002-08-13 Thread russ arbuthnot
Perfect! Thanks. I'm still trying to get a handle on the GROUP BY command. It's still a little bit like magic to me. And in the manual, they don't really show how to use it like the way I wanted to use it. Thanks again, russ On Monday 12 August 2002 01:27 pm, Dan Koken wrote: SELECT * FROM

Re: [PHP-DB] odbc connect problem

2002-08-13 Thread salamander
Hi Chip, Looks okay at first brush - I suspect your odbc.ini DSN config. Have you been able to test your DSN outside the PHP environment? e.g with the odbctest app that comes with iODBC? Can you post your odbc.ini / DSN info? Warning: SQL error: [iODBC][Driver Manager]Specified driver could

RE: [PHP-DB] Log Application Help...

2002-08-13 Thread Beau Lebens
Scott, can you just do it by sorting your query, then limiting the results to 10? ie. SELECT * FROM tables WHERE somthing='1' ORDER BY date DESC LIMIT 10 should sort highest - lowest date (ie most recent, backwards) and give you the top 10 results. then if you have the option of flipping thru

[PHP-DB] results of mysql_fetch are returning the incorrect records

2002-08-13 Thread K. Lee
I have problems with mysql_fetch return the wrong records. If I execute the sql statement in mysql, I receive the correct results. When I used mysql_fetch function, it does not return the correct results. Below is my function and the format sql statement function

[PHP-DB] Trying to delete

2002-08-13 Thread César Aracena
Hi all. I have a small problem here. I have this full-PHP site working with a MySQL db and came to a dead road when trying to delete a record from it from the Administrator's page. I have PHP to make this decision after the Administrator selected the record to delete and answered YES to the ¿Are

[PHP-DB] Re: user authentication problem

2002-08-13 Thread David Robley
In article OF0E2E5A7E.4D05B60D-ON88256C14.006923D1- [EMAIL PROTECTED], [EMAIL PROTECTED] says... I have this script which is giving me a couple of problems - 1 - I cannot use include ../connect.inc, I get headers already sent error Look for white space outside the ?php ? tags in connect.inc. A

[PHP-DB] Re: results of mysql_fetch are returning the incorrect records

2002-08-13 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... I have problems with mysql_fetch return the wrong records. If I execute the sql statement in mysql, I receive the correct results. When I used mysql_fetch function, it does not return the correct results. Below is my function and the

[PHP-DB] Re: Trying to delete

2002-08-13 Thread David Robley
In article 01c2433c$e2e3e4c0$e5c405c8@gateway, [EMAIL PROTECTED] says... Hi all. I have a small problem here. I have this full-PHP site working with a MySQL db and came to a dead road when trying to delete a record from it from the Administrator's page. I have PHP to make this decision

[PHP-DB] RE: [PHP] Re: Trying to delete

2002-08-13 Thread César Aracena
Thanks. I must apology as I made a mistake when writing the incoming variable's name. I had it wrong so it would pass the variable but the incoming script was looking for a variable that wasn't passed. In the meantime, and now that I correct that, I'm still comparing artid to '$artid' (with

[PHP-DB] RE: [PHP] Re: Trying to delete

2002-08-13 Thread Brad Bulger
On Wed, 14 Aug 2002, [iso-8859-1] César Aracena wrote: Thanks. I must apology as I made a mistake when writing the incoming variable's name. I had it wrong so it would pass the variable but the incoming script was looking for a variable that wasn't passed. In the meantime, and now that I