Hi Ryan,
I am using the binary dist. isapi on w2k server with IIS 5 (*not my choice)
The reason I am eager to upgrade to 4.2.0 is that there is supposed to be a
bug fix in the ODBC handling of long-varchar's (which is very irritating
because it crashed the entire IIS).
Kind regards,
Joop
Using the Oracle OCI interface, as far as I can see if I do the following:
$stmt = OCIParse($conn, 'DELETE FROM TITLES'
. ' WHERE TAG0'
. ' RETURNING ID INTO :T_ID');
there seems to be no way of picking up more than one ID when
On Wed, May 01, 2002 at 12:35:48PM +0100, Ford, Mike [LSS] wrote:
Using the Oracle OCI interface, as far as I can see if I do the following:
$stmt = OCIParse($conn, 'DELETE FROM TITLES'
. ' WHERE TAG0'
. ' RETURNING
Hi We are a publishing company based in London. We have developed a
multi-user
MS Access contact management and bookkeeping database system which we want
to adapt / re-write such that it can be used over the web ( ASP) using
Internet
Explorer (or similar) from any location, as our clients would
Hi All
I have added a row to my table which inputs which admin user has amended
a record in a table on my db.
I have this working but what I would like to do is count how many
instances of the admin id I have stored.
So if my list looks like this..
Admin_id
1
2
2
2
3
3
3
3
assuming these are your fields:
post_id
admin_id
code would look something like:
?
Mysql_pconnect(host,user,pass);
Mysql_select_db(db);
$totaladmins=3;
For($i=1;$i=$totaladmins;$i++)
{
$query = select count(post_id) as Admin1 where
Admin_id=$i;
$result =
If I have records like this
ID Content
1 John have a red book, and a yellow book. He give a yellow book to
Tina.
2 Luke doesn't have any book at all, he always borrow it from John.
3 John like swimming.
Can I search this records (table) for a word book and also number of
book
Hi Dave
Assuming you are using mysql try the following query
select count(Admin_id) as admin1, Admin_id as admin2 from TABLE_NAME group
by admin2
substituting TABLE_NAME for whatever you have called your table.
Hope this helps
Cheers
Tony James
- Original Message -
From: Dave
On Wednesday 01 May 2002 08:15, you wrote:
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
snip
Thanks for the replies on this topis folks.
For the moment the form targer=_blank ... will do the job.
However, I will certainly try out the other methods suggested.
Regards
Bob Parker
--
I'm toying with this script I found for doing DB queries.. Up until I added
the print (TABLE...) and print (/TABLE); code, it worked.. can
anyone help me find out what I'm doing wrong? (quoting the bit of the
script, so as not to do the TMI bit :)
What this does now is give me 560k read and a
On 12:00 PM 5/1/2002 -0400, Glenn Sieb wrote:
I'm toying with this script I found for doing DB queries.. Up until I
added the print (TABLE...) and print (/TABLE); code, it worked..
can anyone help me find out what I'm doing wrong? (quoting the bit of the
script, so as not to do the TMI bit :)
Hello!
Hasn't anyone got this working ?
Prince Kumar [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
I was thinking the same. But I believe there should be a better way. (We
do't want to pass the package variables as OUT variable in a procedure or
return them from function, if
Is it possible to make a MySQL connection object global, so that it doesn't
need to be declared as a parameter to be accessed from individual functions?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I'm not sure what you're asking but the fields are set to varchar(40) which
will accommodate the information I have been insertinging...
/T
on 4/30/02 9:00 PM, Neil at [EMAIL PROTECTED] wrote:
Have you checked to see that id tidying is set to the amount equal to the
fields in your form.
I have a form on one server which takes a name in one field, intentionally
including spaces as a full name. That value shows up as a form variable as I
intended when I display it on the same server. It is sent to another server
and written to a mysql database there. At that time, only the
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
I have a form on one server which takes a name in one field, intentionally
including spaces as a full name. That value shows up as a form variable as I
intended when I display it on the same server. It is sent to another server
and
Hi Dave,
The easiest, most direct, ANSI - SQL way to do what you ask is:
SELECT count(*) as num_posts, Admin_id
FROM your_table_Name
WHERE optional but you could narrow the results here
GROUP BY Admin_id
ORDER BY Admin_id
This will give you:
num_posts Admin_id
-
3
17 matches
Mail list logo