pepelepew1962

Hello: I am having a brain fart on how to get this done and any ideas would greatly be appreciated. I am working on a in-house mailbox project and have my first problem. I am going to try and explain this a simple as possible as putting the words from my head to screen harder than I thought. I have a page with 1 div called msgs_main. Inside of that div are 2 more, top one called msgs_msgs and the bottom called msgs_content. The msgs_msgs div contains a simple mysqli query displaying the records that correspond to the user. What I want/need is that when the user clicks one of the rows, the contents of the message are displayed in the msgs_content div. I could provide the code, if it helps, but I am not really looking for answered code, but a process to learn from, like. "First, get a join and have all the records display in the msg_msgs div. Display them all to see that all the data is there. Later in production, remove the un-necessary fields from top div". Then research .... etc

Thank you for your response. My goal is to switch to MySQLi, OOP and use prepared statements. I think I mixed a few things up here between oop and procedurals I just created a small table so that I can get a format down and then copy to the real files.

require("dbcon.php"); // Check for errors if(mysqli_connect_errno()) { echo mysqli_connect_error(); } // Create a prepared statement if($stmt = $mysqli -> prepare ("SELECT id, username, password FROM users WHERE password=?")) { // Bind parameters s - String, b - Boolean, i - Integer etc $password='123'; $stmt -> bind_param("s", $password); // Execute it $stmt -> execute(); // Bind result variables $stmt->bind_result($id,$username,$password); // Fetch the result of the query while($stmt->fetch()) { echo $id . ' - ' . $password . ' - ' . $username; echo "<br />"; } // Close statement $stmt -> close(); } // Close connection $mysqli -> close(); Hello: I am trying to convert to mysqli and on the net I constant see examples of freeing the memory after running the query. All the examples I have seen are based on 1 result from the query. Well I have multiple fields in my bind results and can not get something to the effect of: mysqli_free_result ($result) Can anyone help me here please. How can I free the results in my code?

Hello: I am trying to create templates for my files and I am having a problem with getting the menu to work properly. I have 3 template files, head.php, main.php and foot.php. The head.php contains the following menu html: <li><a href="page1.php" class="<?php echo "$head001";?>">One</a></li> <li><a href="page2.php" class="<?php echo "$head002";?>">Two</a></li> <li><a href="page3.php" class="<?php echo "$head003";?>">Three</a></li> <li><a href="page4.php" class=<?php echo "$head004";?>>Four</a></li> <li><a href="page5.php" class="<?php echo "$head005";?>">Five</a></li> In the main.php, I would like to have 1 variable for what the status of the menu is for that page. For example when the person is on page 3, the class should be current. $head003 = "Current"; include("head.php"); The variable current is in my external css file and changes the appearance. Simple, but for some reason, the variable is not being carrier over. Can you please help.

