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
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;
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
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
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
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
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
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
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
-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);
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.
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
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
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 =
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'))) {
// ...
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'))) {
// ...
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
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
--
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:
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
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
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
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
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
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:
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,
there are a million sample php script in links...
http://www.php.net
muhammad_wahyu
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);
28 matches
Mail list logo