[PHP-DB] HELP!! - Search

2001-07-24 Thread Matthew Cothier
Whats wrong with this?? Its not working... Search.php ?php include(search_bool.inc); ? ?php $connection = mysql_connect($host,$dbusername,$dbpassword) or die (Cannot connect to server.); $db = mysql_select_db($dbname, $connection) or die (Could not select database.); $sqlstring = SELECT

[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] 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

[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? ?php $img[] = "$episodeID_a.jpg"; $img[] = "$episodeID_b.jpg"; $img[] = "$episodeID_c.jpg"; for ($x=0; $xcount($img); $x++) { if(!file_exists($img[$x])) { print("td align=centerimg src=\"blank.gif\" width=160 height=120 border=\"1\"/td"); } else {

[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

[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

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:

[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

[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] 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

[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

[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

[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