gassaz

Some times when the wizard is executing the configuration (the last step) report a error for the mysql services start, check if the service name don't exist. if exist and you don't use it you can erase it. Another idea is try with a different version of mysql.

I think the problem is because you don't select te option "INCLUDE PATH....." in the config wizard. if you like to put the my.ini on mysql directory Solution 1: Add the path manually (google: winxp path) Solution 2: Run again the config wizard, but if you have data make a backup firts; and select the option to include the path.

Maybe in the logs say something about the error. Check the logs on the data folder.

Check if the data type of the field is datetime

Yes, you need install MyODBC driver. There are two versions: 3.51xxx and 5.xx you can use Either both.

Try this... Select * from Tablename where date_field >= '2009-08-19' and date_field<='2009-09-19'

Try Using ZeroFill... example: `id` int(5) unsigned zerofill NOT NULL auto_increment

Use IF. if(case_open='yes',1,0) This will reurn 1 is yes and 0 when is not.

Let me see... You want to check if a date it's between start_date & end_date.?????

Try This: [*]Enable The Mysql Service [*]On a cmd type: mysql --user=root --password=yourpass

Apparently there is an error using UNION with an exists... Google said: http://bugs.mysql.com/bug.php?id=25734

to do??

SELECT visitor_zip, COUNT(visitor_zip) AS cnt FROM zip GROUP BY visitor_zip ORDER BY time_register

Change the default value of INT type to 0.

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_single-transaction

I apologize, but my knowledge of php is not good yet,But there are experts here who can help you.

If you want the results on this way, the sql that you made is wrong. You got the idea.. Try this: SELECT blog.title, COUNT(blogcomments.blogtitle) FROM blog INNER JOIN blogcomments ON (blog.title=blogcomments.blogtitle) GROUP BY blogcomments.blogtitle

A query like this??? http://www.phpfreaks.com/forums/index.php/topic,262555.0.html

Try this.. SELECT player.playerID, player.playerFirstName, player.playerLastName, COUNT(playerstats.playerID) FROM playerstats INNER JOIN player ON (playerstats.playerID=player.playerID) GROUP BY playerstats.playerID;

Something like this: DELETE users.*, illustrators.*, comments.* FROM users u INNER JOIN illustrators i ON u.user_id = i.user_id INNER JOIN comments c ON u.user_id = c.user_id WHERE u.user_id = ???

Let google help you.... DbVisualizer

That is because you have a duplicated key... maybe the structure has changes... check the primary keys of the table..

Maybe if you give to us more information, we can try to help you..

Did you check the syntax for Mysql Insert Statement??

Try this... SELECT SUM(IF(gender='male',1,0)) AS 'male', SUM(IF(gender='female',1,0)) AS 'female' FROM nsnag