No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
I need to update multiple records in a single form but am not sure how to proceed. The following is the code I am using to insert the fields into the database originally. [CODE]$case = date(ymdHis); //register into database if (!empty($p1_firstname)) mysql_query ("INSERT INTO cases VALUES ('$case','$date_booked','$p1_firstname','$p1_lastname ''$city’)"); if (!empty($p2_firstname)) … | |
I am trying to create a function that onkeydown(), forces all letters to be capitalized after a comma (",") in a text input field. I know that I can make all of the letters capital using this function: [CODE]function makeUppercase(field) { field.value = field.value.toUpperCase(); } <input type="text" name="city_pairs" id="city_pairs" onblur="makeUppercase(this);" … | |
When executing the code below, I am getting the error: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given. From my understanding this would imply that mysql_query is returning false meaning the query is failing but I am not sure why.. Any ideas? [CODE]<?php include 'global.php'; $case=$_GET['case']; $query=" SELECT … | |
Using javascript, a field in an html form is formatted for time. When the user types in 344, the field formats onblur to 3:44. This field is then echoed in PHP an appears properly formatted. However, in the MySQL database it is inserted into, it appears as only "3". Everything … | |
This is currently the code I am using: [CODE]<?php //connect to database include 'global.php'; $case = date(ymdHis); //get form data $p1_firstname = addslashes(strip_tags($_POST['p1_firstname'])); $p1_lastname = addslashes(strip_tags($_POST['p1_lastname'])); $p2_firstname = addslashes(strip_tags($_POST['p2_firstname'])); $p2_lastname = addslashes(strip_tags($_POST['p2_lastname'])); $p3_firstname = addslashes(strip_tags($_POST['p3_firstname'])); $p3_lastname = addslashes(strip_tags($_POST['p3_lastname'])); $city = addslashes(strip_tags($_POST['city'])); //register into database $register_case = mysql_query ("INSERT INTO cases … | |
I have an input form in which the user fills in several fields. I want to display the contents of these fields on a page right after the user hits submit. I am not sure how to call the last entered record. Also, to further complicate the issue, there is … |