[PHP-DB] i am lost (php warning)

Hi ya'll, I am lost as to why I am getting this error in my script. Can anyone kindly explain why this is so. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/cm/public_html/cell/login.php

Re: [PHP-DB] '

When I submit my forms, if any textfield contains a ' the result comes back with /' Is there anyway of stopping this? Yes, either: - turn off Magic Quotes GPC or - use stripslashes() Larry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] '

echo stripslashes($text); bastien From: "Ben" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> To: Subject: [PHP-DB] ' Date: Mon, 17 Jan 2005 16:24:47 - Hi all, When I submit my forms, if any textfield contains a ' the result comes back with /' Is there anyway of stopping this? Thanks Ben --

[PHP-DB] Re: last insert ID

you can use the mysql function LAST_INSERT_ID() heres the info from the manual: http://dev.mysql.com/doc/mysql/en/ODBC_and_last_insert_id.html I was having trouble with retrieving the last insert id as well. Even after looking over the information in the link, I couldn't figure out how to make t

[PHP-DB] '

Hi all, When I submit my forms, if any textfield contains a ' the result comes back with /' Is there anyway of stopping this? Thanks Ben -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Import into mysql from csv-file

Hi, how do I import data stored in a csv-file (formated text) into a mysql_database. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP 5.0.3 and Oracle9i on Windows 2000/Apache

Chaun Keating wrote: I am having trouble logging onto Oracle via PHP on a Windows 2000 machine. I keep getting the error: Fatal error: Call to undefined function OCILogon() in C:\Program Files\Apache Group\Apache2\htdocs\oraconnect.php on line 15 I seem to have everything set up correctly. I am ru

Re: [PHP-DB] insert into mysql-db from csv-file

Ruprecht Helms wrote: I want to read a csv-file and import the datas into a mysql-db. How do I make this. A little scriptexaple in php would be helpfull. Why not just LOAD DATA INFILE from MySQL? No need to involve PHP at all, really... -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/regis

Re: [PHP-DB] RE: php-db Digest 16 Jan 2005 13:41:28 -0000 Issue 2777

Ben wrote: All, I am needing to send two attachments from my form. Both fields are called 'fileatt' and 'fileatt1'. Below is the script i wrote to attach 'fileatt' but i am unsure on how to attach 'fileatt1'. Can I just add fileatt1 or do I need to rethink how I do it? Ooo, I would try this: http:

RE: [PHP-DB] insert into mysql-db from csv-file

rtfm http://ca3.php.net/manual/en/function.fgetcsv.php bastien From: Ruprecht Helms <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] insert into mysql-db from csv-file Date: Mon, 17 Jan 2005 17:26:56 +0100 Hi, I want to read a csv-file and import the datas into a mysql-db. How do I ma

[PHP-DB] PHP 5.0.3 and Oracle9i on Windows 2000/Apache

I am having trouble logging onto Oracle via PHP on a Windows 2000 machine. I keep getting the error: Fatal error: Call to undefined function OCILogon() in C:\Program Files\Apache Group\Apache2\htdocs\oraconnect.php on line 15 I seem to have everything set up correctly. I am running an Oracle 9i

Re: SV: [PHP-DB] Assistance with if..elseif statement

Thanks all - CH On Jan 17, 2005, at 8:35 AM, Henrik Hornemann wrote: Hi, } elseif ($_POST['route_photo'] = $_POST['oldimage']) Should probably be } elseif ($_POST['route_photo'] == $_POST['oldimage']) Regards Henrik Hornemann -Oprindelig meddelelse- Fra: Craig Hoffman [mailto:[EMAIL PROT

[PHP-DB] insert into mysql-db from csv-file

Hi, I want to read a csv-file and import the datas into a mysql-db. How do I make this. A little scriptexaple in php would be helpfull. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Adding Up MySQL Results

I guess this is what you mean: sum(quantity)*priceprice 450.00 15.00 479.99 29.99 ... ... is that right? JeRRy wrote: I run this mysql query: "select sum(quantity)*price,price from sale where dvd_id=1 group by price"; I get this result:

SV: [PHP-DB] Assistance with if..elseif statement

Hi, } elseif ($_POST['route_photo'] = $_POST['oldimage']) Should probably be } elseif ($_POST['route_photo'] == $_POST['oldimage']) Regards Henrik Hornemann -Oprindelig meddelelse- Fra: Craig Hoffman [mailto:[EMAIL PROTECTED] Sendt: 17. januar 2005 15:22 Til: php-db@lists.php.net

RE: [PHP-DB] RE: php-db Digest 16 Jan 2005 13:41:28 -0000 Issue 2777

All, I am needing to send two attachments from my form. Both fields are called 'fileatt' and 'fileatt1'. Below is the script i wrote to attach 'fileatt' but i am unsure on how to attach 'fileatt1'. Can I just add fileatt1 or do I need to rethink how I do it? Many thanks // Obtain file upload

[PHP-DB] RE: php-db Digest 16 Jan 2005 13:41:28 -0000 Issue 2777

From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: php-db Digest 16 Jan 2005 13:41:28 - Issue 2777 Date: 16 Jan 2005 13:41:28 - php-db Digest 16 Jan 2005 13:41:28 - Issue 2777 Topics (messages 38151 through 38154): Re: Integrating Interbase.so and PHP 38151 by: Doug Thom

[PHP-DB] Assistance with if..elseif statement

I have this block of code which checks to see if an image has been uploaded from an update form. Everything in the form works, except I can not get the the elseif statements to behave properly. See the comments below for explanation. Any help would be appreciated. $route_photo = $_FILES['ima

[PHP-DB] RE: Assistance on Query

Hi People, I would like some assistance on the following scenario. I have to pull out all records for a particular userid (easy enough) and then only show those entries where the follwing occurs. These records from the table will contain either an entry in the services_type field or the non_service

Re: [PHP-DB] Input ++90 causing problems

Switching off Auto-select in the Encoding in IE did solve it. Thanks a lot. John - Original Message - From: "graeme" <[EMAIL PROTECTED]> To: "ioannes" <[EMAIL PROTECTED]> Cc: Sent: Friday, January 14, 2005 8:17 AM Subject: Re: [PHP-DB] Input ++90 causing problems It appears as plus sign

RE: [PHP-DB] Security Question

Hi The page/form will be requested over a non secure connection. When the form is submitted the browser establishes a secure connection to the server and then sends the data, so the data is sent securely. Peter > -Original Message- > From: Micah Stevens [mailto:[EMAIL PROTECTED] > S