I've used Oracle for years, and am not aware of Oracle having case sensitive column
names.
Torsten Lange [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]
But when using queries on the USER_... data dictionary, Oracle
delivers always big letters, which is for chemical elements (NA
Right, todays fun dilema... ;-)
I've a user capture system set up for downloads on our site.
Each time a user downloads a file, their info is captured (so we'll have
multiple entries for each email address).
Also in the table, is a field to state if the result has been viewed by my
boss. (Just a
FROM:Mr DAVIES HARRIES
bills and exchange director
GUARANTY TRUST BANK PLC
Email:[EMAIL PROTECTED]
Fax No:14134519233
Dear Sir,
I am Mr.Davies Harries the bills and exchange director
at the GUARANTY TRUST BANK PLC, I am writing this
letter to solicit for support and assistance from you
to carry
Christopher Jones wrote:
Torsten Roehr wrote:
Torsten Lange [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
But when using queries on the USER_... data dictionary, Oracle
delivers always big letters, which is for chemical elements (NA
vs. Na) or location names (ALICE SPRINGS vs.
Is this what you want ??
$sql = SELECT DISTINCT(email) FROM $table;
$result = mysql_query($sql,$connection) or die(Couldn't execute query 0.);
$row1 = 0;
while ($row = mysql_fetch_array($result)) {
echo $row[email] ;
$sql1 = SELECT * FROM $table WHERE viewed = '1' AND
Kinda, but I just wanna count how many views in total...
Hence my $row1++; bit...
I'll have a play with your code though...!
Cheers,
Tris...
Daniel Clark [EMAIL PROTECTED]
03/06/2004 14:28
Please respond to
Daniel Clark [EMAIL PROTECTED]
To
[EMAIL PROTECTED] [EMAIL PROTECTED],
[EMAIL
Robert,
Do you have an example of pulling the Column types from an MS Sql query? For example:
select top 1 * from mytablename.
loop thru the fields in the recordset and print out their data types?
--
Gerardo S. Rojas
mailto: [EMAIL PROTECTED]
-Original Message-
From: Robert Twitty
$sql1 = SELECT COUNT(*) as views FROM $table WHERE viewed = '1' AND email =
'$row[email]';
$views = mysql_resutl(mysql_query($sql1,$connection),views);
maybe?
.bobo
www.elstudion.com/bitbob/ - not finished though...
- Original Message -
From: [EMAIL PROTECTED]
To: Daniel Clark
OK, how about this?
$sql = SELECT DISTINCT(email) FROM $table;
$result = mysql_query($sql,$connection) or die(Couldn't execute query
0.);
while ($row = mysql_fetch_array($result)) {
echo $row[email] ;
$sql1 = SELECT * FROM $table WHERE viewed = '1' AND email =
'$row[email]';
Nope...
HHmmm, this is really getting to me...
I can do distinct, I can count, but I can't combine the two?
Can't be that hard ;-)
Daniel Clark [EMAIL PROTECTED]
03/06/2004 16:49
Please respond to
[EMAIL PROTECTED]
To
[EMAIL PROTECTED]
cc
Daniel Clark [EMAIL PROTECTED], [EMAIL PROTECTED]
Not tested... how about something like this?
SELECT t1.email, t2.count(*)
FROM $table t1
LEFT JOIN $table t2 ON (t1.email = t2.email and t2.viewed = '1')
GROUP BY EMAIL
Nope...
HHmmm, this is really getting to me...
I can do distinct, I can count, but I can't combine the two?
Can't be that
If you are using odbtp as a driver for the mssql ext, and want
mssql_field_type() to return the actual type name, then call
odbtp_set_attr( ODB_ATTR_FULLCOLINFO, 1 );
before you run any queries.
-- bob
On Thu, 3 Jun 2004, Frank M. Kromann wrote:
mssql_field_type() is the function for that.
Have you tried - GROUP BY email - ?
Nope...
HHmmm, this is really getting to me...
I can do distinct, I can count, but I can't combine the two?
Can't be that hard ;-)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database
13 matches
Mail list logo