ZandarKoad Posted April 26, 2015 Share Posted April 26, 2015 I was using a PDO version of the PHP querry code that used RecursiveIteratorIterator to spit out the display, but wrapping my brain around those multi-level sub-sub nested abstract classes was making my brain bleed. I had thought it was a problem with the HTML syntax, but that appears not to be the case. I went with a dumber version of an HTML table display snippet, and I'm having the same problem.This MySQL query works great in PHPMyAdmin and on Workbench, but when I put it into a .php file on a live site, it won't ever display any content from the "english_phrases.phrase_content" column. It doesn't throw any errors. Just puts out blanks where English phrases should be. As you can see, it works great in PHPMyAdmin: Here's the PHPMyAdmin output: http://screencast.com/t/wM6xiJ08a Here's the live output: http://screencast.com/t/oBHJmNoT0U Any ideas? mysql_connect($servername,$username,$password); @mysql_select_db($dbname) or die("Unable to select database"); $query="SELECT english_phrases.phrase_index_key, english_phrases.phrase_content, cebuano_phrases.phrase_content, english_phrases.author FROM english_phrases LEFT JOIN cebuano_phrases ON english_phrases.phrase_index_key=cebuano_phrases.phrase_index_key"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); echo "<b> <center>Database Output</center> </b> <br> <br>"; echo "<table align='center' style='border: solid 1px black;'>"; echo "<tr style='width:200px;border1px solid black;'><th>Phrase ID</th><th>English Phrase</th><th>Cebuano Phrase</th><th>Author</th></tr>"; // <td style='width:150px;border:1px solid black;'> $i = 0; while ($i < $num) { $field1name = mysql_result($result, $i, "english_phrases.phrase_index_key"); $field2name = mysql_result($result, $i, "english_phrases.phrase_content"); //This NEVER displays content! $field3name = mysql_result($result, $i, "cebuano_phrases.phrase_content"); $field4name = mysql_result($result, $i, "english_phrases.author"); Quote Link to comment https://forums.phpfreaks.com/topic/295881-mysql-join-query-works-on-workbench-not-on-site/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.