Blarg1988

nobody?

hey guys, i hope that somebody can help me! as the forum-title says, i got some problems with updating a enum-field in my db. what i have so far: i managed to filter all enum-elements from my db to a dropdown menu on my php-site. those enum-fields are 'new','awaitingcustomer','closed' what i want now: i can choose between those enum-fields in the dropdown-menu. default is 'new' i'd like now: when i select 'closed' that the db-field updates to 'closed' i hope thats clearly understandably. If not, i can certainly post my script. Greetings, Blarg

FYI looks like this now: echo "<tr>"; echo '<td scope="col"> ' .$row['ticket_id']. "</td>"; echo '<td scope="col"> ' .$row['timestamp']. "</td>"; echo '<td scope="col"> ' .$row['status']. "</td>"; echo '<td scope="col"> ' .$row['title']. "</td>"; echo '<td scope="col"> ' .$row['priority']. " </td>"; echo '<a href="ticketdetails.php='.$row['ticket_id'].'">show Calldetails!</a>'; echo '</tr></br>'; How can i bring them into defined tables?

alright then, but what to fill in the table tags with? this: <center><table width="647" height="26" border="1"> <tr> <th scope="col"><?php $ticket['ticket_id'];?></th> <th scope="col"><?php $_SESSION['SESS_TIME_STAMP']?></th> <th scope="col"><?php $_SESSION['SESS_STATUS']?></th> <th scope="col"><?php $_SESSION['SESS_TEXT_MSG']?></th> <th scope="col"><?php $_SESSION['SESS_PRIO']?></th> </tr> </table></center> to: ??? i'm really sorry for being so annoying, i'm very willing to learn ;-)

something like that ? $qry="SELECT * FROM newticket"; $result=mysql_query($qry); if($result && mysql_num_rows($result)) { // if $result != equal any false value & > 0 rows were found while($row = mysql_fetch_assoc($result)) { // loop until the last row session_regenerate_id(); $ticket = mysql_fetch_assoc($result); $_SESSION['SESS_TICKET_ID'] = $ticket['ticket_id']; $_SESSION['SESS_FIRST_NAME'] = $ticket['fname']; $_SESSION['SESS_LAST_NAME'] = $ticket['lname']; $_SESSION['SESS_TEL'] = $ticket['tel']; $_SESSION['SESS_EMAIL'] = $ticket['email']; $_SESSION['SESS_TEXT_MSG'] = $ticket['title']; $_SESSION['SESS_BESCHR_MSG'] = $ticket['description']; $_SESSION['SESS_PRIO'] = $ticket['priority']; $_SESSION['SESS_TIME_STAMP'] = $ticket['timestamp']; $_SESSION['SESS_STATUS'] = $ticket['status']; session_write_close(); <center><table width="647" height="26" border="1"> <tr> <th scope="col"><?php $ticket['ticket_id'];?></th> <th scope="col"><?php $_SESSION['SESS_TIME_STAMP']?></th> <th scope="col"><?php $_SESSION['SESS_STATUS']?></th> <th scope="col"><?php $_SESSION['SESS_TEXT_MSG']?></th> <th scope="col"><?php $_SESSION['SESS_PRIO']?></th> </tr> </table></center> //<td>..</td> } }

anyone knows any other solution? i'd be really grateful

thanks for the translation and for your hint! what do i need to fill in between <td></td>? The table how the tickets are shown in this overview?

alright then: There you go: <?php session_start(); require_once 'connect.php'; //require 'ticket_new_exec.php'; ?> <?php /*$fname = clean($_POST['fname']); $lname = clean($_POST['lname']); $email = clean($_POST['email']); $tel = clean($_POST['telefon']); $prio = clean($_POST['priority']); $betreff = clean($_POST['betreff']); $beschreibung = clean($_POST['beschreibung']);*/ //Create query $qry="SELECT * FROM newticket"; $result=mysql_query($qry); //Check whether the query was successful or not if($result) { if(mysql_num_rows($result) == 1) { //Ticket session_regenerate_id(); $ticket = mysql_fetch_assoc($result); $_SESSION['SESS_TICKET_ID'] = $ticket['ticket_id']; $_SESSION['SESS_FIRST_NAME'] = $ticket['fname']; $_SESSION['SESS_LAST_NAME'] = $ticket['lname']; $_SESSION['SESS_TEL'] = $ticket['tel']; $_SESSION['SESS_EMAIL'] = $ticket['email']; $_SESSION['SESS_TEXT_MSG'] = $ticket['title']; $_SESSION['SESS_BESCHR_MSG'] = $ticket['description']; $_SESSION['SESS_PRIO'] = $ticket['priority']; $_SESSION['SESS_TIME_STAMP'] = $ticket['timestamp']; $_SESSION['SESS_STATUS'] = $ticket['status']; session_write_close(); //header("location: ticketuebersicht.php"); //exit(); } } ?> <center><table width="647" height="26" border="1"> <tr> <th scope="col"><?php $ticket['ticket_id'];?></th> <th scope="col"><?php $_SESSION['SESS_TIME_STAMP']?></th> <th scope="col"><?php $_SESSION['SESS_STATUS']?></th> <th scope="col"><?php $_SESSION['SESS_TEXT_MSG']?></th> <th scope="col"><?php $_SESSION['SESS_PRIO']?></th> </tr> </table></center>

certainly! see the attachment [attachment deleted by admin]

nobody?

Hey Guys, i'm trying to create a small ticketing tool written in PHP with a MySQL DB. What works: I can successfully connect to my DB and i can create query where the Ticket-Data (written by the support-needed) is inserted into the DB. What doesn't work: i'm trying to get access to those data and display it in the ticket-overview, where the supportteam is able to do sth with all tickets. If my problem is not understandable, i'll attach my php-files and my sql-file. (only 4 files, because i'm only allowed to attach four ) Hope anybody is able to help me, and give me a brief overview on how to do it. And YES i've already used our well-known friend (google) ;-) Greetings, Blarg EDIT:// I'm not good at php programming ( so please don't laugh ;-), cheers) [attachment deleted by admin]