Re: [PHP] 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

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

Ok i tried this.. and i didn't get any error listed.. so it seems that the mySQL Query is not failing in syntax or logic.. but it's not picking up any rows. Which is really stupid because i used my phpmyadmin and i ran this SQL Query there and even then i got my results.. --- Chris Hayes [EMAIL

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

Hello, Rahul.Brenda [EMAIL PROTECTED] wrote: Ok i tried this.. and i didn't get any error listed.. so it seems that the mySQL Query is not failing in syntax or logic.. but it's not picking up any rows. Which is really stupid because i used my phpmyadmin and i ran this SQL Query there and

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

At 13:37 9-3-2003, you wrote: if ($myrow = mysql_fetch_array($result)) { do { echo( $myrow[title] ); } while ($myrow = mysql_fetch_array($result)); } PS same result with while ($myrow = mysql_fetch_array($result)); { echo $myrow['title']; } -- PHP General Mailing List

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

On Sun, 9 Mar 2003 04:37:47 -0800 (PST), Rahul.Brenda [EMAIL PROTECTED] 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

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

Hi, So, you still have a blank page? Yes i do actually, and blank in HTML Source too. do you have display_errors = On in your php.ini? Ahan.. yes i do. to this: echo $myrow[title]; makes any difference. No actually it didnt. :0( Rahul S. Johari

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

Chris, Thanks a lot.. THIS WORKS! Works brilliantly. All other methods were just failing. Thanks man. // fetch row is faster than fetch_assoc, which is faster than fetch_array // fetch_result might even be a better choice here, though, with only one item... if (!mysql_num_rows($result)) {

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

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

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

Hi, Thanks.. i went through your reply and certainly now i understand the mistake i was making. Quite logical actually, that i hadn't actually selected the title column. But i'm sure i wouldnt' have been able to figure this out myself. And surely, i too try to stay away from Numerical Indexes.