[PHP-DB] Automatically +1 every 30 mins to a value in the database.

2006-06-02 Thread Alex Major
Hi there. I've posted this up on both this list, and the mysql list as I'm not sure whether this is something that I'd need to do with the php or mysql. Basically, I am making an add-on to my small website which is a mini online game. Every user will have gold, and every 30mins I'd like their

[PHP-DB] Displaying results from a query properly.

2006-03-24 Thread Alex Major
Hi there. This isn't a major problem, more of a matter of aesthetics. Basically, I have a query which pulls a list of usernames from the database (based on their user level). These users should then listed in this fashion. Administrators: allydm, alex, mike, dave Moderators: big 'd', frank,

Re: [PHP-DB] Displaying results from a query properly.

2006-03-24 Thread Alex Major
{ $sHTML .= ''.$administrators['username'].', ';} while ($administrators = mysql_fetch_assoc($administrators_result)) $sHTML = substr($sHTML, 0, strlen($sHTML)-1); echo $sHTML; ? Bastien From: Alex Major [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Displaying

[PHP-DB] Problem with a login page.

2006-03-06 Thread Alex Major
Hi there everyone, just wondered if you could help me with this login scipt. I've tried to customise a script that I found on a website, but it dosn't seem to be working. Here is the scipt that isn't working. ?php // database connect script. require 'includes/connection.php'; require

[PHP-DB] Tracking Site Version

2006-02-23 Thread Alex Major
Hi there, I'm currently working on my website which is now live, and was wondering how some of you more experienced web developers record site developments if you do. I'm thinking of perhaps creating a page on the site where I record the site version, and changes made during the update. Just

[PHP-DB] Displaying Unix Timestamps as human readable dates / times?

2006-02-15 Thread Alex Major
Hi there. I am currently intergrating a vbulletin forum with my website, and am now merging the two databases together. On the vbulletin database all times/dates are stored as a unix timestamp, but in the past I've always stored mine as 21/3/2006 (for example.) I am now trying to get these unix

[PHP-DB] Formatting a form box

2006-01-12 Thread Alex Major
Hi there, On one of my forms, there is a section where users can put images etc..and then it is displayed on my php pages. My question is how do I make it so that the html formatting is automatically done. For example when someone is typing something, and wants to start a new paragraph although

Re: [PHP-DB] Formatting a form box

2006-01-12 Thread Alex Major
($_POST['testarea']); } ? Look at the source code after you submit if you have any doubts/questions. -TG = = = Original message = = = use the nl2br() function to convert the newlines to br bastien From: Alex Major [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB

Re: [PHP-DB] Re: Subject: Scrolling News

2005-12-23 Thread Alex Major
, you wrote: Date: Thu, 22 Dec 2005 20:38:58 + From: Alex Major [EMAIL PROTECTED] To: php-db@lists.php.net Message-ID: [EMAIL PROTECTED] Mime-version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7bit Subject: Scrolling News Hi there. I'm trying

[PHP-DB] Scrolling News

2005-12-22 Thread Alex Major
Hi there. I'm trying to make a scrolling news box for my website. Basically I would like this news box to get information from a column in my database called 'news_title' and display it in a scrolling news box. The reason I'd like it to do this is because there is already a news page on my

Re: [PHP-DB] Scrolling News

2005-12-22 Thread Alex Major
Sounds great, I'll start looking for a scroller on google. Anyone have any recommendations while I'm searching? Regards, Alex On 22/12/05 21:22, John Meyer [EMAIL PROTECTED] wrote: On Thursday 22 December 2005 1:38 pm, Alex Major wrote: Hi there. I'm trying to make a scrolling news box