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

[Chris Hayes]

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));
}
?>


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php