User and permissions/grants - HELP!

Hi, I just installed MySQL version 4 and as usual, trying to set up users and grant permissions is a nightmare. I followed the instructions in the MySQL manual and granted permissions to a user, like below: GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY '12345678' WITH GRANT

Sorting question

Hi, I have a database with 5 teams and each team has 'n' categories and each category has 5 sub-categories. i.e TeamOne = Ottawa, Category 1 = Player Name, Sub-Categories = Goals, assists, ppg, gwg, points. Team0ne Category 1 Sub 1 Sub 2

Select Limit question

This is probably easy, but I just can't to put my finger on it. I have a list of numbers (i.e. 1 to 175) and I want to do a select statement to get the highest number. I have tried the limit thing but not getting the right output. Can someone shed some light on this? TIA -- MySQL General

MySQL query problems

Hi, Not sure if the problem here is PHP or MySQL, but here we go. I am trying to do two queries on a database - one after the other, but the second one never seems to get executed. The two queries are identical except for two variables. I have checked my form and they are correct and are being

RE: MySQL query problems

. Jef -Original Message- From: C. Reeve [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 10:16 AM To: [EMAIL PROTECTED] Subject: MySQL query problems Hi, Not sure if the problem here is PHP or MySQL, but here we go. I am trying to do two queries on a database - one after

What's up with this GATOR crap?

Hi, I have noticed recently that every time I go to the MySQL manual page I get prompted to install Gator spyware. If MySQL condones or is going to use spyware, I may have to consider using another database. This may sound extreme, but I do not condone the use of spyware in any form and would

Re: Fw: Help, Insert not working.

Would you care to elaborate on that - Using PHP there is no error or return code - it just goes along happily saying the record was inserted. If there is a way to do this, please explain. TIA - Original Message - From: gerald_clark [EMAIL PROTECTED] To: C. Reeve [EMAIL PROTECTED] Cc

Help, Insert not working.

Can anyone explain why this isn't working? It will not input the info into the database. $db = mysql_connect($serverhost, $serveruser, $serverpass); mysql_select_db($database_name); The variables in the above two rows are correct - I can do selects and it works fine. This is the data to be

Fw: Help, Insert not working.

. TIA - Original Message - From: C. Reeve [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:47 AM Subject: Help, Insert not working. Can anyone explain why this isn't working? It will not input the info into the database. $db = mysql_connect($serverhost

Remote Administration

Hi, How would I go about setting up remote administration of MySQL. MySQL is running on Windows 2000 and I will be connecting from Windows XP. I saw something in the MySQL docs about using an SSH client like Secure CRT, but it loses me at the linking OBDC. Any help on this or another similar way

Part Mysql part PHP question....

it to both lists. Thanks C. Reeve - 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

Using SUM in a select statement.

Hi, Not sure how to explain this - but here is what I need. I have a hockey pool database with three tables - one has the players and their stats, one has the team owner, and the 3rd is the reference file that ties the two together. I want to be able to do a query for all the players on a

Re: Using SUM in a select statement.

of OwnerName. Adjust the query to match your actual situation. If you are using version 3.23, AFAIK you'll either have to use two separate queries or calculate the totals in your app from the detail data. HTH, Tore. - Original Message - From: C. Reeve [EMAIL PROTECTED] To: MySQL List

Testing

Testing - Mysql - 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

Select question

Hi, I have a database with 3 names in it. In each of these names is 5 categories that have numbers in them. I want to be able to do a select and get the top number from each category for each name and display them from most to least. I have checked all the docs on the select statement, but

Re: Select question

=reference.idn and reference.idp=roster.idp and position like 'F' GROUP BY manager.name order by goals desc; Using the example below, this is what I get: Bill 70 John 48 Fred 87 This is what I want: Fred 87 Bill 70 John 48 TIA - Original Message - From: C. Reeve [EMAIL

Re: Fw: Problem on WinXP

telnet to it or see it in any other way. Beauford - Original Message - From: miguel solórzano [EMAIL PROTECTED] To: C. Reeve [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 3:49 AM Subject: Re: Fw: Problem on WinXP At 01:29 14/01/2003 -0500, C. Reeve wrote

Notice: Undefined index:

Hi, Anyone know why I would be receiving this error in Windows. I have a small PHP script that accesses a MySQL database and prints out a couple lines. This works fine in LinuxI have searched google and found many users with the same problem, but not one solution. TIA Notice: Undefined

Problem on WinXP

Hi, I just installed MySQL on my WinXP box and not sure what's going on. The server starts (or so it says it does) but I get an error saying I can't connect to localhost. Not sure what else to say. I have included some info below (note that I changed the port to 3308 in my.ini as Linux Mysql is

Fw: Problem on WinXP

Hi, I just uninstalled and reinstalled and got it to work on port 3306, but I can't get it to work on any other port. As I said, I have changed this in my.ini. Is there something else I should be doing to get this to work on a non-standard port.? TIA - Original Message - From: C

Re: MySQL and PHP question

PROTECTED] Sent: Wednesday, December 18, 2002 1:32 AM Subject: Re: MySQL and PHP question On Wed, 18 Dec 2002 22:54:53 -0500, C. Reeve wrote: while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { $num1 = $line['number']; } Loop through the result and return the value from the last row

$Variables and Select statements

Hi, From the code below $wk gets the values (w1, w2, w3, etc.) as it goes through the 'for' loop. w1, w2, etc. are also colums in the table manager. What I can't figure out is why the select statement fails (no error, just no data) when I use $wk as apposed to hardcoding w1, w2, etc. Is this

Re: $Variables and Select statements

- Original Message - From: Basil Hussain [EMAIL PROTECTED] To: C. Reeve [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 11:57 AM Subject: RE: $Variables and Select statements Hi, while ($line = mysql_fetch_array($result, MYSQL_ASSOC

MySQL and PHP question

Hi, Why is it that I can not use two mysql queries in the same PHP file. I have tried to do this several times trying to put my site together and have had nothing but problems. The recent one is this: I use a SELECT statement to get some info from a table, then I modify that info and use an

Re: MySQL and PHP question

17, 2002 5:12 PM Subject: Re: MySQL and PHP question On Wed, 18 Dec 2002 16:05:35 -0500, C. Reeve wrote: I can not use two mysql queries in the same PHP file Please post code snippets, this is possible. - Steve Yates - Burger Borg: We do it our way; yours is irrelevant. ~ Taglines

Select / Calculate question

Hi, I have one table with an id1 column and a number column, these numbers correspond to another table with an id2 column and a name column and a total column. I also have a reference table with ties the two together (an id1 and id2 column). I want to be able to select all numbers in the first

What is wrong with this Alter statement?

From the MySQL Manual: ALTER TABLE tbl_name MODIFY [COLUMN] create_definition [FIRST | AFTER column_name] I have also tried CHANGE instead of MODIFY. My Statement: alter table manager change column w1 decimal(8,2) not null after moves; The problem is the AFTER statement, if I omit it I have