KM & MySql

[Chris_Seahorn]

OK man...cut it out.

You know they tested all my stuff before approval. I just downloaded both fresh. Dumped the sql with phpmyadmin, edited the common.php files with my connection info and here they both be:

http://flex.hobby-site.com/examples/...SQL_Menu1.html
http://flex.hobby-site.com/examples/...SQL_Menu2.html

[Chris_Seahorn]

I finally decided on a portal for my site. Anyone needs help with my KM stuff...feel free to stop by. I'll get the forum up (nothing fancy, just the facts). Better than dumping issues with my stuff on the KM forum (it was never really suggested even when I was current here). This keeps Bob focused on his app and not having to deal with my baggage.

[dniezby]

LOL, I knew this would bring you out.

But kidding asside, here is what happens when I dump the SQL_Menu2.sql file

Error

SQL query:

--
-- Table structure for table `sqlmenu_2`
--
CREATE TABLE `sqlmenu_2` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 25 ) COLLATE latin1_general_ci NOT NULL ,
`target` varchar( 100 ) COLLATE latin1_general_ci NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci AUTO_INCREMENT =6;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate latin1_general_ci NOT NULL,
`target` varchar(100) co

Then I modified the common.php

<?php

$hostname_PD = "localhost";
$database_PD = "dniezby_koolmoves";
$username_PD = "dniezby_km1";
$password_PD = "XXXXXX";  // Obviously, I removed my password
$PD = mysql_connect($hostname_PD, $username_PD, $password_PD) or trigger_error(mysql_error(),E_USER_ERROR); 
?>

Then uploaded the html, swf, common.php,SQL_Menu2.php to my server.
And this is what I get.
http://www.nssclan.org/km/menutest/SQL_Menu2.html
------------- Server Info -------------
MySQL client version: 4.1.10
phpMyAdmin - 2.9.0.2
Server version: 4.0.27-standard
Protocol version: 10
Server: Localhost via UNIX socket