[PHP-DB] multiple queries in PHP ????

2003-03-24 Thread JeRRy
Hi, I have a query to update a database via PHP after a form is inputed. The form results do a match to the database and if a match occours updates a field with +1 and if no matches it does nothing. Now I want it so if +1 is done I want another table to update as +1 also. How would I achieve

Re: [PHP-DB] Setting up arrays from queries

2003-03-24 Thread Jason Wong
On Monday 24 March 2003 12:09, [EMAIL PROTECTED] wrote: When I execute this function: function getTitles() { $this - openConnection(); $title_query = select name from categories; $title_result = mysql_query($title_query); echo here is title_result: .mysql_affected_rows(); $i = 0;

[PHP-DB] MySQL or Postgres

2003-03-24 Thread Ben Edwards
Could someone please point me in the correct direction for a decent comparison of the two in respect of:- Reliability Scalability Speed Functionality These are actually in order or importance to me (I know both are fairly fast). I am also interested in how easy it would be to migrate

RE: [PHP-DB] MySQL or Postgres

2003-03-24 Thread Snijders, Mark
hi, Ih ate people being so lazy.. open google and type the words: mysql postgres and you get enough results, here i looked one up for you: http://www.mmlabx.ua.es/mysql-postgres.html http://www.mmlabx.ua.es/mysql-postgres.html ___ Mark Snijders, Developer

RE: [PHP-DB] MySQL or Postgres

2003-03-24 Thread Snijders, Mark
sorry the url I gave was of a weird language.. this one is better: http://www.phpbuilder.com/columns/tim2705.php3 -Original Message- From: Ben Edwards [mailto:[EMAIL PROTECTED] Sent: maandag 24 maart 2003 12:03 To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL or Postgres Could

RE: [PHP-DB] MySQL or Postgres

2003-03-24 Thread Ben Edwards
Where MySQL loses points in the daemon robustness department, it makes up for it by apparently never corrupting its data files. The last thing you want is your precious data files fouled randomly, and MySQL does well here. In over a year of running MySQL, I haven't ever seen a single case of

[PHP-DB] Why NOT you ?

2003-03-24 Thread Khim
Dear Online Business Opportunity Seekers Why CCI ? CCI, Core Club International is a 3 year old, Federally registered non-profit humanitarian aid, corporation. Federal EIN # 93-1324671 State Reg. # 036394-99 Established April 17, 2000 CCI was set up to help eradicate poverty in the world

[PHP-DB] [php] file open

2003-03-24 Thread Snijders, Mark
hello, i'm using the next code: $fp=fopen(WBSMUTA.CSV,r); while (!(feof($fp))) { $data_file=fgets($fp,4096); echo br$data_filebr; } to open a file... but I want to read it from line 3.. and there is a special function for, but can't find it back :( can someone tell me the

Re: [PHP-DB] [php] file open

2003-03-24 Thread 2b4ever php
hello, i'm using the next code: $fp=fopen(WBSMUTA.CSV,r); while (!(feof($fp))) { $data_file=fgets($fp,4096); echo br$data_filebr; } to open a file... but I want to read it from line 3.. and there is a special function for, but can't find it back :( can someone tell me the name

RE: [PHP-DB] [php] file open

2003-03-24 Thread Christian Rosentreter
-Original Message- From: Snijders, Mark [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 1:30 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] [php] file open i'm using the next code: $fp=fopen(WBSMUTA.CSV,r); while (!(feof($fp))) { $data_file=fgets($fp,4096);

RE: [PHP-DB] mysql timestamps

2003-03-24 Thread John W. Holmes
Sorry, the function is UNIX_TIMESTAMP(date). That will create a unix timestamp from your date column. Use FROM_UNIXTIME() to create a MySQL timestamp from a unix one. I'd recommend, though, that you just look up DATE_FORMAT() in the MySQL manual and just use that.

[PHP-DB] Help with a query please

2003-03-24 Thread shaun
Hi, I have the following table structure, as my installation of MySQL doesnt support Foreign keys i have to maintain the referential integrity myself. So if i delete a user, how can i make sure that the allocations from the allocations table where the user_id is the same as the one being deleted

Re: [PHP-DB] combination of fetch_field and fetch_row

2003-03-24 Thread Mark
It appears you didn't get an answer on list. You can try using mysql_fetch_array() instead of mysql_fetch_row(). Then you'll get an associative array, with the field names as the keys. So you can do something like this: $result0 = mysql_query(SELECT

Re: [PHP-DB] Help with a query please

2003-03-24 Thread heilo
Hi! I hope, I understood you right: You want to delete a user completely from your database? If yes, you can just do it step by step (I hope the last step - putting all the queries together works): $uid = 1; $qry = 'SELECT `Allocation_ID` FROM `WMS_Allocations` WHERE `User_ID`='.$uid; $ent =

[PHP-DB] mssql_query ROLLBACK

2003-03-24 Thread Prev=EDt?= (j)
I have an opened connection to MS SQL Server 7 and I try to do this: $commit = FALSE; // SELECT TRANCOUNT returns 0 here = OK if(mssql_query(BEGIN TRANSACTION)) { // SELECT TRANCOUNT returns 1 here = OK if(mssql_query(INSERT INTO TABLE (DATE) VALUES ('$date'))) { // ...

[PHP-DB] mssql_query ROLLBACK

2003-03-24 Thread Prev=EDt?= (j)
I have an opened connection to MS SQL Server 7 and I try to do this: $commit = FALSE; // SELECT @@TRANCOUNT returns 0 here = OK if(mssql_query(BEGIN TRANSACTION)) { // SELECT @@TRANCOUNT returns 1 here = OK if(mssql_query(INSERT INTO TABLE (DATE) VALUES ('$date'))) { // ...

RE: [PHP-DB] MySQL or Postgres

2003-03-24 Thread May, Patrick
Ben, Subject: [PHP-DB] MySQL or Postgres Could someone please point me in the correct direction for a decent comparison of the two in respect of:- Reliability Scalability Speed Functionality These are actually in order or importance to me (I know both are fairly

Re: [PHP-DB] MySQL or Postgres

2003-03-24 Thread Lester Caine
There are other open-source databases besides MySQL and Postgres. My experience has pointed me towards firebird / interbase: http://firebird.sourceforge.net/ Same here - 24/7 operation and Windows or Linux servers -- Lester Caine - L.S.Caine Electronic Services --

[PHP-DB] php, oracle, OCIExecute()

2003-03-24 Thread Marcin Wylot
Welcome I need Yours help about this project: I have installed on Sun Solaris (2.6) Oracle Database (8.0.5), and apache on the other linux server with PHP and Oracle Client for 9i. I making a connection to database from Linux to Sun and all is O.K. For example:

[PHP-DB] ODBC cursor join

2003-03-24 Thread Chris Berlioz
Does anyone know how to join cursors after having successfull query ie: I have multiple queries that get data from different sources and now I need to join the results, how can I achieve this in PHP (Do I need to write into a temporary table and then requery? is that the only way? I am using

[PHP-DB] Join Cursors

2003-03-24 Thread Chris Berlioz
Does anyone know how to join cursors after having successfull query ie: I have multiple queries that get data from different sources and now I need to join the results, how can I achieve this in PHP (Do I need to write into a temporary table and then requery? is that the only way? I am using

Re: [PHP-DB] mail() function

2003-03-24 Thread Rick Dahl
Is the the type of thing I would need? http://www.postcastserver.com/ I found where I am supposed to alter the PHP.ini file. What am I supposed to type instead of 'localhost' Rick Don't burn the day...away ~ DJM From: Jason Wong [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL

Re: [PHP-DB] mail() function

2003-03-24 Thread Jason Wong
On Tuesday 25 March 2003 04:39, Rick Dahl wrote: Is the the type of thing I would need? http://www.postcastserver.com/ I found where I am supposed to alter the PHP.ini file. What am I supposed to type instead of 'localhost' If you're running an SMTP server on the same machine (as your

Re: [PHP-DB] mssql_query ROLLBACK

2003-03-24 Thread Frank M. Kromann
Hi, You can't split a transaction between multiple calls to mssql_query. The memory used (in the server and client) are cleared between each call. You would have to create a batch of statements and execute these with one call to mssql_query. - Frank I have an opened connection to MS SQL

[PHP-DB] help me..!

2003-03-24 Thread muhammad_wahyu
dear all, I'm a new user for PHP programing,I'm confused with syntax in those script.So I want all of you can help me.friend i need 1.Example of PHP (guest book,e-commerce,db with PHP,etc) Thank's all akhi wahyu -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: php, oracle, OCIExecute()

2003-03-24 Thread Michael Mauch
Marcin Wylot [EMAIL PROTECTED] wrote: Warning: OCIStmtExecute: Error while trying to retrieve text for error ORA-03120 in /var/www/html/oracle/index.php on line 62 This means that the Oracle libraries don't know where they can find the error messages - if they could find the error messages,

Re: [PHP-DB] help me..!

2003-03-24 Thread ps_jkt
there are a million sample php script in links... http://www.php.net muhammad_wahyu

Re: [PHP-DB] mssql_query amp; ROLLBACK

2003-03-24 Thread Prev=EDt?= (j)
You can't split a transaction between multiple calls to mssql_query. The memory used (in the server and client) are cleared between each call. Are you sure? Because this denies that: mssql_query(SELECT @@TRANCOUNT); // returns 0 mssql_query(BEGIN TRANSACTION); mssql_query(SELECT @@TRANCOUNT);