try
if($mysql stuff her){
worked
}else{
doestn't work
}I don't know how to get the other info you wanted besides just finding it out before hand and see what he info is afterr you do the mydql stuff.
From: "Mike Millner" <[EMAIL PROTECTED]>
To: <php-db@lists.php.net>
Subject: [PHP-DB] How-to pass informational mysql messages to the browser
Date: Thu, 24 Feb 2005 15:07:00 -0700
MIME-Version: 1.0
Received: from lists.php.net ([216.92.131.4]) by mc9-f16.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Fri, 25 Feb 2005 09:43:46 -0800
Received: from ([216.92.131.4:17091] helo=lists.php.net)by pb1.pair.com (ecelerity HEAD r(5124)) with SMTPid 48/A0-51537-2D36F124 for <[EMAIL PROTECTED]>; Fri, 25 Feb 2005 12:43:46 -0500
Received: (qmail 74804 invoked by uid 1010); 25 Feb 2005 16:31:25 -0000
Received: (qmail 63883 invoked by uid 1010); 25 Feb 2005 15:56:23 -0000
X-Message-Info: JGTYoYF78jGWrXpi2PLaE9h/sWIqJx14oyCu07itRec=
Return-Path: <[EMAIL PROTECTED]>
X-Host-Fingerprint: 216.92.131.4 lists.php.net Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
Precedence: bulk
list-help: <mailto:[EMAIL PROTECTED]>
list-unsubscribe: <mailto:[EMAIL PROTECTED]>
list-post: <mailto:php-db@lists.php.net>
Delivered-To: mailing list php-db@lists.php.net
Delivered-To: [EMAIL PROTECTED]
Delivered-To: [EMAIL PROTECTED]
X-Host-Fingerprint: 216.241.44.155 slacker.mikeshome.com Linux 2.4/2.6
References: <[EMAIL PROTECTED]>
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-OriginalArrivalTime: 25 Feb 2005 17:43:46.0479 (UTC) FILETIME=[8E668BF0:01C51B61]
Hello everyone,
My PHP/mysql pages are working perfectly, the problem is users don't know if what they are doing is working.
I have a system that adds and deletes tape id's from mysql via a PHP front end.
I would like to pass the same success/failure messages that I would get if I performed the add/delete directly within mysql.
For example, If I delete a tape from the db within mysql, after I hit enter I get the following message:
mysql> delete from tape_tracking_test where media_id like 'TR44'; Query OK, 1 row affected (0.01 sec)
I would like to display this message to the browser:
Query OK, 1 row affected (0.01 sec)
Any help would be appreciated,
Thanks, Mike
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