Hello: I am trying to create a result form from mysql and I am having problems formatting my html data tables. The result should be show a picture ( link in mysql ), then next to it a table that will probably contain 4 fields that I have as table0. I want this to be 100%, but when I make it 100%, it automatically drops below the picture. The same goes for the 2 tables, table1 and table2 ( all these names are temp only so that I can see the placement ). I can not get them to be 50% each. I want to add another row of tables that will be hidden in all views accept with a media query of 240. This would then show a little more information for mobile users. I am not worried just yet about the media query. Can anyone help me please. I have added the code here along with a link. I am not using external css until it works. http://www.pepelepew1962.x10.mx/help.html <!DOCTYPE html> <head> <style type="text/css"> #pager { width:75%; } #page01 { margin: 10px auto; border: 2px solid #191919; background-color: #2C2C2C; padding: 10px; border-radius: 4px; /* [disabled]margin-bottom: 10px; */ /* [disabled]margin-top: 10px; */ } #pk01 img { width: 75px; height: 100px; } .pix { display:block; max-width:100%; height:auto; margin:0.0em auto; float: left; } .table0 { width:90%; margin:auto; font-size:12px; border:1px solid #0000FF; float: left; margin-bottom: 5px; } .table0 th { font-weight:bold; color: yellow; vertical-align:middle; text-align:center; border:1px solid #C1FFC1; } .table1 { width:40%; margin:auto; font-size:12px; border:1px solid #FF1493; float: left; } .table1 th { font-weight:bold; color:#00FFFF; vertical-align:middle; text-align:center; border:1px solid #C1FFC1; } .table1 tr { border:1px solid #C1FFC1; } .table1 td { font-weight:bold; color:#00FF00; vertical-align:middle; text-align:left; padding-left: 15px; border:1px solid #C1FFC1; } .table2 { width:40%; margin:auto; font-size:12px; border:1px solid #FF1493; float: left; } .table2 th { font-weight:bold; color:#00FFFF; vertical-align:middle; text-align:center; border:1px solid #C1FFC1; } .table2 tr { border:1px solid #C1FFC1; } .table2 td { font-weight:bold; color:#FF0000; vertical-align:middle; text-align:left; padding-left: 15px; border:1px solid #C1FFC1; } </style> <title> Test Page </title> </head> <body bgcolor="#000000"> <div id="pager"> <div id="page01"> <div id="pk01"> <img src="300x250_uap.gif" class="pix" /> </div> <div id="exampleB"> <table class="table0"> <tr> <th> SOMETHING</th> <th> SOMETHING</th> <th> SOMETHING</th> <th> SOMETHING</th> </tr> </table> </div> <div id="exampleB"> <table class="table2"> <tr> <td>Book</td> <td>$5.00</td> </tr> <tr> <td>Shoe</td> <td>$10.00</td> </tr> <tr> <td>Flower</td> <td>$3.00</td> </tr> </table> <table class="table1"> <tr> <td>Books</td> <td>$5.00</td> </tr> <tr> <td>Shoes</td> <td>$10.00</td> </tr> <tr> <td>Flowers</td> <td>$3.00</td> </tr> </table> </div> <div style="clear: left;"></div> </div> <div id="page01"> <div id="pk01"> <img src="300x250_uap.gif" class="pix" /> </div> <div id="exampleB"> <table class="table0"> <tr> <th> SOMETHING</th> <th> SOMETHING</th> <th> SOMETHING</th> <th> SOMETHING</th> </tr> </table> </div> <div id="exampleB"> <table class="table2"> <tr> <td>Book</td> <td>$5.00</td> </tr> <tr> <td>Shoe</td> <td>$10.00</td> </tr> <tr> <td>Flower</td> <td>$3.00</td> </tr> </table> <table class="table1"> <tr> <td>Books</td> <td>$5.00</td> </tr> <tr> <td>Shoes</td> <td>$10.00</td> </tr> <tr> <td>Flowers</td> <td>$3.00</td> </tr> </table> </div> <div style="clear: left;"></div> </div> </div> </body></html>

Hello: I am trying to get an advanced form going and I am having problems with what I believe is css. If you click the "ADVANCE SEARCH" button the table opens up and now has 3 boxes. Each box has a mini description of what I would like. So the first box says that this area/content should be replaced with the much lower Table1. The next box to be replaced with Table2 and finally box 3 is to be replaced with Table3. I have 10px as right margins on the divs only to show a separation visually. I know tables are NOT to be used for forms, but the exact form code will also be used to display mysql data on a later page. http://www.pepelepew1962.x10.mx/search.html

