stig1

The problem of the source has already been located. Data on an IBM AS400 system, puts in all the extra spaces in lines especially when the AS400 programmer, wants to put data in a text field to display, on his screen, the data will have spaces cause he can't do carriage returns or something. Not going to argue with him. It has to do with characters per line in an as400 system. I can use trim for so many fields, but the one i explained is a text field, and just looks very ugly in my mysql database.

When I extract data from the as400 data system, to insert or update into mysql, there is all the extra white space & spaces in the mysql database after insert. For example: These paper bags are made from 100gsm brown kraft paper.| They have a card in the bottom of the bag and a paper handle.| Size: 320mm (width) x 120mm (gusset) x 460mm (height)| Would like it to be inserted or updated in mysql to look like the following: These paper bags are made from 100gsm brown kraft paper.|They have a card in the bottom of the bag and a paper handle.|Size: 320mm (width) x 120mm (gusset) x 460mm (height)| Any ideas how I could achieve this, a function would be great as there are many fields like this, so if i can just feed the as400 database field into the function would be perfect. Any help is always apprecaited greatly.

SOLVED... I was working / looking at the wrong table, its the data i imported from another database system put spaces in automatically.

<?php $x = "select subtype from subtypsec where prodtype = '$ptID' and division = '$divnID' order by sequence asc, subtype asc"; $xresult = $mysql->query($x); while ($subtypelist = mysql_fetch_array($xresult)){ $stID = $subtypelist['subtype']; $st = "select descript from prdchgsub where subtype = '$stID'"; $st_result = $mysql->query($st); $st_row = mysql_fetch_row($st_result); $subtype = $st_row[0]; ?> <li> <a href="browse.php?pt=<?=$ptID;?>&st=<?=$stID;?>" title="<?= $subtype; ?>"><?= $subtype; ?></a> </li> <?php } ?> I can put in rtrim() and it will fix it up.. however, I didn't have to do that before on the old database, the new database is exact same fields.

No I didn't type a space, as when i go to look at the data in phpMyAdmin, it looks exactly how i typed it, no spaces. Another one of my varchar field holding item information, which is a primary key also has extra spaces to make 15 characters all the time, even if i only type in 5. i didnt use to have this issue..

I have set up a table that using a varchar field. In phpmyadmin, i add data, however, when i retrieve the data, it puts extra spaces at the end for some reason? It never use to. I am using mysql 5. So for example i would have a varchar(10) field and i would have the following inserted via phpmyadmin SHOPBAGS but when i extract it via php I get SHOPBAGS 2 Spaces at the end.. so my url looks like the following: browse.php?st=SHOPBAGS " It happens on all the data in my database, and i do have varchar(10) field as a primary key, would that matter?

I have the following code: $success = array(); $success[] = "Function Item Successful"; $success[] = "Function Catalogue Successful"; $countSuccess = count($success); if ($countSuccess != 0) { // puts array information into string. $emailBody = implode("",$success); mail($to,'Successful',$emailBody,'From: [email protected]'); } When i recieve the email, all the information comes out, however, it does not put the information onto a new line. How can i get it in my email to show a new line each array?

Sorted out the problem, all good now!

Any ideas?

I have created an array called errors, if the array is not empty, I would like to send the data in the array to my email address as notification. I am stuck on how do you get the values of the array to print in the email without the keys. I have the following already done: $errors = array(); // Errors scripts are attached to sql statements $countErrors = count($errors); if ($countErrors != 0) { // This prints it out on the screen.. how do get it to email me the output, instead of echo on screen? foreach ($errors as $msg) { echo $msg; } } Help is always apprecaited. And a huge thankyou in advance

I plan to jazz it up abit, but i just had no idea how to get it into a variable. Once its in a variable I can add text, and etc to make it more user friendly. Would my suggested answer work?

I would like to put error messages from mysql or my odbc connection into variables to which later I will email them out (already know how to use mail, so no help needed there) How would I put the following into a variable called $error should the sql fail in anyway. $iItemSQL = "insert into items (item, type1, type2, desc1, createdate, lastupdate) values ('".$item."', '".$type1."', '".$type2."', '".$desc1.'", '".$createdate."', '".$lastupdate."')"; $iItems = mysql_query($iItemSQL) or die (mysql_error()); Running the above script, if it was to fail would just die and display the error on the screen. Instead of just die and display error, I would like the script to put that error message into a variable to which i can later call, and the script can continue to run. Would this possible work? if(!$iItems){ $error = Error: '.mysql_errno().' '.mysql_error(); } Help is always apprecaited and a huge thankyou in advance.

I am in the process of building a server for our company, to store our intranet on. I am using centOS 5.2 with apache. In the config on apache, it has max connections and i can only put it up to 256 connections. I have over 500 people who will be using the intranet at any givin time. What does the 256 max connection mean? Can i only have 256 people access the intranet at once? What would I do with the other 300+ people. Help is always apprecaited and I thank you in advance for your response.

