[PHP-DB] Data input

2001-02-21 Thread Matthew Cothier
I have set up a database so that users can submit news to my website. The only problem is they input their news article into the database through a form but it comes out as a continuous string of text. (a) shows what it looks like now, and (b) shows how its supposed to look. How can they input

[PHP-DB] nl2br()

2001-02-21 Thread Matthew Cothier
Where exactly do I need to insert this? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

[PHP-DB] cookies, email and passwords

2001-02-25 Thread Matthew Cothier
Sorry for putting three topics in one but they all go together so I thought I would. I am setting up a user login/members area! * Firstly how do I generate a random password? * Then how do I email it to the user? * And now I need to know how to set a cookie with their username and password s

[PHP-DB] cookies, email and passwords

2001-02-25 Thread Matthew Cothier
Thanks! Is there anyone who can actually give me little bits of code that I need cause I am in a rush with this _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing L

[PHP-DB] Resolution detect and redirect

2001-02-27 Thread Matthew Cothier
I am lookign for a piece of code that will detect the resolution of the user and return a page dependant on that i.e - The table will be adjusted to suit that. Is there a script where I can detect what the resolution is, and also redirect to a page depending on what resolution they are using?

RE: [PHP-DB] Resolution detect and redirect

2001-02-27 Thread Matthew Cothier
>Why not just create a table that will resize to any resolution? Because I am using different sized images for the different resolutions as well as other page thingys. And I need the script for other things too. So can anyone help? __

[PHP-DB] Sorting alphabetically

2001-02-27 Thread Matthew Cothier
Thanks everyone for helping me with the resolution problems, its sorted now! Q. How do I sort a list of names onto a page into a table in alphabetical order? I am doing a link database and require that I have a list of catagorie names in alphabetical order with the links listed alphabetically

[PHP-DB] Sorting alphabetically and Tv guide

2001-02-27 Thread Matthew Cothier
Thanks! The other thing that I have been asked to design is an online tv guide for a list of shows. Basically I want to be able to display a list of programmes on the front page for the current date in time order. Can this be done in the same way as alphabetical ordering? I will also have a s

[PHP-DB] Selecting number of news items on frontpage

2001-02-28 Thread Matthew Cothier
I have a homepage which has a news headline system. Bascially via form the admin of the site can submit news which appears on the front page, the only problem is the news just keeps coming and I have a front page with too many headlines on. How can I make it so that say 7 articles appear on th

Re: [PHP-DB] Selecting number of news items on frontpage

2001-02-28 Thread Matthew Cothier
>From: [EMAIL PROTECTED] (Miles Thompson) >To: [EMAIL PROTECTED],[EMAIL PROTECTED] >Subject: Re: [PHP-DB] Selecting number of news items on frontpage >Date: Wed, 28 Feb 2001 17:06:07 -0400 > >Matthew, > >Do you want to be told how, or want to read an interesting article on just >this, including

[PHP-DB] Drop down box

2001-03-01 Thread Matthew Cothier
How do I get my select form to select a value for $num_view and refesh the page? SELECT * FROM table_name ORDER BY n_id DESC LIMIT $num_view I now need a dropdown box that has set values for 5,10,15 and 20 so that the user can select a number of news articles to view and it will refresh the p

RE: [PHP-DB] Drop down box

2001-03-01 Thread Matthew Cothier
>From: Ben Cairns <[EMAIL PROTECTED]> >To: php-db <[EMAIL PROTECTED]> >Subject: RE: [PHP-DB] Drop down box >Date: Thu, 1 Mar 2001 14:06:21 + > >Hope this helps > >-- Ben Cairns - Head Of Technical Operations >intasept.COM >Tel: 01332 365333 >Fax: 01332 346010 >E-Mail: [EMAIL PROTECTED] >Web

Re: [PHP-DB] Drop down box [Help!]

2001-03-01 Thread Matthew Cothier
Here is my code: --- Time Channel Summary Select Date : $current_date\n"); ?> $row[3]\n"); $id++; } } ?> \n"); print("\n"); print("$row[1]$row[2]$row[4]\n"); print("$row[12] (0$row[10]:0$row[11])$row[13]\n"); print("Starring :Shannen Doher

[PHP-DB] Bad Gateway Errors

2001-03-11 Thread Matthew Cothier
Is there anyway of reducing bad gateway errors on my mysql messageboard, members are starting to get really irritated by it? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Maili

[PHP-DB] Bad Gateway Errors

2001-03-11 Thread Matthew Cothier
Is there anyway of reducing bad gateway errors on my mysql messageboard, members are starting to get really irritated by it? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Maili

[PHP-DB] A question - ($file_exists)

2001-03-27 Thread Matthew Cothier
I am setting up an episode guide for one of my favourite shows and with this I need to include three screenshots: episodeID_a.jpg episodeID_b.jpg episodeID_c.jpg In some cases though the files will not exist and therefore I need too check if they exist and if they don't then it will display a

Re: [PHP-DB] A question - ($file_exists)

2001-03-27 Thread Matthew Cothier
Why isn't this working? "); } else { print(""); }//end if }//end for loop ?> _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscr

[PHP-DB] Moving database info?

2001-04-14 Thread Matthew Cothier
Does anyone know how I can move tables from one database to another using phpmyadmin? Please help, thanks! _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://

[PHP-DB] Subtracting times?

2001-06-23 Thread Matthew Cothier
I really need help here. What I am trying to do is the following. - $today = date("m.d.y"); $time = date("g:i a"); if($row[3] == $today){ if(($row[4] < $time) and ($time < $row[6])){ print("Now Showing"); } else { print("Today at $row[4]");

[PHP-DB] HELP!! - Search

2001-07-24 Thread Matthew Cothier
Whats wrong with this?? Its not working... >>Search.php Could not get record."; } if(mysql_num_rows($result)) { $uid = 1; while($row = mysql_fetch_row($result)) { print("$row[1]$row[2]"); $uid++; } } ?> >>Search Boolean file I was told to use ## I don't even get these i