Hello: I am having problems with what I think is a fluid page that I thought worked, but it doesn't. I basically have 3 problems, 1 major, 2 minor that are keeping me up at night. The first problem ( major ) is that my "rite content" loses it's bottom padding when the screen res goes beyond 1400px. I don't know all that much about css, but I wonder why it would work on smaller res but changes on higher. I basically want a bottom padding of 10px above my footer. If the left content is larger, well the right padding would not matter, but when the left is shorter than the right, then the right padding should kick in. Second problem is cosmetic in that the space between the "home" section and "footer" section have 10px, but the space between the first portion of the left content and the second is greater. I would like to get it to be the space, 10px for example. There could be more sections, so it needs to look uniform regardless of how many sections I have. Third problem, and again, it is minor and perhaps not worth mentioning, but looking at the code below, I would like to have the "rite page" within the "page body". Why??? I just think that it belongs to the main content section and should follow the "left page". http://www.pepelepew1962.x10.mx/ <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Test Page</title> <link rel="icon" href="favicon.ico" type="image/x-icon"> <meta name="author" content="Blank"> <style type="text/css"> body { margin: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 15px; background: #4A4A4A; background-image: url(homeback.jpg); } img { border: none; } a { outline: none; color: #0091E8; text-decoration: none; } a:visited { color: #0091E8; } a:hover { color: #666; text-decoration: underline; } #head_Main { background: url(homehead.png) repeat-x; height: 112px; } #head_Wrap { width: 90%; margin: 0px auto; height: 112px; } #head_Logo { float: left; height: 112px; width: 90px; padding-top: 6px; } #head_News { margin-top: 0px; padding: 0px; color: #0FF; font-size: 20px; height: 44px; width: 0 auto; margin-left: 90px; line-height: 44px; padding-left: 5px; } #head_Menu { text-align: center; font-weight: bold; height: 44px; width: 0 auto; margin-left: 90px; } #head_Menu ul { margin: 0; padding: 0; } #head_Menu li { margin: 13px 5px 10px 0; padding: 0; list-style: none; display: inline-block; *display: inline; /* ie7 */ } #head_Menu a { padding: 3px 12px; text-decoration: none; color: #999; line-height: 100%; border-radius: 5px; background: #151515; border: 1px solid #262626; } #head_Menu a:hover { color: #000; border: 1px solid #383838; border-radius: 5px; background-color: #666666; } #head_Menu #current a { color: #fff; background: #999; border: 1px solid #383838; border-radius: 5px; background-color: #444444; } #head_Info { height: 22px; width: 0 auto; margin-left: 90px; color: #F00; font-size: 12px; padding-top: 6px; } #head_Lead { clear: both; height: 90px; text-align: center; } #page_Body { width: 100%; float: left; /* [disabled]margin-top: 25px; */ /* [disabled]padding-bottom: 25px; */ /* [disabled]padding-left: 10px; */ /* [disabled]height: 100%; */ /* [disabled]border: 2px solid #383838; */ border-radius: 5px; /* [disabled]background-color: #2C2C2C; */ } #page_Left { margin-right: 210px; /*Set right margin to RightColumnWidth*/ /* [disabled]background-color: #90EE90; */ } #page_Rite { margin-top: 10px; width: 200px; /*Width of right column in pixels*/ ; /*Set left margin to -(RightColumnWidth) */ background-color: #2c2c2c; float: left; color: #F00; border-radius: 5px; border: 2px solid #383838; } #page_Name { /* [disabled]margin-top: 0px; */ /* [disabled]margin-left: 10px; */ border: 2px solid #383838; border-radius: 5px; background-color: #333333; width: 100%; /* [disabled]height: 200px; */ /* [disabled]margin-right: 200px; */ /* [disabled]margin-bottom: 25px; */ margin-left: 0px; padding: 4px 0; clear: left; /* [disabled]padding-right: -25px; */ } #left_Body { margin: 0px; /*Margins for inner DIV inside each column (to provide padding)*/ margin-top: 0; padding-left: 10px; padding-right: 10px; padding-top: 10px; padding-bottom: 10px; } #rite_Body { margin: 0px; /*Margins for inner DIV inside each column (to provide padding)*/ margin-top: 0; padding-left: 10px; padding-right: 10px; padding-top: 10px; } .name_Text { /* [disabled]padding-right: 10px; */ color: #FF0; font-weight: bold; text-align: left; padding-left: 25px; } .left_Text { margin-top: 25px; /* [disabled]margin-left: 10px; */ border: 2px solid #383838; border-radius: 5px; background-color: #2c2c2c; /* [disabled]width: 97%; */ /* [disabled]height: 200px; */ /* [disabled]margin-right: 200px; */ margin: 0px auto; padding: 10px; color: #CF6; /* [disabled]margin-bottom: 25px; */ text-align: left; } .rite_Text { } /* 300 x 250 IMU - (Medium Rectangle) */ /* 180 x 150 IMU - (Rectangle) */ /* 160 x 600 IMU - (Wide Skyscraper) */ /* 728 x 090 IMU - (Leaderboard) */ #head_Foot { /* [disabled]margin-top: 0px; */ /* [disabled]margin-left: 10px; */ border: 2px solid #383838; border-radius: 5px; background-color: #333333; width: 100%; /* [disabled]height: 200px; */ /* [disabled]margin-right: 200px; */ /* [disabled]margin-bottom: 25px; */ margin-left: 0px; color: #0F0; font-weight: bold; text-align: center; padding: 4px 0; clear: left; } #head_Foot a { color: #FFFF80; } </style> <script type="text/javascript"> /*** Temporary text filler function. Remove when deploying template. ***/ var gibberish=["THE QUICK BROWN FOX JUMPS OVER THE LAZY DOG.", "the quick brown fox jumps over the lazy dog.", "PACK MY BOX WITH FIVE DOZEN LIQUOR JUGS.", "pack my box with five dozen liquor jugs."] function filltext(words){ for (var i=0; i<words; i++) document.write(gibberish[Math.floor(Math.random()*4)]+" ") } </script> </head> <body> <div id="head_Main"> <div id="head_Wrap"> <div id="head_Logo"> <a href="http://www.webintersect.com"> <img src="logo.png" alt="logo" title="Web Intersect Home"> </a> </div><!--End of head_Logo --> <div id="head_News">THIS IS A MSG AREA!!!</div> <nav id="head_Menu"> <ul> <li id="current"><a href="http://www.yahoo.com">HOME</a></li> <li><a href="#">ABOUT US</a></li> <li><a href="#">CONTACT US</a></li> <li><a href="#">LOG IN</a></li> </ul> </nav><!--End of head_Menu --> <div id="head_Info"> <img src="pmFlash.gif" width="17" height="12" alt="fuk"> EMAILS ( 44 )</div> <div id="head_Lead"><img src="728x090_uap.gif" width="728" height="90"</div> <div id="page_Name"><div class="name_Text">HOME</div> </div><!--End of page_Name --> <div id="page_Body"> <div id="page_Left"> <div id="left_Body"><div class="left_Text"><script type="text/javascript">filltext(45)</script></div> </div><!--End of left_Body --> <div id="left_Body"><div class="left_Text"><script type="text/javascript">filltext(45)</script></div> </div><!--End of left_Body --> </div><!--End of page_Left --> </div><!--End of page_Body --> <div id="page_Rite"> <div id="rite_Body"><script type="text/javascript">filltext(14)</script> </div><!--End of rite_Body --> </div><!--End of page_Rite --> <div id="head_Foot">FOOTER</a> </div> </div><!--End of head_Wrap Div --> </div><!--End of head_Main Div --> </body> </html> Any help regarding this would greatly be appreciated.

