[PHP-DB] MySQL full text search

2003-07-18 Thread Angelo Zanetti
Hi I have a table which contains 3 fields (ID, Title, Abstract) the title and abstract fields have been fulltext indexes like this: ALTER TABLE biblio ADD FULLTEXT (title,abstract); that worked fine, however my problem is whenever I want to do a select statement only comparing 1 of the

[PHP-DB] in-line function?

2003-07-18 Thread Donny Lee
hi there, can we make simple codes in-line instead of function calls? or, it makes no help in PHP? -- // Donny -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] editing part of a field

2003-07-18 Thread Jason Wong
On Friday 18 July 2003 13:27, JeRRy wrote: But won't update update the what I input. I only need PART of the post to update, only the selected url area and want the remaining of the message to be unchanged. Won't the update change the whole message? I think it does, I only need part of

Re: [PHP-DB] php mysql arrays and totals

2003-07-18 Thread Wendell Frohwein
i didnt even know that function existed, could you maybe give me a little more detail on it, then im sure i can figure it out, thanks allot, -wendell Dirk Kredler [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Am Freitag, 18. Juli 2003 12:18 schrieb Wendell Frohwein: called

Re: [PHP-DB] php mysql arrays and totals

2003-07-18 Thread Dirk Kredler
Am Freitag, 18. Juli 2003 12:33 schrieb Wendell Frohwein: i didnt even know that function existed, could you maybe give me a little more detail on it, then im sure i can figure it out, thanks allot, SUM() is a standard function from (my)SQL. just use it and be happy, if you need in depth

Re: [PHP-DB] MySQL full text search

2003-07-18 Thread Doug Thompson
Full text searches only work against fulltext indexes. http://www.mysql.com/doc/en/Fulltext_Search.html This isn't a PHP issue. Doug On Fri, 18 Jul 2003 09:42:17 +0200, Angelo Zanetti wrote: Hi I have a table which contains 3 fields (ID, Title, Abstract) the title and abstract fields have

[PHP-DB] Print Query

2003-07-18 Thread Norma Ramirez - TECNOSOFT
I´have a complex report from mysql via php whits css, frames etc... Someone know a script to make a printable versión of this? Thank´s Norma Ramirez

[PHP-DB] Inserting a large number of rows into mySQL

2003-07-18 Thread Anthony
I'm writing an app where I must insert a large number of rows into a mySQL database individually. All the rows are related to each other, so I need to ensure that integrity is maintained. In the event that one of the inserts fails, I need to be able to roll back all the prior inserts. What is

Re: [PHP-DB] Inserting a large number of rows into mySQL

2003-07-18 Thread jeffrey_n_Dyke
If you have the standard table type installed As you loop though though the arrays in PHP get ahold of the last ID inserted via mysql_insert_id() and add it to an $inserted_array variable and then at each insert check that the last insert was successful, and if not send your db a bunch of

RE: [PHP-DB] Print Query

2003-07-18 Thread Ryan Marks
You may be able to view this report in Excel and print it from there. If this is an option, do the following in Excel: 1. Data - Import External Data - New Web Query 2. Enter the URL for your report in the Address field and click Go. It is possible to start at one URL and browse to the report if

[PHP-DB] Newbee: Array Field Separator: \035

2003-07-18 Thread Jeff Langley
Hi, I am reading an already created gdbm file with dba_fetch into an array. I am able to print out the array but not the individual elements. The elements are separated with ascii \035. How would I be able to reference each element based on the field separator they have? Also, Once I open the

[PHP-DB] Passing key field, id, from form to procedure

2003-07-18 Thread Hull, Douglas D
I am just starting to learn php and mysql. I have a small php/html page and database. All it does when starting shows the name of each person with a delete and edit link beside each name. At the bottom of the list there is an Add Record button. If you select delete it takes out the name and

RE: [PHP-DB] Passing key field, id, from form to procedure

2003-07-18 Thread Hutchins, Richard
Doug, One way to handle this is the following: On the page that lists the people, under the edit link, you put something like a href=editscript.php?id=$idEdit/a. When the user clicks that link, the $id will be passed in the URL. In your editscript.php page, inside the form where you're editing

RE: [PHP-DB] Passing key field, id, from form to procedure

2003-07-18 Thread Ryan Marks
Douglas, The form that shows the editable fields has a hidden field named 'DID' having the value of $zid. In your updaterecord procedure, you will have to use the variable $_GET[DID] instead of $zid. You can of course just add one line of code: $zid = $_GET[DID]; to help you out. One other

[PHP-DB] Oracle Database Connection Error

2003-07-18 Thread angel
I'm trying to connect to a oracle database using the Microsoft ODBC for Oracle driver with the followin script: ?php $user= user; $upasswd=password; $dsn = dsn; $query = select sysdate from dual; $conn = odbc_pconnect($dsn, $user,$upasswd ); if (!$conn) { print

[PHP-DB] Re: Newbee: Array Field Separator: \035

2003-07-18 Thread Jeff Langley
I figured out the field seperation on my own. Thanks anyway, jeff Jeff Langley wrote: Hi, I am reading an already created gdbm file with dba_fetch into an array. I am able to print out the array but not the individual elements. The elements are separated with ascii \035. How would I