Viewing records/Deleting Tables
Posted: Tue Mar 11, 2003 4:35 am
Hi I have just got PHP and MySQL going on my machine and am doing my first tutorial. Just started and already am stuck.
1) Have been trying to access a small table i created and keep getting this error.
PHP Warning: mysql_query() [function.mysql-query]: Unable to save result set in C:\Inetpub\wwwroot\test.php on line 21 PHP Warning: mysql_result(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\test.php on line 25 PHP Warning: mysql_result(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\test.php on line 29
It´s probably due to an error in the records entered but I have just realised that WINMYSQLAdmin does not have the facility to create, destroy, delete or VIEW tables, or records.
?What application do I need to edit/records my tables manually?
2) I read in a posting that it is possible to import and export a database from WinMySQLAdmin but cannot seem to find the option, should this only be done from the dos promt/shell.
Any help would be great
williery (Novice)
1) Have been trying to access a small table i created and keep getting this error.
PHP Warning: mysql_query() [function.mysql-query]: Unable to save result set in C:\Inetpub\wwwroot\test.php on line 21 PHP Warning: mysql_result(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\test.php on line 25 PHP Warning: mysql_result(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\test.php on line 29
It´s probably due to an error in the records entered but I have just realised that WINMYSQLAdmin does not have the facility to create, destroy, delete or VIEW tables, or records.
?What application do I need to edit/records my tables manually?
2) I read in a posting that it is possible to import and export a database from WinMySQLAdmin but cannot seem to find the option, should this only be done from the dos promt/shell.
Any help would be great
williery (Novice)