Hello: I found this great calendar program that has 1 main fault. It does not display 24hrs with the leading zero, as in 09:00 instead of 9:00. I think the below code is the root of the problem. Can anyone help me here please as I know no JScript: //Time Picker function tPicker(timeFieldId) { var timeField = $(timeFieldId); var hhmm; //compute tpicker coordinates (beneath timeField) var x = timeField.offsetLeft + timeField.offsetWidth + 22; var y = timeField.offsetTop - 95; //deal with elements inside tables and such var parent = timeField; while (parent.offsetParent) { parent = parent.offsetParent; x += parent.offsetLeft; y += parent.offsetTop ; } //If not present, create tpDiv, move it to x,y and toggle visibility var tpDiv = createDiv("tpDiv", x, y); //draw the timepicker table; the timeField object will receive the time var html='<div class="tpFrame">'; var apm = /\s*a/i.exec(tFormat); if (apm != null) { var am = String(apm).replace("a","am").replace("A","AM"); var pm = String(apm).replace("a","pm").replace("A","PM"); } if (apm != null) { html += '- AM -'; } for (var i=7;i<24;i++){ if (i==7) { html += '<div class="tpAM">'; } if (i==12 && (apm != null)) { html += '- PM -'; } if (i==12) { html += '<div class="tpPM">'; } if (i==18) { html += '<div class="tpEM">'; } for (var j=0;j<60;j += 15) { if (apm != null) { hh = i; ampm = (hh < 12) ? am : pm; if (hh >= 13) { hh -= 12; } hhmm1 = String(hh) + ":" + String("0" + j).slice(-2) + ampm; hhmm2 = String("0" + hh).slice(-2) + ":" + String("0" + j).slice(-2); } else { hhmm1 = hhmm2 = String("0" + i).slice(-2) + ":" + String("0" + j).slice(-2) } html += '<a class="tpPick" href="#" onclick="updateTimeField(\''+timeFieldId+'\', \''+hhmm1+'\');">'+hhmm2+'</a>'; if (j<45) { html += ' '; } } html += (i==11 || i==17 || i==23) ? '</div>' : '<br>'; } html += '</div>'; tpDiv.innerHTML = html; } function updateTimeField(timeFieldId, timeString) { var timeField = $(timeFieldId); if (timeString) { timeField.value = timeString; } var tpDiv = $("tpDiv"); tpDiv.style.visibility = "hidden"; tpDiv.style.display = "none"; timeField.focus(); }

