Re: [PHP-DB] Help please, back to an error

2004-09-15 Thread Stuart Felenstein
Micah, Your right! I regretted this post after I hit send. The code generator is actually okay. I'm learning more about PHP, and what the code actually means, in the event it needs to be modded / edited. Sorry again for the post and thanks for the reply! Stuart --- Micah Stevens [EMAIL

Re: [PHP-DB] Help please, back to an error

2004-09-14 Thread Micah Stevens
I'm thinking you should either get a better code generator, or learn more about php.. :) -Micah On Monday 13 September 2004 02:49 pm, Stuart Felenstein wrote: Thanks to help here I was able to overcome some ivalid query errors. Now I'm back, (probably the same mistake) It's coming off

[PHP-DB] Help please, back to an error

2004-09-13 Thread Stuart Felenstein
Thanks to help here I was able to overcome some ivalid query errors. Now I'm back, (probably the same mistake) It's coming off of this line: $sql .= And PostStart = DATE_SUB(CurDate(), Interval ['search_fd1'] day ); The 'search_fd1' is one of the form fields where a list of

[PHP-DB] Help please

2004-03-05 Thread Benjamin Jeeves
hi all, I my querying two tables in mysql the first table I query returns a list of software that I have. Then I query a second table that show me what is installed on a computer. I would then like to be able to display the first list but with a tick next to software installed on a

Re: [PHP-DB] Help please

2004-03-05 Thread mustafa ocak
, March 05, 2004 1:07 PM Subject: [PHP-DB] Help please hi all, I my querying two tables in mysql the first table I query returns a list of software that I have. Then I query a second table that show me what is installed on a computer. I would then like to be able to display the first list

RE: [PHP-DB] Help Please!! Oracle/PHP connection

2003-06-11 Thread Ford, Mike [LSS]
-Original Message- From: Matthew Moldvan [mailto:[EMAIL PROTECTED] Sent: 11 June 2003 01:03 Have you tried the built in Oracle functions in PHP? http://us3.php.net/oracle That's only for Oracle up to version 7. For Oracle 8 or 9, use the OCI extension http://www.php.net/oci8.

[PHP-DB] Help Please!! Oracle/PHP connection

2003-06-10 Thread Y Al Hinai
Hey guys, I would really appriciate it if someone can direct me with this problem. On my laptop I have: Windows XP Professional, Oracle 9i Database, Oracle Client Software, PHP4.3.1, and Apache server. PHP and Apache work fine. Oracle i9 by itslef works fine too. However when i tried to

RE: [PHP-DB] Help Please!! Oracle/PHP connection

2003-06-10 Thread Matthew Moldvan
PROTECTED] Subject: [PHP-DB] Help Please!! Oracle/PHP connection Hey guys, I would really appriciate it if someone can direct me with this problem. On my laptop I have: Windows XP Professional, Oracle 9i Database, Oracle Client Software, PHP4.3.1, and Apache server. PHP and Apache work fine

[PHP-DB] help, please

2003-03-31 Thread Marcial Comerón Mariño
Hi all I'm new with php. I need connect with my db in oracle7.3.3, and doing it: ?php putenv(ORACLE_SID=my_sid); putenv(ORACLE_HOME=my_path_home); $handle = ora_plogon(user, ssword)or die; $cursor = ora_open($handle); ora_commitoff($handle); $query = insert into my_tab values ( )...;

Re: [PHP-DB] help, please

2003-03-31 Thread Hendri
Subject: [PHP-DB] help, please Hi all I'm new with php. I need connect with my db in oracle7.3.3, and doing it: ?php putenv(ORACLE_SID=my_sid); putenv(ORACLE_HOME=my_path_home); $handle = ora_plogon(user, ssword)or die; $cursor = ora_open($handle); ora_commitoff($handle); $query = insert

Re: [PHP-DB] Help please

2002-12-10 Thread DL Neil
SpiderWebb, One posting to one list is enough... I dont know if this is possible in PHP (Newbie) im working on a project where each product has 3 diffierent prices depending on the amount sold so say for example 1- 100 price A 101-299 price B and above 300 Price C. What I need to be able to

