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

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

2006-03-24 Thread Alex Major
a at the end of the loop > > do { $sHTML .= ''.$administrators['username'].', ';} > while ($administrators = mysql_fetch_assoc($administrators_result)) > > $sHTML = substr($sHTML, 0, strlen($sHTML)-1); > > echo $sHTML; > > ?> >

[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, will

[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. Login Logged in Welcome back , you are logged in. Login Username: Password:

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

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

Re: [PHP-DB] Formatting a form box

2006-01-12 Thread Alex Major
x27;])) { > > echo nl2br($_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 >

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

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

2005-12-23 Thread Alex Major
20 Error: Expected "9" And also "A runtime error has occurred. Do you wish to Debug, Line: 36 Error: 'scroller1' is undefined. Any help on this issue is greatly appriciated. Regards, Alex On 23/12/05 11:16, "Neil Smith [MVP, Digital media]" <[EMAIL PROTECTED]>

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. >

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