TCPDF does HTML, mysql and/or php to pdf.

Thank you for your response. You answered everything in the first 3 sentences.

Hello: I am really trying to understand XSS attacks and can't seem to wrap my head around it, I would rather seem like a fool than program like one with holes in it. My problem is understanding how an attack occurs. Let's say Mary logs into the system and creates a record in the table via an html form. I have php filters and validation for the data before it actually goes into mysql table. My question is how does John attack my website? Or more important, how does he actually change files? If he were to have a log in and gains access because it doesn't take much to register, how? Is it a matter of the filter being bad and his XSS scipt is in a record and when someone open/views that record (field) the script is launched? I have read lots on how the javascript, for example, is placed in the url or form fields but nothing explains whether the information is saved and launched via the record stored in the database.

Hello: I am having a problem and I am not sure my method is correct. I know my sub-query isn't. What I need is to get the Max-Autonum, or last record for a specific record. Please see the example for a better understanding: part_id_num part_manufac_code part_number 1 36 18547 2 36 57847 3 35 79811 4 36 57914 5 35 74992 If I am looking for part_manufac_code 36, then the last record (part_id_num) for that is 4. Here is the code that I have: // // // require("connect.php"); // // // $query1 = "SELECT part_id_num, part_manufac_code, part_number FROM tblparts WHERE (part_manufac_code = '$frmfindpart')"; $result1 = mysql_query($query1) or die(mysql_error()); // // $query2 = "SELECT MAX(part_id_num) FROM '$result1'"; $result2 = mysql_query($query2) or die(mysql_error()); if(mysql_num_rows($result2) > 0) { while($row = mysql_fetch_assoc($result2)) { $names[] = $row['name']; } } else { echo 'query returned no results'; }

Hello: When I call up a specific record, I need to sort the contents of "tblpartmanuf" and replace that field with the sorted information. Lets say the record is: tblpartnumber tblpartmanuf 12544 GFSD After I edit some other fields, automatically sort the tblpartmanuf field so that it is: 12544 DFGS $sql="SELECT tblpartnumber, tblpartmanuf FROM tblparts WHERE tblpartnumber ='$frmpartfinder'"; $result = mysql_query($sql) or die('Error: ' . mysql_error());

sorry for not using tags. FYI - It works, awesome, thanks !!!

Hello: I am having a problem fixing/understanding a recent error message. Basically, I have a search form that after validation and filtering stores the variable into a session. Another page/file opens and loads that search field. Everything has always worked but I recently added pagination and suddenly this program no longer works. Any assistance would greatly be appreciated. php version=5.3.1 mysql version=5.1.41 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 'ASC LIMIT 0,10' at line 1 Pagination: http://www.catchmyfame.com/2007/07/28/finally-the-simple-pagination-class/ Here is the shortened version of the code: include('../pagination/paginator.php'); $searcher = $_SESSION['sessearchcode']; $query = "SELECT COUNT(*) FROM tblLoad, tblCode WHERE (tblLoad_LoadID = tblCode_CodeID) AND tblCode_Manufact LIKE '%$searcher%'"; $result = mysql_query($query) or die(mysql_error()); $num_rows = mysql_fetch_row($result); $pages = new Paginator; $pages->items_total = $num_rows[0]; $pages->mid_range = 9; // Number of pages to display. Must be odd and > 3 $pages->paginate(); $query = "SELECT tblLoad_LoadID, tblLoad_Company, tblLoad_State, tblCode_CodeID from tblLoad, tblCode WHERE (tblLoad_LoadID = tblCode_CodeID) AND tblCode_Manufact LIKE '%$searcher%' ASC $pages->limit"; $result = mysql_query($query) or die(mysql_error()); Thank You.

