User Profile

Collapse

Profile Sidebar

Collapse
Tormod
Tormod
Last Activity: Jul 12 '07, 10:37 PM
Joined: Feb 25 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Tormod
    replied to Increment Buttons
    in PHP
    Awesome. I'll have a look at the above solution and try and amend it to fit my needs. I'll get back to you and let you know how I get on.

    Sincere thanks to all who have taken the time to look at this.
    See more | Go to post

      Leave a comment:

    • Tormod
      replied to Increment Buttons
      in PHP
      Ideally to save it right away. So that all the data in the database reflects what's showing on the users screen.
      See more | Go to post

        Leave a comment:

      • Tormod
        started a topic Increment Buttons
        in PHP

        Increment Buttons

        Hi there,

        I realise this may sound elementary but I'm left scratching my head.

        I'm trying to create a page in php with several values displayed on the page and a button next to each value which will increment the value by 1 and then ultimately save the values to the database.

        I've played around with the submit button and my variables but I can't get it to work. I realise it's a bit cheeky to ask for help...
        See more | Go to post
        • Tormod
          replied to Date Formatting mysql->php
          in PHP
          What, you mean without the DATE_FORMAT function embedded in the query? It definitely works like that.
          See more | Go to post

            Leave a comment:

          • Tormod
            replied to Date Formatting mysql->php
            in PHP
            Tried it. Still not working. It's not even giving me the firstname & lastname column in my table which suggests to me that the query line is causing the script to bomb somehow.

            I appreciate all your efforts on this by the way.
            See more | Go to post

              Leave a comment:

            • Tormod
              replied to Date Formatting mysql->php
              in PHP
              I tried it but it's just not having any of it. The page doesn't crash but the table isn't displayed at all. I think it's something in the syntax of the query as I've tried commenting bits of the code out and that line appears to be the stumbling block.

              Here's the code I'm trying...


              Code:
              #list all players
	#connect to mysql
	$conn=@mysql_connect( "host", "username", "password"
              ...
              See more | Go to post

                Leave a comment:

              • Tormod
                replied to Date Formatting mysql->php
                in PHP
                Thanks mate. That's fixed it.

                I had tried using the DATE_FORMAT function and I thought I was getting pretty close at one stage but to no avail. If anyone can point out where I'm going wrong I'd be much obliged.

                Heres what I'm trying to get working...

                Code:
                $sql="SELECT playerid, firstname, lastname, DATE_FORMAT(DOB, '%d-%m-%Y') FROM player order by surname";
                See more | Go to post

                  Leave a comment:

                • Tormod
                  started a topic Date Formatting mysql->php
                  in PHP

                  Date Formatting mysql->php

                  I'm having problems formatting a date retrieved from mysql database. When I retrieve the date it's in the format YYYY-MM-DD. I need to split the Day, Month and Year portions of the date up so that I can represent them in a drop down menu.

                  I've posted my source code below, such as it is. I need a function of some kind to allow me to manipulate the $row["DOB"].

                  Code:
                  	#connect to mysql
	$conn = @mysql_connect(
                  ...
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...