[PHP-DB] compiling php with oracle in linux shell

2005-05-16 Thread Anom
hi there i'm having trouble with compiling php in linux shell with oracle support. usually first i install oracle client via xwindow. but now the problem is, the machine currently need to be installed is do not have a xwindow installed. is there anyway to compile php with oracle support

[PHP-DB] addslashes + stripslashes + mysql question

2005-05-16 Thread Petzo
Hi, My question is about the norlmal behaviour of PHP and MYSQL but I cant explain it without a simple example. Thank you for reading: I have the following code: ?php print $t = $_POST['txt']; print $t = addslashes($t);

Re: [PHP-DB] addslashes + stripslashes + mysql question

2005-05-16 Thread Joseph Crawford
you might want to check to see if magic quotes GPC is turned on, if it is then you are adding slashes twice. You can either turn it off or do not use addslashes ;) -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED]

[PHP-DB] php line error

2005-05-16 Thread 'Yemi Obembe
just care to know how php does the line counting when it echoes error messages like: parse error: unexpected '}' on line 129 1. does the line counting includes empty lines 2. are externally included files (using include(), require() etc) also line counted(sic)? 3. are d parts of the file

Re: [PHP-DB] addslashes + stripslashes + mysql question

2005-05-16 Thread Firan Corneliu
You have the string ' \ With addslashes it becomes '\ \\ When you insert it into the database it goes into a query like this update table set field=' '\ \\ ' But that inserts into the field only ' \ , in other words the original string. It is a normal behaviour and you should omit the

Re: [PHP-DB] addslashes + stripslashes + mysql question

2005-05-16 Thread Milen Yordanov
Thank you very much for the reply. That was what I needed to know. That this is the Normal behavior and will not vary in different configurations (exept of the magic_quotes_XXX settings that I'm aware of) Milen - Original Message - From: Firan Corneliu [EMAIL PROTECTED] To: Petzo

RE: [PHP-DB] php line error

2005-05-16 Thread Bastien Koert
It does count blank lines, note that the line with the error maybe well above the line shown in the error...the only indicates where the error (whatever it may be) causes a problem in the script. Bastien From: 'Yemi Obembe [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] php line

Re: [PHP-DB] problems with a script. .

2005-05-16 Thread Martin Norland
John R. Sims, Jr. wrote: Martin; I have taken your advice and read both of the articles, but unfortunately I have not been able to find what needs to be changed. As I mentioned, I am very new at this. Could you possibly look at the script and point me in the right direction? [snip] /head ?php

Re: [PHP-DB] php line error. .

2005-05-16 Thread Martin Norland
'Yemi Obembe wrote: just care to know how php does the line counting when it echoes error messages like: parse error: unexpected '}' on line 129 1. does the line counting includes empty lines yes. 2. are externally included files (using include(), require() etc) also line counted(sic)? no. (but

RE: [PHP-DB] INSER INTO not working!

2005-05-16 Thread Miguel Guirao
Acctually my problem was in that I was using the name of the table in uppercase rather than in lowercase. So MySQL was looking for table REV instead of rev. So for MySQL, REV and rev are very different tables!! Regards, Miguel Guirao -Original Message- From: Constantin Brinzoi

[PHP-DB] Questions with formbuilder: is this the right list?

2005-05-16 Thread Alessandro Pasotti
Hello, I have some questions about DB_DataObject and FormBuilder PK handling, should I post them here or do you know a better list? TIA -- Alessandro Pasotti ICQ# 245871392 Linux User #167502 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] novice on table design

2005-05-16 Thread Jeremiah Fisher
Addresses should definitely have their own table. Have you considered using Postgres? It allows for table inheritance in much the same way that inheritance works in OOP. You could have a parent table (like a parent class) for People, and child tables (just like child classes) for Employee,

[PHP-DB] sql injection attack, protection from

2005-05-16 Thread mayo
I'm new to PHP and would like to make certain that I have the basic protection for the site: Use double quotes to contain variable Use mysql_escape_string so that query is considered part of the WHERE clause. $result=mysql_query('SELECT * FROM users WHERE

[PHP-DB] Showing the next entry

2005-05-16 Thread John R. Sims, Jr.
Hi All, I have developed a script that allows me to select a students name from the client table and display the call information from the case_note table, but the report only shows the first available case_note for an individual. I want this script to display all entries for the specific

[PHP-DB] Emisor de respuesta automática: [PHP-DB] Showing the next entry

2005-05-16 Thread MIGUEL ANTONIO GUIRAO AGUILAR
We need to see your script or at least the portion where you do the query to the database. In general, you need to concatenate your different case-note for a given student as the while cycle goes thru your fetch statement for such a given student. -- MIGUEL GUIRAO

[PHP-DB] Select

2005-05-16 Thread MIGUEL ANTONIO GUIRAO AGUILAR
Hi!! I have this query in PHP: $items2 = mysql_query(SELECT DISTINCT * FROM rev ORDER BY rev, $link); I have three rows with the same data on it, and DISTINCT seems to be not working, since I got all the rows, any ideas of what is going wrong? -- MIGUEL GUIRAO AGUILERA