[PHP] Calling all values of variables into one variable

What the following script does is that it gives a result of 4 rows, from the database, and generates 4 variables (newsbits0, newsbits1, newsbits2, newsbits3), and inserts result data into each of these variables. What i want is a final 5th variable which contains all the data of the first 4 varia

[PHP] Calling Multi-Row Result PHP Variable in Flash

Hi, I used a script to generate some result from a database, which i want to display in flash. In Flash, i created the Dynamic Text and declared "newsbits" as Vars, and set it to Multiline. I also loaded the PHP variables with the following command in the ActionScript of the Frame : loadVariables

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.

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($resul

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

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

[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? Rahul S. Joha

Re: [PHP] Displaying few words from record in mySQL [WORKS]

Chris.. 2 words for you.. "WOW" and "WOW". This works real well.. thanks. I didn't know it was possible through an SQL statement. Nik & Kevin, thanks a lot .. but this SQL Query works too efficiently and fast. Thanks again.. Rahul S. Johari > Make mysql do the work for you. > > select sub

Re: [PHP] Displaying few words from record in mySQL

Kevin, Your program certainly makes very good sense to me. However, 2 things i will need to ask you.. is that, let's say i decide i want the first 4 words from the record displayed.. for all the 4 rows i'm displaying.. where do i define that in your program? And secondly, how do i make this progr

[PHP] Displaying few words from record in mySQL

Glory & Supreme Power What i'm looking to do is.. i want to display only the first few words of the record in my mySQL database.. For example.. i have a table with a field "title".. and let's say my last record has the value in title field as "This is going to be really cool" What i want to