AndyB
Staff Alumni-
Posts
5,465 -
Joined
-
Last visited
Never
Everything posted by AndyB
-
http://www.tizag.com/mysqlTutorial/mysqlsum.php
-
Not if what you just posted is your current code.
-
mysql_query("CREATE TABLE example( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(30), score INT, ipaddress VARCHAR(30), country VARCHAR(30), date VARCHAR (30)") or die(mysql_error()); That works.
-
select whatever order by time_field_name ASC
-
Is it possible to remove "Powered free by PHPmotion"?
AndyB replied to impossibleisnothing's topic in PHP Coding Help
Looks like theft to me. Thread locked. -
@cowboydude SELECT id, poster, DATE_FORMAT(the_name_of_your_post_date_field, '%b %D, %Y') as displayDate, ... Notice there's no dollar symbol in the name of the posst date field (whatever it's called)
-
What you need to do is: read the 'old content' value add the new content to the old content (or v/v) using the concatenation operator - the dot UPDATE the database table with the concatenated content
-
So, if you know there is 'lots and lots of other stuff' that's incomplete, why are you asking us to torture ourselves? First suggestion: don't insult your visitors with nonsense like "For better gameplay and resolution please download Firefox". Make your stuff work regardless of visitor choices of browser.
-
You need to define the problem to a much greater extent. So - what activity and specific step is your client doing when this error message arises? Once you know exactly what the client was doing when the error arose, you should test exactly that to see whether you get the same problem.
-
Ask your client to define 'not working'. Does s/he mean the login fails? That the site cannot be viewed? That uploading an image fails? Or what, exactly. Since we have no idea what it means, how can we help?
-
If that kind of 'accuracy' is good enough, just use a random number calculator. 'As the crow flies' it's around 500 km. Unless you want to host an enormous database - and then you would only get the point-to-point distance not how far you actually travel - you could use a third-party service to provide the information. http://www.google.com/search?q=distance+between+cities offers lots
-
Enough for me. But support for this site is always welcomed - http://www.phpfreaks.com/page/donations
-
If I can see it, I can take it. That pretty well sums it up. What you could do is add some text to the image - on a background that will make it very tedious to edit - that says something like 'Valid only for June 2007'. I wouldn't display that on my website in August to evidence adherence to an ethics program
-
http://www.positioniseverything.net/explorer/dup-characters.html might give you some insights
-
OK, that illustrates the problem nicely ... but we can't help fix your CSS unless we see your CSS (and maybe the relevant section of html as well). Post what we need between CODE tags, please.
-
No. DATE is specific yyyy-mm-dd. But if you only want year and month (despite your original post) who cares that the day is also stored. Store the date, use whatever you need of it.
-
Possible? Yes. Good idea? Probably not because users may choose a name that already exists (and destroy part of your site), or use illegal character combinations, or choose a MySQL reserved word as a table name. Up to you, though.
-
The only rational field type for storing dates is DATE. Your field names would be date_signup, etc., etc. (just in case you were considering concatenating date_signup and the date). A good method of keeping the date simple is to use gmdate(), i.e. all dates are GMT so you can do comparisons without regard to the user's actual TZ. TZ is best obtained from the user via a dropdown select in the data input form.
-
... order by comments, views desc ... ought to do it
-
Without seeing a single line of code or a specific reference to which of the DD scripts you use, that's making life difficult. I bet that the DD script can be customised to show however many images you want ... that just leaves the problem of counting them. How you accomplish that rather depends on a number of things. Alternatively, upload a few 'placeholder' images of your own to (each) user folder and name them pic1 ... pic10 so there are always no 'missing' images.
-
http://ca.php.net/manual/en/function.number-format.php
-
Whatever line 47 is. That's because ... the variable named title is undefined. It needs to exist before you can operate on it.
-
Change if(isset($_POST['Submit'])) { to if(isset($_POST['Submit_x'])) { The way compliant browsers treat submit images is that they pass the x and y co-ordinates of where the image was clicked relative to its upper left corner - exactly how image maps are supposed to work. 'Submit' is never set, 'Submit_x' and 'Submit_y' will each be set.
-
http://ca.php.net/manual/en/function.show-source.php might help