Search:

Thank you everyone for your help. Problem has been solved!

I believe the issue was caused by PHP Bug #18251 which causes lost variables from post action. Further down in the code where the...

Okay, I've manage to identify where the problem is happening. When I echo out the $taskid variable above the
if (isset($_POST['submit'])) { to check if the form is submitted, the correct ID is...

Sorry if it's a bit vague currently, to provide a better idea about the problem I am posting the code (ommitting unnecessary and unrelated html and php).

Please let me know if you spot any...

I can confirm if I hard code the values in the query executes correctly.

For instance if I run the following query:

$updatelist = "UPDATE list SET name='".$_POST['name']."' WHERE taskid = '1'";...

Thanks for all the replies, they've been massively helpful. Just to confirm I've tried declaring the variable directly before the update statement, but it doesn't get the value:



$taskid =...

I'm using $_GET to grab an id from the URL and then storing this in a variable called $taskid like so:

$taskid = $_GET['id'];

This works fine, however earlier in my code I have an UPDATE SQL...

Thank you very much, you're a life saver, that's exactly what I'm looking for!

Thank's alot for your help, this works a treat at resizing the image.

However, how can I then save the scaled image so that it can be used instead of the original one that was uploaded?

Hello all,

I have created a fairly simple script that accompanies a form enabling a user to upload an image to my website. The problem I have is I want to scale the image on upload so that it is...

Hello all,

I have created a fairly simple script that accompanies a form enabling a user to upload an image to my website. This works fine.

The problem I have is I want to scale the image on...

Thank's for all of your feedback Mindzai, it's really useful. I think I'm sorted now, just in the process of implementing all of the changes that you suggested! :)

Hi again, thank's for continuing to help, here is the full code:



<?php
include("scripts/dbconnection.php"); //start database connection

//checks cookies to make sure they are logged in...

Thank's for your helpful response, I've tried placing the $userid variable in a function and calling it but the value that is sent is still null.

If on the other hand I specify a value above the...

First off apologies for not enabling error reporting, I posted before I read your post, next time I will use the quote tags to properly format the code.

Thank's for helping out, do you know how I...

Okay, here is the full code:

<?php
include("scripts/dbconnection.php"); //start database connection

//checks cookies to make sure they are logged in
if(isset($_COOKIE['ID_my_site']))
{...

userid is indeed an int.

I tried your suggestion '$query = "INSERT INTO rota (userid, person) VALUES (".$userid.", '".db_escape($_POST['person'])."')";'

but it returned an SQL error:

An...

Thanks to all of you for your replies.

Before the query, I gather the value of the user id, when I echo it, the correct value of 65 is returned. This code is as follows:

$useridquery = "SELECT...

sorry, I meant to say var_dump returns NULL Any ideas?

Thanks alot!

Sam

Hi again,

Many thanks for your reply!

It returns the following:

65NULL

Hello all,

I have an integer stored in a variable named $userid and am trying to insert it in to a MySQL database.

I have been trying to use the following query:

$query = "INSERT INTO rota...

Thank's for getting back to me.

The only thing is, each image is a different part of a cleaning rota which will need to be scheduled to change on a particular day in the week.

Is it not...

I do indeed, there are four images in total and I would like the image to change every Sunday. The first week of each month I would like image 1 to show, the second week, image 2 to show, the third...

Hello all,

I need to write a script that changes an image once a week on the same day every week (for instance, every sunday).

So far I have written code that changes the image on the correct...