[PHP-DB] MySQL Error 1251 / phpMyAdmin

I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary

[PHP-DB] Re: MySQL Error 1251 / phpMyAdmin

says, doesn't support the new, more secure authentication protocol. Your choices are to tell mysql to use the older, less-secure protocol, or build a copy of php using your current mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH

[PHP-DB] Re: Update Query with special conditions.

I am curious about doing something simular to this... does anyone have an idea On Wed, 24 Nov 2004 00:43:32 -0500, list 123. list wrote: Using mySQL 4.0, I would like to know how I can code a query that will change the value of Participants.Active from Y to N is for three or more CONSECUTIVE

[PHP-DB] Optimize Query Output

I have the following query: SELECT A.`AttID` , S.`SessionDate` , P.LastName, P.FirstName, A.`Present` FROM `Attendance` A, Sessions S, Participants P WHERE S.SessionID = A.`Session` AND P.Part_ID = A.`Participant` GROUP BY P.LastName, P.FirstName, A.Present, A.AttID I would like to have the

Re: [PHP-DB] Upgrading mySQL

/mysql/en/Upgrading-from-4.0.html On Sun, 14 Nov 2004 09:30:49 -0500, GH [EMAIL PROTECTED] wrote: I would like to know how to upgrade mySql from 4.0 to 4.1? I am running mandrake 10 I am using the preinstalled versions of both mySQL and PHP (php4). I am a newbie to Linux and am

[PHP-DB] Upgrading mySQL

I would like to know how to upgrade mySql from 4.0 to 4.1? I am running mandrake 10 I am using the preinstalled versions of both mySQL and PHP (php4). I am a newbie to Linux and am a bit nervous. Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Problem with an insert query

Explain Bind Vars please... Thanks On Sat, 13 Nov 2004 19:08:59 +, Simon Rees [EMAIL PROTECTED] wrote: You also appear to have a quote in the value that contains the word members' You will need to escape this or use bind vars. Simon On Saturday 13 November 2004 06:29, GH wrote

[PHP-DB] Problem with an insert query

In my mySQL database I have the following tables: +-+ | Tables_in_AHRC | +-+ | Attendance | | Participants| | ProgressNotes | | Sessions| | Staff | | StaffAttendance | +-+ I am trying to insert data in the ProgressNotes

Re: [PHP-DB] Re: [EMAIL PROTECTED] November 2, 2004

However, when other countries are in trouble or need something... who do they turn to? America Therefore everyone in the world has an interest in what happens in the american body politic just as Americans have an interest in what happens to the British Prime Minister and in parts of the British

Re: [PHP-DB] Re: [EMAIL PROTECTED] November 2, 2004

On Tue, 2 Nov 2004 03:04:10 -0500, GH [EMAIL PROTECTED] wrote: However, when other countries are in trouble or need something... who do they turn to? America Therefore everyone in the world has an interest in what happens in the american body politic just as Americans have an interest

[PHP-DB] November 2, 2004

Greetings: This is just a friendly reminder that if you are registered in the United States to VOTE on November 2, 2004 (TOMORROW) Need to know where you vote? Please see the attached file (it is an image) that contains some information -- PHP Database Mailing List (http://www.php.net/)

[PHP-DB] Lost in query... Trying to get output from query....

Greetings: I am having a problem with trying to get data out of my mySql database. I run my query which works fine and everything... I use: $admin_get_options_query_text = Select * from adminpage; $admin_get_options_results_reference =

[PHP-DB] Re: [PHP] Lost in query... Trying to get output from query....

Thank You Murray's suggestion worked On Mon, 11 Oct 2004 11:20:57 -0400, John Nichel [EMAIL PROTECTED] wrote: GH wrote: Greetings: I am having a problem with trying to get data out of my mySql database. I run my query which works fine and everything... I use

Re: [PHP-DB] Dynamic pull down menus with PHP/Mysql

For a project in college that I had once did using ColdFusion and MSAccess (please dont kill me :)) I had the simular situation What I did was when the First Drop Down was changed... it had an onChange action or something of that nature (do not have my exact code infront of me) that went to a

Re: [PHP-DB] Re: Convert plain text to HTML tagged text

I have a question along this line... is it possible to have PHP do more than one str_replace at the same time? or would I need to pass through each time seperately? I.e I wasn to check for Line returns and change it to p, i want to replace [c] with a special formating tag etc...? Thanks?

Re: [PHP-DB] Names with apostrophe's

You need to use the urlencode() function On Wed, 29 Sep 2004 13:23:07 -0500, Craig Hoffman [EMAIL PROTECTED] wrote: Hello, I could use some help here. I have an entry in the MySQL, that use an apostrophe, for example lets call it O'Reilly. I have added addslashes to my insert statement