Hello, I am trying to combine 2 queries together and am now looking for help. I really do not know how to explain this, but what I need is the 2 queries to be combine and then the information made available. The key that holds this together is Load00 and Kids00. This is a many ( tblKids ) to one ( tblLoad ) and I fully accept that information from the second query is duplicated, that is actually how I need it. Can anyone place these 2 together. // Part 01 $rad2101 = "SELECT tblLoad_Load00, tblLoad_Load19, tblLoad_Load20, tblLoad_Load21, tblKids_Kids00, tblKids_Kids11, tblKids_Kids12, tblKids_Kids13, tblKids_Kids15 FROM tblLoad_Load AS tblLoad_Load JOIN tblKids_Kids AS tblKids_Kids ON (tblLoad_Load00 = tblKids_Kids00)"; // // Part 02 $rad2102 = "SELECT tblKids_Kids00, MIN(tblKids_Kids12) AS MIN02, MAX(tblKids_Kids12) AS MAX02, AVG(tblKids_Kids12) AS AVG02 FROM tblKids_Kids GROUP BY tblKids_Kids00"; // // Part 03 $rad2103 = "???"; // while($row = mysql_fetch_array($rad2103)) { // // $Load00 = $row['tblLoad_Load00']; // Load ID $Load19 = $row['tblLoad_Load19']; $Load20 = $row['tblLoad_Load20']; $Load21 = $row['tblLoad_Load21']; $Kids00 = $row['tblKids_Kids00']; // Kids ID $Kids11 = $row['tblKids_Kids11']; $Kmax02 = $row['MAX(tblKids_Kids12']; // // MOD EDIT: code tags added.

Hmmm, looks promising, but I am testing via xampp on my PC so it is difficult to confirm. One day I will have to upload the pages and give it a test. Thanks for the info though. I will get back, probably in a few weeks whether it worked or not.

Ok, if all else gfails go to pencil and paper. I got my calendar out and tapped each day from Dec 13 ( 23:00 hrs ) back and my finger stopped at 200 days on May 17, all being equal ( 23:00 hrs). Where did the 1 whole day go?

Lovely, thanks for your response though. Is there any trick, perhaps calculating via Julian date or something else that would work? These calculations are critical for production as the product is food and time cut-offs important.

// I am trying to calculate the number of days between dates and have a major problem. When I try the example below, it gives me exactly 201 days, yet the dates have different times, meaning that a full day is impossible. If it matters, I am testing via xampp 1.7.3 with php version 5.3.1 with Windows XP. Can anyone explain what I am doing wrong. Can daylight savings play a role? $frmritedate7116 = strtotime('2010-12-13 23:00'); $frmritedate7156 = strtotime('2010-05-27 00:00'); // $frmritedate7251 = $frmritedate7156 - $frmritedate7116; // // 1274943600-1292310000=-17366400 // 86400 seconds in a day ( 201.00 ) // // //

Hello: I am having problems getting information from 2 tables and think this is a mysql issue instead of php. I have a MAIN table that lists computer models and another PART table that has it's components. My query result needs to be, list the model, manuf and type ( main ) and all it's components (parts ), including the unit price, the max unit price, the min unit price and the average unit price. My primary focus is with the PART table. The result will list the same model and manuf along with all the parts and prices. Maybe an example would help: // $ritelist2101 = "SELECT tblMain.tblMain_Main00, tblMain.tblMain_Main05, tblMain.tblMain_Main06, tblPart.tblPart_Part00, tblPart.tblPart_Part01, tblPart.tblPart_Part02 FROM tblMain, tblPart WHERE (tblMain.tblMain_Main00 = tblPart.tblPart_Part00) ORDER BY tblMain_Main05, tblMain_Main00"; $ritelist2102 = mysql_query($ritelist2101); // Sample Data: Main00=125 Main05=Sony Main06=Desktop // Main00=136 Main05=Sony Main06=Desktop // Main00=142 Main05=Dell Main06=Laptop // // Part00=125 Part01=Drive Part02=500.00 // Part00=125 Part01=Video Part02=100.00 // Part00=125 Part01=Keyboard Part02=63.00 // // Part00=136 Part01=Drive Part02=450.00 // Part00=136 Part01=Video Part02=300.00 // RESULT: (Manu-Model-Part-Price-Max-Min-Avg) Sony-125-DRIVE-500-500-63-221 Sony-125-VIDEO-100-500-63-221 Sony-125-KEYBOARD-63-500-63-221 Sony-136-DRIVE-450-450-300-375 Sony-136-VIDEO-300-450-300-375 etc... // I fully understand that a lot of information is duplicated, but it is not my place to ask, but to do. Supposedly more calculations will be made, but first things first. Also, I need to read the data with: $Main00 = $row['tblMain_Main00']; // Main Model $Main05 = $row['tblMain_Main05']; // Manufacturer $Main06 = $row['tblMain_Main06']; // Type $Part00 = $row['tblPart_Part00']; // Part Model Can anyone please help me on this.