Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL select statement/Array help
I found a tutorial on w3schools teaching the logic on the php/ajax database concept. Following this tutorial, enabled what I wanted to work. The issue now is that the second query will only display one entry from my 4th table. Once I select a company from the select drop down menu, the code... -
SQL select statement/Array help
...used for information for one input field Here is my code. <?php $q=$_GET["q"]; include("includes/connection.php"); $company_query = "SELECT * FROM `company` WHERE id = '".$q."' "; $contact_query = "SELECT contact.id FROM `contact` LEFT JOIN `company` on '".$q."' = contact.companyid... -
looking for code/resource for vehicle lookup
SouthBeach: That is correct. I meant table. -
Auto fill form fields via php/mysql/xajax
...$objResponse->assign("selVehYear","innerHTML",$string); return $objResponse; } function vehMake($key) { $sql = 'SELECT * FROM vehicles WHERE vehYear = {$key}'; $dbserver = mysql_connect("localhost","root",""); $query = mysql_query($sql) or die (mysql_error()); $string =... -
looking for code/resource for vehicle lookup
Should the database `vehicles` look like this? +----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI |... -
Display checkbox values
Jedel, If I'm understanding this correctly, if I set the database field type as BOOL, the field would only accept a value of true/false or 0/1. If this is the case, then this change will not work for what I need. Because I need to be able to add multiple values to this one field. Currently I... -
Display array data
Issue resolved with the error message. Found out that the problem was with the data in the table. The code could not read the value "Array". I manually changed the value in the table to the desired value and it removed the error message. I am getting better. That's cool. Now I am really a... -
Display array data
...on line 109" No clue. $events = explode(", ",$eventid); $eventlist = ""; foreach($events as $event){ $sql2 = "SELECT * FROM events WHERE id = $event"; $results = @mysql_query($sql2); ($ev = mysql_fetch_array($results)); $eventlist .=$ev['eventName'] . ", "; } $eventlist... -
-
Display array data
...= htmlspecialchars($sql1['eventid']); $events = explode(", ",$eventid); $eventlist = ""; foreach($events as $event){ $sql2 = "SELECT * FROM events WHERE id = $event"; $results = @mysql_query($sql2); ($ev = mysql_fetch_array($results)); $eventlist .=$ev['eventName'] . ", "... -
Display checkbox values
All: I need to display checkbox values on my edit page, but what I have now displays all checkboxes checked, instead of reading the checkbox values saved in my database table. Here's the code. <div class="row"> <label>Event(s):</label> <?php while ($event =... -
Display array data
...= htmlspecialchars($sql1['eventid']); $events = explode(", ",$eventid); $eventlist = ""; foreach($events as $event){ $sql2 = "SELECT * FROM events WHERE id = $event"; $results = @mysql_query($sql2); ($ev = mysql_fetch_array($results)); $eventlist .=$ev['eventName'] . ", "... -
Display array data
...record with the column name "eventid" filled with comma separated values. I need every array value matched with another table that has its name. *NOTE: An id or record in the contact table can have multiple events. Example: tblContact id = 1, eventid = 1, 2, 3 match with tblEvents id =... -
Auto-fill fields from drop down option
All: This is what I want to happen: 1. When a user would fill out this form, they would first have to choose a company from a select menu preloaded with values. 2. Once the user has made a selection, somehow the form is generated with values from another table in the database based upon this... -
MySQL to MS Access
All - I found this code from another forum and it works with MYSQL and PHP. Could someone help with the conversion of this code for usage in PHP and MS ACCESS? Thanks. MYSQL QUERY TO GET ALL AVAILABLE OPTIONS mysql_select_db($database_siteConn, $siteConn); $query_rsGetfeatures = "SELECT... -
PHP: Display and update radio btn values in MS Access
Ok. Now what's wrong? The Select box will not load any data from my database table. Why? <?php function getOptions('tblMinorGroup', 'ID', 'minorGroupName', 'minorGroup');{ global $conn; //the connection handle $id = $_GET['ID']; $minorGroupName = $_GET['minorGroupName']; if... -
PHP: Display and update radio btn values in MS Access
...and also have the option to change the selection? Here's the code. <?php include("includes/connection.php"); $id = $_GET['id']; $sql="SELECT * FROM tblCompanies WHERE id=$id"; function getOptions(){ $return = ''; $rs=odbc_exec($conn,$sql); while ($row = odbc_fetch_array($rs)){ foreach... -
Soft Delete
...corpAddress1, corpAddress2, city, state, zip, country, officePhone, emailAddress, website, dateCreated, createdBy, dateUpdated, updatedBy) SELECT * FROM tblCompanies WHERE id = $id"; $query[] = "DELETE FROM tblCompanies WHERE id = $id"; /* This line works */ foreach ($query... -
Soft Delete
...include("includes/connection.php"); $id = $_GET[id]; $query1 = "INSERT into tblCompanies1 (SELECT * FROM tblCompanies WHERE id=$id)"; $query2 = "DELETE from tblCompanies WHERE uniqueid = $id"; $sql = ("$query1" . "$query2"); $rs = odbc_exec($conn,$sql); if (!$rs)... -
PHP: Display and update radio btn values in MS Access
Hate to be a pain but this is what I got. The form name is the same as the valuefield name. <?php // create database connection include("includes/connection.php"); $id = $_GET['id']; $query = "UPDATE tblCompanies SET minorGroup = '" . $_GET['minorGroup'] . "' WHERE id = $id"; // Get lists of...
