sandari
Members-
Posts
29 -
Joined
-
Last visited
sandari's Achievements
Newbie (1/14)
1
Reputation
-
All fields are correct as are the data types. The code being sent is as follows: update tblClients SET GivenName1='Susanna', GivenName2='Anastasia', PreferredName='Susie', Surname='Barishnakov', DoB='1995-10-25', Gender='Female', PlaceOfBirth='', Address1='', Address2='', Suburb='8836', Phone='', Source='', ReferredBy='', email='', OptOut='0', WrongAddress='0', Campus='2', FirstContact='2012-10-25', Merde='0', Inactive='0', CRN='', AdmissionPack='0', AdmissionProcedure='0', AdmittedBy='', ResidencyContract='0', ContractSigned='0', ContractWitnessed='0, DateContractSigned='0000-00-00', KeyDepositReceived='0', KeyDepositRefunded='0', ReceiptDate='2012-10-25', RefundDate='0000-00-00', PreviousClient='0', PreviousCampus='2', PreviousAdmission='0000-00-00' where (ID='23'); But still I get '> as a response.
-
I have query in PHP as follows: <code> $query="update tblClients SET GivenName1='$GivenName1', GivenName2='$GivenName2', PreferredName='$PreferredName', Surname='$Surname', DoB='$DoB', Gender='$Gender', PlaceOfBirth='$PlaceOfBirth', Address1='$Address1', Address2='$Address2', Suburb='$Suburb_id', Phone='$Phone', Source='$Source', ReferredBy='$ReferredBy', email='$Email', OptOut='$OptOut', WrongAddress='$WrongAddress', Campus='$Campus', FirstContact='$FirstContact', Merde='$Merde', Inactive='$Inactive', CRN='$CRN', AdmissionPack='$AdmissionPack', AdmissionProcedure='$AdmissionProcedure', AdmittedBy='$AdmittedBy', ResidencyContract='$ResidencyContract', ContractSigned='$ContractSigned', ContractWitnessed='$ContractWitnessed, DateContractSigned='$DateContractSigned', KeyDepositReceived='$KeyDepositReceived', KeyDepositRefunded='$KeyDepositRefunded', ReceiptDate='$ReceiptDate', RefundDate='$RefundDate', PreviousClient='$PreviousClient', PreviousCampus='$PreviousCampus', PreviousAdmission='$PreviousAdmission' where (ID='$ClientID');"; </code> The problem is that when I echo the query to the screen, copy it and paste it into the command line of MySQL it returns what looks like: '> Any suggestions?
-
Sorry guys but I am having trouble posting the screen shots. Anyway, when using the command line the first screen lists all the tables in the database. The table "award" does not show up. The second shows what happens when I try to create the table. It returns: ERROR 1050 (42S01): Table ''mwwg'.'award' already exists''
-
<code> CREATE TABLE IF NOT EXISTS `award` ( `award_id` int(11) NOT NULL AUTO_INCREMENT, `show_year` varchar(6) NOT NULL, `category_id` varchar(10) DEFAULT NULL, `category` varchar(100) DEFAULT NULL, `FirstPrize` varchar(40) DEFAULT NULL, `SecondPrize` varchar(40) DEFAULT NULL, `ThirdPrize` varchar(40) DEFAULT NULL, `FourthPrize` varchar(40) DEFAULT NULL, `HighlyCommended` varchar(40) DEFAULT NULL, PRIMARY KEY (`award_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ; </code> When I run the above command I get the response: "#1050 - Table '`mwwg`.`award`' already exists" If I then run "show tables;" the table "award" does not show up. Any clues??
-
I give up!! What is wrong with this code? while($row = mysqli_fetch_array($result,MYSQLI_ASSOC)){ echo "<tr class=\"data\" align=\"center\" width=\"100%\"> <form action=\"edit_other_medical_problem.php\" method=\"POST\"> <td align=\"center\">{$row['AssessmentDate']}</td> <td align=\"center\">{$row['MedicalProblem']}</td> <td align=\"center\">{$row['TreatmentPlan']}</td> <td align=\"center\">{$row['OtherDetails']}</td> <td align=\"center\"> <input type=\"submit\" name=\"submit\" value=\"Edit\"> <input type=\"hidden\" name=\"MedicalProblemID\" value=\"{$row['ID']}\"> </td> </form>"; echo "<form action=\"delete_other_medical_problem.php\" method=\"POST\"> <td align=\"center\"> <input type=\"submit\" name=\"submit\" value=\"Delete\"> <input type=\"hidden\" name=\"MedicalProblemID\" value=\"{$row['ID']}\"> </td> </form>"; echo "</tr>"; } The "Delete" button works beautifully but the "Edit" button remains on this page instead of opening "edit_other_medical_problem.php". I cannot see the difference.
-
i am sure the logic for this is quite simple. I just cannot see it. My pagination works relly well, too well in fact. I have a file that displays 10 records at a time. However, the pagination dispalys all 1643 page numbers. How do I limit the display to just 3 or 4 page numbers with ellipsis each side after moving beyond the initial 3 or 4 pages?