i think this is the right sintax:
SELECT * FROM `MEMBER` WHERE ISNULL(`PASSWD`)
Passwd is a blob, that is an interesting name for a blob field, what are you
planing to do?
- Original Message -
From: Ng Hwee Hwee [EMAIL PROTECTED]
To: DBList [EMAIL PROTECTED]
Sent: Friday, March 12, 2004
I've got a very simple PHP script for testing my MS SQL Server
connection. I've installed FreeTDS and I can connect and query the
database with TSQL.
With PHP I can connect and disconnect properly but I can't query or
attach to different databases. Here is my sample PHP followed by what
the web
Hmm, replace the line where you select the DB with:
$dbconnect = mssql_select_db(Northwind) or
die(mssql_get_last_message());
(All on one line incase the email wraps it.)
On Fri, 2004-03-12 at 08:35, Jason Morrill wrote:
I've got a very simple PHP script for testing my MS SQL Server
Hi Mark
An alternative solution for connecting to MS Access is odbtp. Details are
available at http://odbtp.sourceforge.net. It provides better support for
ODBC, especially in regards to MS Access. Take a look at the
storedqry.php example at http://odbtp.sourceforge.net/examples.html. It
This looks really great, Bob...thx!
Mark
-Original Message-
From: Robert Twitty [mailto:[EMAIL PROTECTED]
Sent: Friday, March 12, 2004 10:19 AM
To: Galbreath, Mark A
Cc: '[EMAIL PROTECTED]'
Subject: Re: [PHP-DB] ODBC support
Hi Mark
An alternative solution for connecting to MS Access
I'm working on a forum. When
it displays a forum index, it gets all the topics and depending on the
offset, displays only ten at a time. Now that's a single query. But
problem comes when I display how many replies each post has. So far, when
it does the while loop, it does a query for each item.
My domain is hosting through a hosting company on Linux with PHP 4.3.4.
Hosting company is not open to re-compile PHP for using FreeTDS or
any other application.
If I can not use FreeTDS, what other options do I have?
a) Can Pear be used? It is 4.3.4. I tried
?php required_once(DB.php) ?
Marcjon, I think you have asked this question before. there are replies
to it, have you checked those?
Marcjon Louwersheimer wrote:
I'm working on a forum. When
it displays a forum index, it gets all the topics and depending on the
offset, displays only ten at a time. Now that's a single query.
You need one ofe the folowing extensions compied as a shared or static
module:
ODBC (UnixODBC)
MSSQL (FreeTDS)
ODBTP
compiling as a shered module does not require recompile of PHP. You just
need to load the extension with dl() or from php.ini.
- Frank
My domain is hosting through a hosting
Is the machine running SQL Server also hosted by the same company? Is it
possible to use PHP on a Win32 machine so that you can use
the php_mssql.dll extension?
-- bob
On Fri, 12 Mar 2004, S K Rana wrote:
My domain is hosting through a hosting company on Linux with PHP 4.3.4.
Hosting
Is it possible to write one INSERT statement to populate multiple
tables?
__
Craig Hoffman - eClimb Media
v: (847) 644 - 8914
f: (847) 866 - 1946
e: [EMAIL PROTECTED]
w: www.eclimb.net
_
--
PHP Database Mailing List
Is there a way that after a execution of a Login script and validation
of login from a MySql database to automatically redirected to run
another script ?
example
someone logs in through the login.php script, in the login script you
are validated and then you run another script called
Is there a way that after a execution of a Login script and validation
of login from a MySql database to automatically redirected to run
another script ?
Use PHP's header() function. See the manual for syntax.
Larry
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
I have been trying to get this to work and think I must be missing
something. I am using Kevin Yank's books and examples as a guide. Here is
what I have so far - this does work [as it should since Kevin created it..
8-) ]
I have a form that creates a list of items with a select link that when
Sorry for all the dead space in my last post... I cleaned it up some here...
===
I have been trying to get this to work and think I must be missing
something. I am using Kevin Yank's books and examples as a guide. Here is
What is considered to be the headers() information
When I use the header() functions, I get an error stating that I have
already sent the headers information?
// Larry
-Original Message-
From: Larry E. Ullman [mailto:[EMAIL PROTECTED]
Sent: Friday, March 12, 2004 3:04 PM
To:
That means you send some output before the headers were sent. That is a
no no.
For instance, this will not work:
?php
Echo hello world;
header(Location:http://www.yahoo.com/;);
?
But this will
?php
header(Location:http://www.yahoo.com/;);
Echo hello world;
?
- Paul
-Original
You can do a redirect at any point in your code as long as you haven't
sent anything to the browser yet. You can run 10,000 lines of PHP code
and do 1,000 queries and still send a redirect to the browser. In a nut
shell, have no echo statement before your redirect.
On Mar 12, 2004, at 3:02
Does anyone know what version of php that ldap_connect() was released
with? It works on version 4.3.0 on this one server, but it does not
work on 4.2.3 on a different server? If it is supposed to work on
4.2.3, any suggestions on why it's not recognizing it as a valid
function?
Philip
Not to mention, the header() statement is being used incorrectly in the
example code.
You don't echo out the header() statement. You simply use it.
For example...
?php
include(whateveryouwant.inc);//as long as the .inc does not output
to browser
...BUNCHA' PHP STUFF, BUT NO ECHO
Here is the problem I am experiencing: I have a form that collects
data and I would like it to send it to three tables in a MySQL DB.
One table is called TRAININGLOG , other is called CORE and the third is
USERS. The USER table is the main table that contains the primary
key. My question
[EMAIL PROTECTED]
..
.
1.
2.()
3.[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
22 matches
Mail list logo