PHP error!

[mwinter]

the relationship: the animalName field is a primary key in both the NK_Booking table and the NK_BookingHandler table.

What's the foreign key in NK_Booking, though?

There's something bizarre about all this. If animalName is the primary key for NK_Booking and that's part of the condition, why do you need anything else to select a unique tuple? Is animalName part of a compound key? Are your primary keys not unique (if not, that's a serious flaw)?

Therefore I have tried the following code with an inner join.

A literal JOIN isn't possible in an UPDATE query. That's why I used a scalar subquery: it produces the same effect.

Mike

[djr33]

^told ya someone would know.

Ha

[snowbydave]

Hi Lucie,

Is ur problem solved ? Else check below step & it will defeneatly works.

1. Check animalName, handlerName, startDate all this field exist in NK_Booking table. Also fields names r case sensitive so write as u had written it in mySQL. If possible then copy & paste field name from mySQL to ur PHP page query.

2. Also copy below query & check it.

$sql1 ="UPDATE NK_Booking SET reviewtext = '" . $ownerreview . "' WHERE animalName = '" . $animalname . "', handlerName = '" . $handlername . "',
startDate = '" . $startdate . "'";

3. If this will not solve or solve ur problem then email me on snowbydave1@hotmail.com