<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><br><blockquote type="cite"><div>Everything went well, phpMyDamin was happy, but when I clicked on <br>[Create PHP Code] the result below was not what I had expected :<br><br>------------------------------------------------------<br>$sql = "# MySQL returned an empty result set (i.e. zero rows).\n"<br> . "\n"<br> . "DELIMITER ;\n"<br> . "";<br>------------------------------------------------------<br><br>Any Ideas what I might be doing wrong ?<font class="Apple-style-span" color="#000000"><font class="Apple-style-span" color="#144FAE"><br></font></font></div></blockquote><br></div><div><br></div><div><br></div><div><div>The interesting thing is that if you look at the structure for the table prior to entering any records, and :</div><div><br></div><div>( 1 ) I click on the "Details..." link at the bottom of the page</div><div>( 2 ) I can see the "telephones_insert_trigger" I had just entered via the SQL window.</div><div>( 3 ) I click on the pencil icon, and there's my TRIGGER in a SQL Query window...</div><div>( 4 ) I look it over, and am happy to see how easy this will be to modify, but I just click on the [GO] button</div><div>( 5 ) Now I see the phMyAdmin green happy message : Your SQL query has been executed successfully</div><div>( 6 ) Below that I see :</div><div><br></div><div>-----------------------------------------------</div><div>DROP TRIGGER IF EXISTS `mvc_project_01`.`telephones_insert_trigger`//# MySQL returned an empty result set (i.e. zero rows). CREATE TRIGGER `mvc_project_01`.`telephones_insert_trigger` BEFORE INSERT ON `mvc_project_01`.`telephones` FOR EACH ROW BEGIN SET NEW.created = NOW(); SET NEW.modified = NOW(); END //# MySQL returned an empty result set (i.e. zero rows). </div><div>-----------------------------------------------</div><div><br></div><div>( 7 ) Now I click on [Create PHP Code] again, but this time I get the expected results, shown below :</div><div><br></div><div>Showing as PHP code</div><div>-----------------------------------------------</div><div>$sql = "DROP TRIGGER IF EXISTS `mvc_project_01`.`telephones_insert_trigger`//# MySQL returned an empty result set (i.e. zero rows).\n"</div><div> . "\n"</div><div> . "CREATE TRIGGER `mvc_project_01`.`telephones_insert_trigger` BEFORE INSERT ON `mvc_project_01`.`telephones`\n"</div><div> . " FOR EACH ROW BEGIN\n"</div><div> . " SET NEW.created = NOW();\n"</div><div> . " SET NEW.modified = NOW();\n"</div><div> . " END\n"</div><div> . "//# MySQL returned an empty result set (i.e. zero rows).\n"</div><div> . "";</div><div>-----------------------------------------------</div><div> </div><div>So it appears as though when you first create the trigger and click on [Create PHP Code] you only get :</div><div> </div><div>-----------------------------------------------</div><div> $sql = "# MySQL returned an empty result set (i.e. zero rows).\n"</div><div> . "\n"</div><div> . "DELIMITER ;\n"</div><div> . "";</div><div>-----------------------------------------------</div><div><br></div><div>But once you edit the trigger, save it, and click on [Create PHP Code] a second time you get the expected answer...</div><div><br></div><div>Thank You...</div><div><br></div><div>Bill Hernandez</div><div>Plano, Texas</div><div><br></div></div></body></html>