Re: [PHP-DB] Select distinct field won't return distinct value

I thank you all. problem solved using two queries as TQ mentioned. On 6/6/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Correct me if I'm wrong, but it sounds like you have something like this: 123 Joe 124 Joe 125 Sue 126 John 127 Joe 128 Frank 129 Sue And you want to output somethi

[PHP-DB] Select distinct field won't return distinct value

I want select distinct field and return value of that field, but I have problem which is: select distinct returns duplicate value. eg, I wan select distinct customer name and id from the customer table. one customer may have different cus_ids since cus_ids are auto increment and depend on the purc

[PHP-DB] Need a Help!

I have table and insert data using song_id, that means one artist can have many song_ids. my question is how can I query distinct artist with his/her song_id while I will not get duplicate data like duplicate artist? my code is like this $content .=" Select Artist"; $result= $db->sql_

Re: [PHP-DB] problem of retrieving urls from mysql

elps. > > > Edward Gray > Web Development Team > University of Mary Washington > 540-654-1564 > > >>> "Bastien Koert" <[EMAIL PROTECTED]> 12/06/05 1:44 PM >>> > $url = str_replace("www.mydomain.com","",$url) > > bast

[PHP-DB] problem of retrieving urls from mysql

I would like to store and retrieve urls, but I have problem which is I get my url + the other url, Instead I should get another url only $temp = linkurl; echo "$temp"; the echo prints something like this http://www.mydomain.com/www.otherlink.com so I wan get rid off my url and get only other lin

[PHP-DB] problem of transmitting variable from page to another page.

I am transmitting variable from one of my pages and I would like to match that variable into mysql data. it won't return data. my code is this. $j |"; if ($j == Z) { break; } } ?> this code in my index page prints alphabetical letters from A-Z. and I woul like to transmit that variable i

[PHP-DB] problem of transmiting variabl into another page?

I am transmitting variable from one of my pages and I would like to match that variable into mysql data. it won't return data. my code is this. $j |"; if ($j == Z) { break; } } ?> this code in my index page prints alphabetical letters from A-Z. and I woul like to transmit that variable in

[PHP-DB] php upload

I heard that the maximum file size which php can upload is setted to 2MB, so is it a possible to reset the maximum_file_size to a larger bytes and if it is possible how can I achieve that?

Re: [PHP-DB] Can't Upload ram file

here is the code File uploaded"; } ?> On 11/18/05, Bastien Koert <[EMAIL PROTECTED]> wrote: > > show code, maybe checks are being done to only allow images or certain > extensions... > > > Bastien > > > >From: Mohamed Yusuf <[EMAIL PROTECTED]&g

Re: [PHP-DB] Can't Upload ram file

File uploaded"; } ?> On 11/18/05, Bastien Koert <[EMAIL PROTECTED]> wrote: > > show code, maybe checks are being done to only allow images or certain > extensions... > > > Bastien > > > >From: Mohamed Yusuf <[EMAIL PROTECTED]> > >To: ph

[PHP-DB] Can't Upload ram file

the script I am using can upload images like, jpg, gif or png to the server, but it can't upload music file to the server like ram and rm. any help?

Re: [PHP-DB] Problem of Upload media file

Many thanks for your help. it works. On 11/17/05, Micah Stevens <[EMAIL PROTECTED]> wrote: > > > No. It's not okay.. you're already in the music directory.. if you want it > in > the media subdir, just put 'media/' > > > > On Thursday 17 Novem

Re: [PHP-DB] Problem of Upload media file

t? On 11/17/05, Micah Stevens <[EMAIL PROTECTED]> wrote: > > > > Well, the error doesn't match the code, but the code says to upload the > file > to: > > /home/somally/public_html/music/www/media/ > > Is that correct? > > > On Thursday 17 November 20

Re: [PHP-DB] Problem of Upload media file

ficant whitespace > in > your code, sometimes it can get screwey. Look for your move_uploaded_file > statement. > > -Micah > > > On Thursday 17 November 2005 8:58 am, Mohamed Yusuf wrote: > > I am trying to upload music file to server using php and saving file > path >

Re: [PHP-DB] Problem of Upload media file

the permissions are right, I mean they are all setted to 777. On 11/17/05, Bastien Koert <[EMAIL PROTECTED]> wrote: > > Check your permissions on the folder...you may need to make them 777 to > allow read/write by all for the upload > > Bastien > > > >From

[PHP-DB] Problem of Upload media file

I am trying to upload music file to server using php and saving file path to the MySql, But I am getting this error message "*Warning*: move_uploaded_file(music/media/): failed to open stream: No such file or directory in */home/somally/public_html/music/upload2.php* on line *36*". line 36 is refe

[PHP-DB] text with html tags apeared in text area.

hi I have php form. one of my textarea gets data with html tags from database, so I would like to remove those html tags like , therefore is there anyway that i can remove those tags in the data and then the data can appear as text in the textarea.