Re: [PHP-DB] HELP PLEASE!! Get query error when inserting into MySql

2001-10-29 Thread biorn
If any of the values you are trying to insert are not integers, you need to put single quotes around the variables, ie. $SCRIPT_NAME, $date, $BName, etc in the insert statement. Robby Whiteside [EMAIL PROTECTED] said: Hi There, I have a query whenever I try to insert something into a

RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into MySql

2001-10-29 Thread Ricky Theil
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 9:24 AM To: Robby Whiteside; [EMAIL PROTECTED] Subject: Re: [PHP-DB] HELP PLEASE!! Get query error when inserting into MySql If any of the values you are trying to insert are not integers, you need to put

RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into My Sql

2001-10-29 Thread Rick Emery
]'; Robby Whiteside; [EMAIL PROTECTED] Subject: RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into My Sql If your first field is an auto insert field, then you have to do it like this: insert into tablename (column2,column3,column4,column5) values (value2,value3,value4,value5) The auto

RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into My Sql

2001-10-29 Thread Ricky Theil
, October 29, 2001 10:46 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into My Sql This also works: INSERT INTO vcstats VALUES( NULL,column2,column3,column4,column5) The NULL value will be replaced with theauto-incremented value in the table

RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into My Sql

2001-10-29 Thread Rick Emery
: [PHP-DB] HELP PLEASE!! Get query error when inserting into My Sql I was never able to assign a null value to get a row to automatically insert into SQL server 7. It would always give me an error that said something like you cannot assign the value NULL to an identity field. -Original

[PHP-DB] Help Please! Complex AND OR LIKE queries MySQL/PHP

2001-09-18 Thread Dave Watkinson
Hi everyone I need to write a small search script for our admin site (and eventually for the outsiders too!). There's a text box where the user types in what they're searching for. It's easy enough to parse their string into an array and create the query from it, for example user typed in

RE: [PHP-DB] Help Please! Complex AND OR LIKE queries MySQL/PHP

2001-09-18 Thread Rick Emery
. $sql_text; This will save a few milli-seconds because PHP will not have to execute the substr($sql_text, 0, strlen($sql_text)-4) functionality. -Original Message- From: Dave Watkinson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 5:26 AM To: PHP-DB List (E-mail) Subject: [PHP-DB

RE: [PHP-DB] Help Please! Complex AND OR LIKE queries MySQL/PHP

2001-09-18 Thread Dave Watkinson
Cheers Rick ... I think I nailed it. I've copied my little function below for anyone else interested. Am keen on the saving milliseconds bit, though (will add it to the function below before making it live). Any more tips? Dave function parse($what) { $what =

[PHP-DB] help please... session - database

2001-08-23 Thread brendan
hello, i have hit a major stumbling block and am now getting really frustrated.. if someone could point me in the right direction i would really appreciate it.. - i have a set of forms across a number of pages - the user enters data into each of the forms and these are placed in a session

Re: [PHP-DB] help please... session - database

2001-08-23 Thread Andre P.
Try $link = addslashed($HTTP_SESSION_VARS[HREF]) and then use $link in the sql insert and.. stripslashes(query result) when you retrieve the value and need to display it on the page. hth andre brendan wrote: hello, i have hit a major stumbling block and am now getting really frustrated..

[PHP-DB] HELP PLEASE: PHP - Sybase

2001-08-01 Thread Veniamin Goldin
Hello, I have got a problem, When i try to connect to Sybase from PHP script, I have an error that I am calling undefined function sybase_connect. Does it meen that I have to load some extra module to get this function to work? Or what should I do to resolve this problem ? Thank you. --

RE: [PHP-DB] Help please

2001-04-10 Thread richarda
BDY.RTF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Help please

2001-04-09 Thread Indri
To: [EMAIL PROTECTED] Subject: [PHP-DB] Help please Hi all, I have a website that I am trying to develop a "add news" page for. Basically people who have the authority to add news for the site can type in their username, password, the title of the article, and the article itself