What determines the gaps???
On Oct 5, 2004, at 12:59 PM, [EMAIL PROTECTED] wrote:
OK. The problem is I don't want the next highest number.
There are gaps in the UID sequence. I need to find the next UNUSED
number in the sequence which is rarely the highest number.
Scott Nipp
Phone:
I don't know how you have it setup.
But you can create a XLS file on the fly using PHP
By using header...
header(Content-Type: application/vnd.ms-excel);
header(Content-Dispostion: attachemnt; filename='Project.xls');
header(Pragma: no-cache);
header(Expires: 0);
Then just echo your results
Did you get this one??
On Aug 12, 2004, at 2:02 PM, [EMAIL PROTECTED] wrote:
I just subscribed to the list yesterday and have yet to receive any
messages from the list. Any ideas?
--
Chip Wiegand
Computer Services
Simrad, Inc
425-778-8821
425-771-7211 (FAX)
Dan Brunner
Web Software Developer/IT
You could just use MysqlODBC, and import the data right into the excel
sheet.
Just setup a DNS that points to your Mysql server, on the windows box,
then select Data-Get External data-New Database Query within Excel...
I'm not sure what the data is, or why you need the data, or what your
Hello!!
That's not always true.
I just sent mail using php to my AOL account, and it worked. The smtp
mail server doesn't have a reverse dns lookup.
His problem might be that the SMTP server he is using my be on the black
list.
http://www.ordb.org/
This will cause a ton of problems.
It
Hello,
Are you uploading files into MYSQL or any other DB??
Or are you uploading the files to a directory and inserting the
location of the file in the database??
Dan
On Feb 27, 2004, at 3:19 PM, [EMAIL PROTECTED] wrote:
Pavel my form works fine with files 1M
- Original Message -
Hello!!
You need change your Usernames' host to your IP or simply change it
to % (Any host).
This is all changed in MYSQL.
Good Luck!!
Dan
On Dec 4, 2003, at 9:36 AM, [EMAIL PROTECTED] wrote:
Hello Andy,
Thursday, December 4, 2003, 3:27:11 PM, you wrote:
AL Im afraid ive already tried
Once again...
ALTER TABLE table1 AUTO_INCREMENT = 500
Dan
On Monday, July 29, 2002, at 10:44 PM, [EMAIL PROTECTED] wrote:
rite,
my primary key column (id) is set to auto_increment as usual which is
very
handy. But when I delete a row, the auto_increment just keeps
incrementing
something like that from something i read in the mysql manual, but it
only
mentioned it passing and didnt give an example or anything.
tanx
Daniel Brunner [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Once again...
ALTER TABLE table1 AUTO_INCREME
Hello!!
How are you fetching the rows???
mysql_fetch_rows?? or mysql_fetch_object???
Dan
On Monday, July 8, 2002, at 02:52 PM, [EMAIL PROTECTED] wrote:
You're right--I did leave out that end quotation mark. Unfortunately,
though, I'm still getting the same result after adding it.
best,
AHAHAHAH
Now that was funny!!
Do any of you remember the game Nuk'em?? That was a Blast!!
Dan
On Friday, June 21, 2002, at 12:50 PM, [EMAIL PROTECTED] wrote:
BBS = Backyard Bible Study?
Heh. Good guess. BBS = Bulliten Board System.
Chris
--
PHP Database Mailing List
Hello!!
ALTER TABLE $table1 AUTO_INCREMENT = 3
Dan
On Thursday, June 20, 2002, at 01:44 PM, [EMAIL PROTECTED] wrote:
sorry buddy, as far as I know you can't.
The only thing you can do is to set the counter higher but you can't
return
to a value under
the given row.
Please correct
Hello!!
ALTER TABLE $table1 AUTO_INCREMENT = 242
Replace the $table with your table's name and replace the end number
with what number you want.
Dan
On Thursday, June 13, 2002, at 08:27 PM, [EMAIL PROTECTED] wrote:
Hi guys,
The auto_increment field of my MySQL table gives me 258,
Hello!!
Spit some code out...I put a lot of ' in my inserts...
Is it from a form?!?!!?
Is it from a Insert, or Select or Update?!?
That's why we need some code...
Dan
On Monday, June 10, 2002, at 12:01 PM, [EMAIL PROTECTED] wrote:
I have noticed that when I try to assign the value of a
Hello!!
ALTER TABLE Table1 AUTO_INCREMENT = 1000;
Dan
On Friday, May 10, 2002, at 04:36 PM, [EMAIL PROTECTED] wrote:
Is it possible to have an autoincrement field start with a number, so
the first record would be, let's say, 1000 instead of 1? The next would
be 1001 instead of 2, etc.
15 matches
Mail list logo