Re: What am i doing wrong? SQL Query in PHP

At 13:37 9-3-2003, you wrote:

I want to display the first 3 words of my record in the my table and following is the code i'm using. When i use the SQL Query in mySQL.. it works great.. but when i try to implement it in my php page.. i'm not getting anything.. no error, no display, no result.. just blank.. why?

i don't know what's wrog but you could do some quick debugging by echoing mysql_error() when the query fails. ($result=mysql_query(.....) or die ('<br>Query failed at'.__FILE__.' line '.__LINE__.' and mysql says:<br>'.mysql_error());

<?php $db = mysql_connect("localhost","user","pass"); mysql_select_db("mydb",$db); $result = mysql_query("SELECT substring_index(title, ' ', 3) from news order by ID desc limit 4",$db); if ($myrow = mysql_fetch_array($result)) { do { check whether there are some results walked through by doing something silly like echo '*'; here.

    echo(" $myrow[title] ");

} while ($myrow = mysql_fetch_array($result)); } ?>