Re: [PHP-DB] autoincrement start with higher number

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.

Re: [PHP-DB] How do I get a ' in my sql statement?

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

Re: [PHP-DB] auto increment

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,

[PHP-DB] Re: Resetting auto_incremented values

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

Re: [PHP-DB] BBS program

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

Re: [PHP-DB] passing variables from one page to another

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,

Re: [PHP-DB] Auto Increment Problems....

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

Re: [PHP-DB] Auto Increment Problems....

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

Re: [PHP-DB] PhpmyAdmin from external computers

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

Re: [PHP-DB] Uploading files

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 -

RE: [PHP-DB] Re: mail() function and AOL users

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

RE: [PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

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

Re: [PHP-DB] I'm not getting any mailing list messages

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

Re: [PHP-DB] MySQL to EXCEL?

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

Re: [PHP-DB] Auto-increment questions...

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: