Re: [PHP-DB] changing output method

2005-03-04 Thread anirudh dutt
put echo mysql_num_rows($result); before while ($line = mysql_fetch_array($result)) and add print_r($line) inside the while loop is $line empty? paste _some_ of that output. On Fri, 04 Mar 2005 10:52:59 +0530, chintan [EMAIL PROTECTED] wrote: and as aniruddh's suggestion i was unable to

Re: [PHP-DB] error handling in query execution

2005-03-04 Thread Jochem Maas
Chenri wrote: i have a script that update records with this construct: while( ){ query_string='UPDATE ...'; updateRecord(query_string); } the problem is when there are wrong query_string (such as incorect syntax) can i make sure that the other query, the next one after the

Re: [PHP-DB] email question

2005-03-04 Thread Balwant Singh
sorry for again bothering you, thanks, yes you are right i am using SMTP. i have given my smtp server's ip and port number in my php.ini file but still i could not able to send the emails through my linux m/c. also i am not receiving any error. the mail goes but not reach to destination. after

[PHP-DB] email question

2005-03-04 Thread Balwant Singh
can anybody guide me how i can get subscribed to PHP-DEV forum. excuse me, i am asking one off the list question. i want to use PHP to send email. my webserver has linux OS but we are using POP3 for sending emails (on Windows OS). May pls. inform all the setting needs to be done for sending an

[PHP-DB] sanitizing data

2005-03-04 Thread Mignon Hunter
What method do mosto of you use to sanitize data ? What do you normally check for when, say for example, your getting basic user data like name, address, email. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] sanitizing data

2005-03-04 Thread Bastien Koert
i prefer regex bastien From: Mignon Hunter [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] sanitizing data Date: Fri, 04 Mar 2005 08:34:28 -0600 What method do mosto of you use to sanitize data ? What do you normally check for when, say for example, your getting basic user data like

[PHP-DB] Copying a set of database records

2005-03-04 Thread Steve McGill
A sort of similar question to my last one: I have a table with about 100 records all related to one product. I want to create a new product, based on the details from the old product. So in PHP, I would fetch the 100 records, alter the productID, and then insert it 100 in 100 separate SQL

Re: [PHP-DB] preg_match html tags

2005-03-04 Thread Kathy_A_Wright
Thanks. that worked perfectly. Kathy A Wright | Keane Inc. | Suite: Outside: 617-517-1706 | E-mail: [EMAIL PROTECTED] [ Mailing: 100 City Sq. Charlestown, MA 02129 USA ] Martin Norland [EMAIL PROTECTED] 03/02/2005 03:39 PM Please respond to php-db To: php-db@lists.php.net

Re: [PHP-DB] Copying a set of database records

2005-03-04 Thread Jesper Goos
Hi It can't be done in a single SQL query as SQL can't make recursive requests. You will have to use PL/SQL, and I don't think MySql supports that. Jesper Steve McGill wrote: A sort of similar question to my last one: I have a table with about 100 records all related to one product. I want to

Re: [PHP-DB] Copying a set of database records

2005-03-04 Thread Bastien Koert
You could use sql to copy that info to a separate temporary table, then update the temp table with the new data and then another call to update the main table with the new product info from the the temp table Bastien From: Jesper Goos [EMAIL PROTECTED] To: Steve McGill [EMAIL PROTECTED] CC:

Re: [PHP-DB] Copying a set of database records

2005-03-04 Thread Martin Norland
Jesper Goos wrote: Hi It can't be done in a single SQL query as SQL can't make recursive requests. You will have to use PL/SQL, and I don't think MySql supports that. [snip] bubble burst=true mysql_version_required=4.1 http://dev.mysql.com/doc/mysql/en/subqueries.html /bubble Steve McGill wrote:

[PHP-DB] MYSQL row position.. is it possible (urgent)

2005-03-04 Thread Mike
Let's say I have a database and I want to find the position of a row when it is ordered by a specific column before a sort: UNIQUE ID | SCORE 1 | 100 2 | 50 3 | 30 4 | 80 5 | 50 after sort: UNIQUE ID | SCORE 1 | 100 4 |

[PHP-DB] GD2 library

2005-03-04 Thread Balwant Singh
Sorry I am asking a question which is not directly linked to this forum but i am confident that many of you have the answer for it. i am using PHP 4.2.2 with GD 1.63. now i want to upgrade the GD1.63 to GD2. i have installed the GD2 in my system but still my system is showing GD 1.63. May pls.