Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

2007-08-22

phpMyAdmin :: Xdebug :
Warning on mysql_free_result()

I've never experienced an occurrence of this error before. I don't recall any changing anything in php.ini or elsewhere which would have caused something different to happen like the error shown in the screen capture, however, i did modify some of the Xdebug output parameters per the Xdebug Documentation, as follows:

[XDebug]
zend_extension_ts="C:/PHP_5.2.3/ext/php_xdebug-2.0.0-5.2.2.dll"
;
;  

xdebug.collect_params=1
xdebug.collect_vars=On
xdebug.profiler_output_dir="C:\Apache2.2\htdocs\tmpXDebug";

xdebug.manual_url="http://php.net/"
xdebug.remote_host="localhost"

;
;

Other than this modification, I can't think of any reason why this error would have occurred.

2007-05-16

phpMyAdmin - Notice on db Rename

this illustrates an xdebug notice which occurred when creating, then renaming a database

 
Posted by Picasa
Rename Database

NOTE: this posted only to provide insight to the phpMyAdmin developers. phpMyAdmin is an excellent, reliable software.

The notice is due to the php.ini settings for error reporting on this user's local system, not due to the phpMyAdmin software.

2007-03-17

DB View : Retail Inventory Mgmt

note the data fields which hold, in this example, an inventory of musical instruments where various colors (or other differences) are listed, vs the second table shown.


i also have a table which holds only each item's respective "Manufacturer" info, so i don't think i want that here-- therefore, i should remove the Manufac. names from the "nickname" (3rd field, top table) and keep it only in the Manufacturer's table.

I wonder: Is this as close as i might come to the 3rd normal form for these data types?...