Does anyone else have any ideas? Or would it be best for me to create a function that holds the database connection / date / time function.. and just run the function inside the other functions first?

I am trying to create functions that use two includes (database connection scripts). I require adding both include statements at the top of the file inside the function for the function to work. Surely there is a way to pass both the include statements into the functions I have created without adding extra lines of code each time I require the use of these files. Question I have is, how do I pass include into my functions so I only have to type includes once at the type of the page? Please find attach some of the code I have created. The code all works, apart from the functions not being able to find the include statements at the top of the page. I have changed some values to not give away the database structure I am using. Also the crdat8 and lupdat8 does not pass into the functions either. I also would not like to have to create these each time inside each function, as I require the dates to be the same on the whole database / table structure. <?php include("../includes/connect_mysql.php"); include("../includes/connect_systemi.php"); // Create date & time function $crdat8 = date("Y-m-d H:i:s"); $lupdat8 = date("Y-m-d H:i:s"); // Run update function update(); // Define the functions that run in the update function function update() { subtypsec_systemI(); } // Create & update function subtypsec_systemI() { $subtypsec_sql = "select * from tablename where division = 'R'"; $subtypsec_result = odbc_do($connect_systemi, $subtypsec_sql); while(odbc_fetch_row($subtypsec_result)) { $prodtype = odbc_result($subtypsec_result,1); $subtype = odbc_result($subtypsec_result,2); $division = odbc_result($subtypsec_result,3); $sequence = odbc_result($subtypsec_result,4); // Check $i_subtypsec_sql = "select * from tablename where prod = '".$prod."' and sub = '".$sub."' and div = 'R'"; $i_subtypsec_result = mysql_query($i_subtypsec_sql) or die (mysql_error()); $i_subtypsec_count = mysql_num_rows($i_subtypsec_result); // Update or insert if ($i_subtypsec_count == 1) { $update_subtypsec_sql = "update tablename set seq = '".$seq."', lupdat8 = '".$lupdat8."', hide = 'N' where prod = '".$prod."' and sub = '".$sub."' and div = 'R'"; $update_subtypsec = mysql_query($update_subtypsec_sql) or die (mysql_error()); } else { $insert_subtypsec_sql = "insert into tablename (div, prod, sub, seq, crdat8, lupdat8) values ('".$div."', '".$prod."', '".$sub."', '".$seq."', '".$crdat8."', '".$lupdat8."')"; $insert_subtypsec = mysql_query($insert_subtypsec_sql) or die (mysql_error()); } } } Help is always appreciated, and a huge thankyou in advance.

When i try to use odbc_num_rows it always returns -1 as a result. Is there a work around to counting records in an as400 database system. Basically I just need to know if there is a record with certain values in the as400 database, if not, run an update script on the mysql database. However, odbc_num_rows does not work! It always returns -1. Its starting to drive me insane.

How do you go about removing extra whitespace created in the IBM AS400 Database, as I would like to insert / update the data in my mysql database without having all these extra spaces (think there called characters or something per line) For example White virgin paper made from general wood pulp. It's lint free quality makes it suitable for all electronic cash registers and calculators. Should really look like this: White virgin paper made from general wood pulp. It's lint free quality makes it suitable for all electronic cash registers and calculators.

so if my url is www.domainname.com.au/browse.php?cat=10 and id like to rewrite the url to www.domainname.com.au/tape_product.php can this be done with mod_rewrite? as i would like to make my url's more search engine friendly.

I would like to create a rewrite rule to convert the following url into something else. domainname.com/browse.php?catalog=1 into the following domainname.com/tape.html Any ideas? I'm stuck.

Works very well! Thankyou for your help

Hopefully simple question. I have a text string for example: $desc = "There are 50 sets per book, if numbered, the starting number has to be advised by the customer. Each book has a backing board and wrap around writing cover / template."; I would like to turn that into the following: <ul> <li>There are 50 sets per book, if numbered, the starting number has to be advised by the customer.</li> <li>Each book has a backing board and wrap around writing cover / template.</li> </ul> With each li point being controlled by the full stop. Any ideas? Thanks in advance for your help.

Hopefully this is a very simple question. I have a text string and I would like to convert the text string into a list. For example: $subtypeDesc = "Made from quality thermal paper treated on one side to produce an image from heat. These rolls are wound with the treated side out, which suits most machines. They are measured width of paper x diameter of roll x inside diameter of core.";[code] I would like to break the string at the full stop (.). I would assume you would have to then delete the space after the full stop before creating the next <li>. Thanks in advance for your help.

Simple question, probably even more simple answer. How can you check a string that is returned from a database that if it has more than 1 space between words, that it will then remove the extra spaces. For example... Made from quality thermal paper treated on one side to produce an image from heat. Should be.. Made from quality thermal paper treated on one side to produce an image from heat. Thanks in advance for your help.

How can I get it to put a clear in after every 3 records that come out?

Will that script always put a clear in after each lot of 3 records? so like i have 7 records, i should get a clear after the 3rd record and the 6th record?