Re: [PHP-DB] question about '

2003-07-18 Thread David Robley
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > Hi there, > > The problem is the data is already in the DB, it was mass-added with the ' > already there, what I need is a way to retrieve the ' that is already in the > DB. > > Thanks > > Chris > > > yes, by adding stripslashes it wi

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

[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: "; exit; } if ($result = odbc_Exec($conn, $query)) { print "Query returned : " . odbc_num_rows($result) . " rows"; odbc_result_all($result, "border = 1"

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 tr

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 Edit. 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 the information, you create an

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

[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

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 i

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 dele

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

[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

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 ha

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 deta

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:18 schrieb Wendell Frohwein: > called amount. I use mysql_query("SELECT amount FROM items"); to get the > amounts into the script. > I would then like all the values to be added up for a grand total. I have > tried this and the why dont you use : SELECT SUM(amount) FR

[PHP-DB] PHP MySQL news sys prob again

2003-07-18 Thread phpuser
Thanks for the help before the '".$_GET['id']."'"; certainly fixed all the problems regarding the display of stories and I have ammended my othe files similarly but I am having I think syntax problems with the add and edit parts. I'm sure its just a case of using the GET part again but am havin

[PHP-DB] php mysql arrays and totals

2003-07-18 Thread Wendell Frohwein
I have been searching all over the internet and yet I have not found the answer to my problem. I have a mysql database which stores dollar amounts. The table is called items, the field is called amount. I use mysql_query("SELECT amount FROM items"); to get the amounts into the script. I would then

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 o

[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

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