What am i doing wrong? SQL Query in PHP
| From: | Rahul.Brenda | Date: | Sun, 09 Mar 2003 12:37:47 +0000 |
| Subject: | What am i doing wrong? SQL Query in PHP | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-138853@lists.php.net to get a copy of this message | ||
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?
<?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 {
echo(" $myrow[title] ");
} while ($myrow = mysql_fetch_array($result));
}
?>
Rahul S. Johari
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/