Search found 6 matches

by trying2use
Tue Jan 11, 2011 4:41 pm
Forum: PHP - Code
Topic: PDO mysql multi update need help
Replies: 9
Views: 500

Re: PDO mysql multi update need help

I'm done with this code went to something else
Thanks for trying
by trying2use
Mon Jan 10, 2011 11:48 pm
Forum: PHP - Code
Topic: PDO mysql multi update need help
Replies: 9
Views: 500

Re: PDO mysql multi update need help

still can not get it to work :crazy:
by trying2use
Mon Jan 10, 2011 8:15 am
Forum: PHP - Code
Topic: PDO mysql multi update need help
Replies: 9
Views: 500

Re: PDO mysql multi update need help

I've tried $stmt = $db->prepare("UPDATE `$tbl_name` SET `name`=:name WHERE id=:id");
$stmt = $db->prepare("UPDATE `$tbl_name` SET `lastname`=:lastname WHERE id=:id");
but got Invalid parameter number: number of bound variables does not match number of tokens :banghead:
by trying2use
Sun Jan 09, 2011 10:11 pm
Forum: PHP - Code
Topic: PDO mysql multi update need help
Replies: 9
Views: 500

Re: PDO mysql multi update need help

I inserted the comma now I'm getting a notice Array to string conversion in line 15
how do I post lastname I can update name but lastname erases and does not update
seems like I missing a post but i don't know how to do that.
Thanks
by trying2use
Sat Jan 08, 2011 9:48 am
Forum: PHP - Code
Topic: PDO mysql multi update need help
Replies: 9
Views: 500

Re: PDO mysql multi update need help

When I try <?php $stmt = $db->prepare("UPDATE `$tbl_name` SET `name`=:name, `lastname`=:lastname WHERE id=:id"); ?> I get Undefined index: lastname I've tried the code below but nothing updates <?php $host = "localhost"; // Host name $username = "username"; // Mysql use...
by trying2use
Thu Jan 06, 2011 11:11 pm
Forum: PHP - Code
Topic: PDO mysql multi update need help
Replies: 9
Views: 500

PDO mysql multi update need help

I can update name but how do I update lastname from the input statement below? I have multiple row in mysql table need help with the code Please HELP!!! Thanks alot in advance <?php $host = "localhost"; // Host name $username = "username"; // Mysql username $password = "&quo...