Error From Web Site
I am getting a Warning: Supplied argument is not a valid MySQL result resource in /usr/home/tsguide/html/ssi/phpfunctions.php on line 48 No results were found ... Pointers please. -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error From Web Site
Try the PHP list, This is not a MySQL error. System Administrator a.k.a. The Root of the Problem wrote: I am getting a Warning: Supplied argument is not a valid MySQL result resource in /usr/home/tsguide/html/ssi/phpfunctions.php on line 48 No results were found ... Pointers please. -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error From Web Site
Head over to http://www.phpbuilder.com/forum/ There is an entire list there for just this problem. Cheers M;) -Original Message- FROM: Colin Faber TO: System Administrator a.k.a. The Root of the Problem CC: [EMAIL PROTECTED] DATE: Tue 9/18/01 15:14 SUBJECT: Re: Error From Web Site Try the PHP list, This is not a MySQL error. System Administrator a.k.a. The Root of the Problem wrote: I am getting a Warning: Supplied argument is not a valid MySQL result resource in /usr/home/tsguide/html/ssi/phpfunctions.php on line 48 No results were found ... Pointers please. -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error From Web Site
How do I reset the auto-increment, I have a very large value in my table, how can I reset it or make it use a number that isnt already used. The value is so large now that it wont increment. Thanks in advance Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error From Web Site
At 2:27 PM -0600 9/18/01, System Administrator a.k.a. The Root of the Problem wrote: I am getting a Warning: Supplied argument is not a valid MySQL result resource in /usr/home/tsguide/html/ssi/phpfunctions.php on line 48 It means you didn't perform any error checking on the result of your mysql_query() call. Not a good idea. No results were found ... Pointers please. -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error From Web Site
Search the manual, check the archives, blah blah blah. This question was answered yesterday. See forwarded message below. dpk - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Jay Fesco [EMAIL PROTECTED]; Paul Reilly [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, September 17, 2001 1:36 PM Subject: RE: reset auto_increment? At 3:15 PM -0400 9/17/01, Jay Fesco wrote: Can someone tell me how to reset a column's auto_increment starting point back to 0 in mysql ? Thanks Paul According to Paul DuBois on page 169 of MySQL by New Riders (which you should buy): ALTER TABLE t DROP i, ADD i INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY Jay Actually, this will drop the column and renumber the rows sequentially. To just reset the sequence to 0 (well, to 1, since sequences start at 1), do this: ALTER TABLE t AUTO_INCREMENT = 1 -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php