Jed wrote:
Hello All,
I'm new to PHP but was able to get some simple sample programs working
accessing a local Oracle database using the php_oci8.dll extension provided
with the php 4.3.4 distribution. I installed the PHP5 beta version but
there is no php_oci8.dll provided, only php_oracle.dl
Hi,
can any body tell me the maximum character length of mysql table name, column name,
etc.
Saqi
How about the following;
SELECT DISTINCT left( name, 1 ) AS idx, count( * )
FROM users
GROUP BY idx
produces a count of the names found for each letter, then you can make
decisions about your range of letters, like a max of 250 between letters, or
some such number.
Warren Vail
-Original M
How would I create a select statement in MySQL that would return a range of
records from the LastName field where the value starts with a designated
letter - for example, returning the range where the first letter of LastName
is between A and E...
Any help would be greatly appreciated.
Hi Kirt,
Your tables look ok to me... As for your question, if I were using your
example, I would link the field teams.name to players.team_name. For
example, I would set another column in the teams table to be auto
incrementing. As you add the team information, the team will get a number
automati
I would do it a little bit different:
1. I would add ID's for each of the tables.
2. I would split teams in 2 tables; the captain stuff would be in a
separate table (captain_team let's say), simply because I would have
different players as captains in different games. If you keep the
structure as
Hi everyone,
I would like to set up the following two tables inside a db for a soccer
league, but wanted to run their structure by you guys first. Here it is:
dbname: soccer_stats
tables: teams, players
teams
--
name | captain | division | paid | pmnt_notes | win | loss | tie | goals_for
|
I have a PHP problem with the ODBC interface returning TRUNCATED result
sets on Linux.
Environment:
PHP: 4.3.3
Web server: Apache 2.0.47
OS: Linux Redhat 9.0
Host database: IBM AS/400 (now known as iSeries)
ODBC Driver: IBM Client Access for Linux
ODBC library: unixODBC 2.2.6
I have a query that
You should try this:
Header("Content-Type: text/plain");
Header("Content-Disposition: attachment; filename=file.csv");
Then output the text you want to send. Make sure you double-quote it so that the
newlines work!
$eol = "\n";
echo "Field 1,Field 2,$field_variable,$eol"
..
This sends a st
THAT'S IT!!!
Sweet...
Xmas hangover be damned... got there in the end..!
Cheers everyone, happy new year!!!
"John W. Holmes" <[EMAIL PROTECTED]>
29/12/2003 13:11
Please respond to
[EMAIL PROTECTED]
To
[EMAIL PROTECTED]
cc
[EMAIL PROTECTED]
Subject
Re: [PHP-DB] Remove all instances of a chara
[EMAIL PROTECTED] wrote:
Tried that but I got an error when using PHPMyAdmin...
UPDATE risk_corpdatacapture email = REPLACE(email,';','')
just don't work???
You're missing "SET"...
UPDATE risk_corpdatacapture SET email = REPLACE(email,';','');
--
---John Holmes...
Amazon Wishlist: www.amazon.com
Does the ; need a backslash?
UPDATE risk_corpdatacapture email = REPLACE(email,'\;','')
Not sure but might be worth a try (back it up first!!)
Peter
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 29 December 2003 10:17
To: CPT John W. Holmes
Cc: [EMAIL PROTEC
Tried that but I got an error when using PHPMyAdmin...
UPDATE risk_corpdatacapture email = REPLACE(email,';','')
just don't work???
Wll confused now, cuase that's what I tried before I posted to the list...
and you guys say it should work too...
Any other ideas?
=
Error
SQL-query :
13 matches
Mail list logo