edit profile php

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: edit profile php

Post by Celauran »

No. You're going to need four separate queries; one to update users and one for each row of renewal that needs updating. The where clause is going to be different for each.
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: edit profile php

Post by Celauran »

No joins required. One update on users table, three on renewals table (one for each item)
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: edit profile php

Post by Celauran »

Code: Select all

$query = "Update users SET name='$name', email='$email', address1='$address1', address2='$address2', town='$town', county='$county', postcode='$postcode', telnumber='$telnumber', mobnumber='$mobnumber', model='$model', numplate='$numplate' WHERE id='$id';";

$sql = "UPDATE renewal SET id='$id', renewal_date='$insurance' WHERE item_id=1 LIMIT 1;";

$sql = "UPDATE renewal SET id='$id', renewal_date='$mot' WHERE item_id=2 LIMIT 1;";
These three queries never get executed.
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: edit profile php

Post by Celauran »

Code: Select all

$sql = "UPDATE renewal SET id='$id', renewal_date='$insurance' WHERE item_id=1 LIMIT 1;";

$sql = "UPDATE renewal SET id='$id', renewal_date='$mot' WHERE item_id=2 LIMIT 1;";

$sql = "UPDATE renewal SET id='$id', renewal_date='$tax' WHERE item_id=3 LIMIT 1;";
The ID for these is already set, so you probably don't want to change that. What you'd want to do is add the ID to your where clause so you can ensure you're updating the record belonging to the correct user.
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: edit profile php

Post by Celauran »

it leaves the tax date empty
Have you checked the value of $tax before executing the query? Does it contain a value? Is it formatted correctly?
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: edit profile php

Post by Celauran »

Code: Select all

$sql2 = "UPDATE renewal SET renewal_date='$insurance' WHERE item_id=1 LIMIT 1;";

$query2 = mysqli_query($db, $sql2) or die (mysqli_error($db));

$sql3 = "UPDATE renewal SET renewal_date='$mot' WHERE item_id=2 LIMIT 1;";

$query3 = mysqli_query($db, $sql3) or die (mysqli_error($db));

$sql4 = "UPDATE renewal SET renewal_date='$tax' WHERE item_id=3 LIMIT 1;";

$query4 = mysqli_query($db, $sql4) or die (mysqli_error($db));
This will come back to bite you when you have more than one user.
Post Reply