Jump to content
Larry Ullman's Book Forums


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About briansgl

  • Rank
  1. Just having a snoop through the forum and came across this. I can’t for the life in me understand why Mike thinks someone would want to pry into his personal information for ilisset reasons. We all have access to the internet and if someone wanted to know something about anyone it’s not difficult to find. This forum is brilliant I’ve had a lot of constructive help from Jonathon and Antonio. I’ve put some pretty stupid questions on and Jonathon has not been shy at telling me. I knew nothing before I started here and even now I’m far far far from being an expert but I do have half an idea of wh
  2. When I try and post a new job to the database I am receiving the following error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'description = "test new Form", j_target = "1 Days", salary = "2.50", s_period' at line 11 Here is the PHP Code: <?php include_once "accesscontrol.php"; $ename = $_SESSION[ename]; $q1 = "select plan, JS_number, JP_number from job_employer_info where ename = \"$ename\" "; $r1 = mysql_query($q1) or die(mysql_error()); $a1 = mysql_fetch_array($r1); if(!empty($a1[plan])
  3. Just a question really. I have a basic text area on a form that's coded like below: <tr> <td valign=top><font class="smalltext"><b><strong> Description:</strong></b></font></td> <td><font class="smalltext"> <textarea rows=12 cols=55 name=description></textarea> </font></td> </tr> <tr> What I was wanting to know was can I add some formatting like the user being to make the text bold, change colour, Centre, left, right and justify. You know the normal formatting aids. Is
  4. Thanks Jon and Antonio. I went through the code in word pad and looked at some advice on the internet. After looking at all the possible solutions I discovered that the PagePost should have actually been PagePostArray. Once I figured that out it worked fine. $submit = $_POST[submit]; if ($submit == "Register me") { if ($_POST[upass] == $_POST[cpass]) { $uname = PagePost(uname); $upass = PagePost(upass); $cpass = PagePost(cpass); $title = PagePost(title); $fname = PagePost(fname); $lname = PagePost(lname); $bmonth = PagePost(bmonth); $bday = PagePost(bday
  5. Thanks Jon and Antonio. I'm starting to think this is just getting a little above my skills. I will have to study the code to find out which bits don't relate to the site. I may take a while. I figured out the DB element but then I wouldn't be able to populate the skills area with multi select (Would I?) Jon this is the code I used for the Javascript bit and the relating form: <script type="text/javascript"> function fillSecondCombo() { var combo1 = document.getElementById('JobCategory'); var combo2 = document.getElementById('JobSkills'); var selected = combo1.opti
  6. Thanks Antonio. The site was built originally using code from another site and modifying it. the JobCategory was populated from the database to make it accessible site wide, however it gave checkbox options for JobCategory to make it multi select on the Jobseekers registration page. I wanted to make it more user friendly by adding Job Skills for each category. I managed to work out how to do this using java script and modified the form accordingly. I think modifying the database may be a little beyond my skills, having said that on another site we have counties that reflect the towns withi
  7. I have created a form with a field called JobCategory. I also have a field called JobSkill. The JobSkill is populated based on a selection from the JobCategory using javascript. The Database fields have the same names. The problem i am getting is when I fill in the form i get the message "you must enter a job skill" even though I have done. If i disable the validation for JobSkills the form works and the data is sent to the database. Problem is the JobCategory field in the db is populated but the JobSkills field is empty. Not sure what I'm doing wrong. This is the HTML form script
  8. Thanks Jon. I have managed to make the normal fields sticky: <span style="color:#000000;font-family:Arial;font-size:12px;">First Name:</span></div> <input type="text" id="fname" name="fname" value="<?php if(isset($_POST['fname'])) echo $_POST['fname'];?>"> The Multi Select Box is sorted by: <option>Month</option> <option value="selected="selected"January">January</option> <option value="selected="selected"February">February</option> I also have a Year field and not sure how to do that. The code picks up the year using
  9. I have figured out how to make a form sticky but couldn't make a list box sticky. Could anyone help Code below Thanks <tr> <td bgcolor="#F1F9FB" class=normalboldtext><font size="2" face="Arial, Helvetica, sans-serif"> Title:<font color=red>*</font></font> </td> <td> <font size="2" face="Arial, Helvetica, sans-serif"> <select name=title> <option value=""> </option> <option value="Mr.">Mr. </option> <option value="Mrs.">Mrs. </
  10. I've sort of got the hang of it. Iv'e figured out the JavaScript and also the form knows the user is not logged in (I think) it takes me to the login page when I try and access the page. I just can't seem to put the data in the database. Every time I try everything just disapears off the page including the form. The table name is job_seekers_info and the two columns are job_category and skills. I have added the page and would be grateful of any help. <?php require_once "../conn.php"; include_once "accesscontrol.php"; $uname = $_SESSION[uname]; ?> <script type="text/javascript
  11. Ye I knew the arrays should be in js. I will get the pages done and make sure they work
  12. Thanks Jon. I may need a bit of guidance with this. To start I was thinking of creating a duplicate of the registration form and putting it in a test folder together with the form processor which in this case is jobseeker_registration2.php. I can then remove the relevant industry section from the form and rename the welcome message to read something along the lines of "Thank you for registering on the site. You will shortly receive a welcome email, contained within this email will be a verification link. You must verify your account by clicking on the link to fully register. Once y
  13. I have a registration form on my job-site that I would like to change slightly. Part of the form consists of "Job Category" and "Skills" the skills area is dynamically populated from an item that a user selects from the "Job Category". When they register on the site they are sent a registration email. Contained within the email is a verification link. The user verifies their account and are then able to login. When they login they are then taken to the login screen with the welcome message Dear John welcome back to the site. All pretty normal stuff really, however I have discovered that some j
  14. Not to sure what iv'e done wrong here. If a user tries to upload an invalid file I wanted the site to echo "File format invalid. Valid formats are .pdf, .wks." ect but the site is allowing file uploads of all types but then when I try and access the file I get "Invalid file format" The Function code is: $Query = "SELECT OCTET_LENGTH(attachment) as Size, attachment, attachment_type as ContentType FROM job_seeker_info where uname = '$uname'"; $Result = mysql_query ($Query) or die (mysql_error()); $Row = mysql_fetch_array($Result); $fileType = $Row['ContentType']; if ($fileTy
  • Create New...