Hi,
how do i pass the arguments to the db when using the mssql_execute function?
thanks,
Filipe
Use mssql_bind
-- bob
On Mon, 5 Jan 2004, Filipe Girafa wrote:
Hi,
how do i pass the arguments to the db when using the mssql_execute function?
thanks,
Filipe
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
What is missing/wrong here?
What is MEANT to occour is explained below.
I want to grab the bounced emails from a mailbox and
grab the bounced email address from the body and input
it in a query to update a db.
But :
mysql_query (DELETE FROM emaillist WHERE EMail =
'$email');
Seems to
Hi again,
Also how do I output on the php page the email
addresses it collects from the email body?
echo Email was . $email . ;
appears to return nothing...
Thanks!
?php
include(../db/connectionstart.php);
global $IP_RegExp_Match, $Host_RegExp_Match,
$Email_RegExp_Match;
Hi,
Nevermind, got it to work now, always happens... Post
and work it out 5 seconds later. :P
J
http://personals.yahoo.com.au - Yahoo! Personals
New people, new possibilities. FREE for a limited time.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
On Monday 05 January 2004 12:33, JeRRy wrote:
Hi Neil,
Could you please send me the code again please? Seems
like my email client did a wibble last night and lost
all my emails. :(
Sorry about that.
If it was a list posting from Neil that you require then look it up the
archives. If
On Monday 05 January 2004 11:55, Richard Bewley wrote:
I compiled mySQL 4.0.16 from source, and installed PHP 4 off the RH9 cd.
I also have the php-mysql-4.2.2-17 rpm installed. But for some reason, I
keep getting call to undefined function mysql_connect, and it won't
connect to the mysql
Anyone ???
vv
From: [EMAIL PROTECTED] (Monty)
Newsgroups: php.db
Date: Sun, 04 Jan 2004 13:48:56 -0500
To: [EMAIL PROTECTED]
Subject: BINARY not recognized ??
Hi. My server has MySQL 3.23.58 installed, and I just migrated over from
RedHat 7.2 to ES 3.0.
Previously I was using
Is there a way for PHP to query a database and get the date that a data
file was uploaded?
Scenario:
Table is cleared.
A flat file gets uploaded on Monday Jan 5, 2004.
Where can I query to get the timestamp of the upload?
On Wednesday the 7th I would like to query something to get
On Tuesday 06 January 2004 03:51, Monty wrote:
Anyone ???
www.mysql.com ???
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
--
Search
On Tuesday 06 January 2004 04:18, Larry Sandwick wrote:
Is there a way for PHP to query a database and get the date that a data
file was uploaded?
Yes, as long as you've stored into the database the date that the data file
was uploaded.
A flat file gets uploaded on Monday Jan 5, 2004.
From: Monty [EMAIL PROTECTED]
I now get an error from MySQL stating that BINARYuser_name is not a
valid
column. So, something seems to be broken. I looked through the MySQL
online
docs and BINARY is still there, but, it won't work for me.
Maybe try putting a space between BINARY and the
I've already checked the MySQL site, and there's nothing about not being
able to use WHEN BINARY field_name in SELECT clauses, even though it doesn't
work for me anymore.
From: [EMAIL PROTECTED] (Jason Wong)
Organization: Gremlins Associates
Newsgroups: php.db
Date: Tue, 6 Jan 2004 05:22:26
Never mind, problem solved. I found the answer somewhere else - NOT the
MySQL online docs. They are really horrible!
From: [EMAIL PROTECTED] (Jason Wong)
Organization: Gremlins Associates
Newsgroups: php.db
Date: Tue, 6 Jan 2004 05:22:26 +0800
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB]
Because you guys are much smarter!! :)
From: [EMAIL PROTECTED] (Jason Wong)
Organization: Gremlins Associates
Newsgroups: php.db
Date: Tue, 6 Jan 2004 06:04:31 +0800
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: BINARY not recognized ??
On Tuesday 06 January 2004 05:54, Monty wrote:
I SWEAR to you that I am putting a space between WHEN and BINARY and
user_name. I even typed it out manually using extra spaces between every
command to be absolutely sure, but, MySQL insists on seeing BINARY user_name
as BINARYuser_name no matter how many spaces I put between it.
Here's what
I'm sorry, I feel dense coming to the list for this, because I'm
SURE I've read about this in the PHP or Mysql docs, but I can't seem
to locate where.
Let's say users submit a form which is processed by a PHP page which
performs a number of MySQL INSERT, UPDATE, and/or DELETE commands.
.
What
I believe the PHP parser will completely process that page whether you
click stop or not. In my experience it's always been all or nothing
as long as you don't hit an error half way through which I'd imagine
could cause a problem.
Ryan
-Original Message-
From: Peter Westergaard
Do a search for user stop in the PHP manual, there you will find
connection handling and the ignore_user_abort function.
At 2004/01/05 17:14, Peter Westergaard wrote:
I'm sorry, I feel dense coming to the list for this, because I'm
SURE I've read about this in the PHP or Mysql docs, but I can't
It appears that execution does stop if there is any output to the
browser. I usually do all of my query work before sending output to
the browser which would explain why I haven't seen it fail to complete.
I think this is what happens:
mysql_db_query(blaaa); These three should happen
You can always test if your SQL statement successfully completed or not to
determine errors. Using:
$myresult =mysql_query($queryX,$myconn);
if (! $myresult) {
echo mysql_error($myresult) ;
}
else {
// nothing or
echo Query successful;
}
Ryan Jameson
Monty wrote:
I SWEAR to you that I am putting a space between WHEN and BINARY and
user_name. I even typed it out manually using extra spaces between every
command to be absolutely sure, but, MySQL insists on seeing BINARY user_name
as BINARYuser_name no matter how many spaces I put between it.
We use the Access-Engine via ODBC. And it sopports rollbacks. But, please,
how could I rollback, what I want to, when I use a p-connection.
For example:
Transaction 1 (UPDATE TAB1...);
Transaction 2 (UPDATE TAB2...);
Between Transaction1 and Transaction2 the Connection to the DB gets
ALL OR NOTHING: (works i.e. with MS ACCESS - ODBC)
function prepare()
{ global $conn;
$result = odbc_prepare ( $conn, CREATE TABLE XX(test int);CRATE TABLE
YY;);
if(odbc_execute($result)){echo Everything is OK (but shouldn't!).;}
else{echo Error in the statement. Table XX should NOT be there.;}
Hi,
This code works fine as long as you only have 1 email
in your inbox. If there is more than 1 than it will
return the last emails from: address rather than look
in the $body for what's it meant to.
So I am looking for a solution. One I thought which
could be the simpliest way is to display
Hi Everybody,
Please help me in this,
I have a search page, when people search they keywords and the result is 50
rows from mysql , how to display them page by page which each page contain
20 results , thanks in advance :
str_replace(' ','%',$searchwords);
$query=select * from table where
str_replace(' ','%',$searchwords);
$query=select * from table where colom like '%$searchwords%' order by id
desc ;
$result=mysql_query($query);
$numresult=mysql_num_rows($result);
Use limit in your select statement.
laters,
Fedde
~=There's a fine line between genius and insanity. I have
27 matches
Mail list logo