designsweb

Hi Ginerjm, thanks for your reply it's simply an image on the page that fires "javascript:window.print", it used to print out exactly what I saw on the screen (less colours and boxes) then for some reason it simply stopped, If I use the firefox browser print function it's the same, shows the url the information came from aswell as the info, as shown in the image.

I hope that this is a simple fix that I can't for the life of me see. I have a page which selects data from a database for a selected person within a selected month which is used to provide an employee with their current or historic earnings. Up until the end of April you could hit the print button and it would print out the page as per what is on the screen (text only) in the correct layout minus the colours and boxes etc, this sufficed perfectly well. Then in May for no apparent reason the information that was collected from the database still displayed but now also has the url printed out, this is also the case when you use the browser print function. Please see the attached image of both scenarios. Any thoughts or help to solve this problem would be greatly appreciated. Thanks Ian.

Thanks Ch0cu3r, I will certainly look at re-designing the database as you suggested, in the meantime I'd like to see if I can just get the query to work as the data is entered into a simple excel spreadsheet, the reason that the clients are in their own columns is so that client_a, b and c can be logged against a single road as delivered and not just to an area, so it would require entering the road 3 times. At the moment the client logs into the system and then selects the button labeled client A, B, C,........etc and is then taken to the page that has been created for that client with it's own unique script. I'm trying to simplify the process by letting them enter their business and then dynamically retrieve the results based on what they entered in the input box. I can't get your suggestion to work I understand how you've written it, but I'm not sure what to put (a) in the form name, as it can't be client_a, client_b, cli..... etc and then how to write the $client-$_GET['???????????']; I really do appreciate the help Ian.

Hi Guys, I hope this is not too confusing, I am not by any means a PHP expert. I have a database which houses data from a spreadsheet for our leaflet distribution company, basically the data I need to extract is simply the clients name which can be in any of 8 columns, to display in the log in area only that clients delivered areas. 1st the client logs in, then they are taken to a page to enter their campaign name (given to them by us which is the data we want to search) then they are taken to our "tracking" page where my problems begin, all I want to do is have the tracking page search 'client_a' through 'client_h for the value that the client entered on the previous page and display only those results, another client does the same with another data value and thus gets his company results displayed. I think that I am struggling with the $_GET part at the beginning, I've tried many many ways but can only get results by individual columns. What I think I need is $client=$_GET[' ']; duplicated 8 times (client_a -client_h) and then to display the results from any of the 8 columns in the first <div> of the $dynamicList2 I have tried; $client=$_GET['client_a']; $client=$_GET['client_b']; ....etc etc. $client=$_GET['client_a'] ['client_b'] ....etc etc.; Logic tells me it needs to be this way because I only want to output the variable '$client ' in the <div> because wherever it got the data from is immaterial. but I think I need to have say $client_a=$_GET['client_a']; $client_b=$_GET['client_b']; ......etc etc but then if I am correct how do I output the data into the <div> as I can't have; <div id="client" class="dynamic"> ' . $client_a . ', ' . $client_b . ', ....etc etc </div> or can I? I've tried but it only displays every row with no clients at all I have also tried without success the IN command below with each scenario, I now think that I have so many ideas going round my head that I cannot see the logical solution. $sql=mysql_query("SELECT * FROM routes WHERE '$client' IN(client_a, client_b, client_c, client_d, client_e, client_f, client_g, client-h) ORDER BY date DESC"); The full code below is what I get success from with a single query: <?php include"../scripts/connect_to_mysql.php"; $client=$_GET['client_a']; $dynamicList2=""; $sql=mysql_query("SELECT * FROM routes WHERE client_a='$client' ORDER BY date DESC"); $routesCount=mysql_num_rows($sql); if ($routesCount > 0 ){ while($row=mysql_fetch_array($sql)){ $id=$row["id"]; $client_a=$row["client_a"]; $area=$row["area"]; $date=$row["date"]; $roads=$row["roads"]; $missed=$row["missed"]; $agent=$row["agent"]; $dynamicList2.='<div id="client" class="dynamic"> ' . $client_a . '</div> <div id="area" class="dynamic"> ' . $area . '</div> <div id="completed" class="dynamic"> ' . $date . '</div> <div id="road" class="dynamic"> ' . $roads . '</div> <div id="undelivered" class="dynamic"> ' . $missed . '</div> <div id="agent" class="dynamic"> ' . $agent . '</div>'; } }else{ $dynamicList2="Details of the campaign are yet to be uploaded, please try later."; } include ("../scripts/mysql_close.php"); ?> Many thanks Ian.

Thank you so much Muddy_Funster and Mac_Gyver, unfortunately I can't mark both of your answers as solved, as soon as I saw the error in the source code I knew that I had caused it. What i had done is when I added the 2 new fields 'salesperson' and 'made_live' I renamed the field 'niche_category' to 'made_live' as it was never used then I proceeded to add the new lines of code to the scripts and left 'niche_category' in both files hence the error "unknown field 'niche_category'" Once again you guys are legends and far more helpful than Stack Overflow. thanks again both of you I only wish I could help you out someday too. Kind Regards Ian.

Hi Cracka, it is a date field however I've also made it VARCHAR, deleted it completely and gone right back to scripts I know for sure worked previously and still it doesn't work, it really does make no sense to me. I know that the problem is going to be such a simple one but I just can't see it.

Thanks Muddy_Funster for your help, you really don't know how much I appreciate it, I've done as you asked and used test as an entry where there is not a list item and the following was returned; The Following Query Failed To Run : INSERT INTO business_list ( meta_desc, business_name, address, package, contact_name, description, phone, e_mail, short_web, weblink, facebook, first_ad, main_menu, category, sub_category, niche_category, display_ad, salesperson, made_live ) VALUES ( 'test', 'test', 'test', 'Free', 'test', 'test', 'test', 'test', 'test', 'Go To Website', 'test', '1', 'BUS Business', 'BUS Computers and IT', 'BUS C&I SEO', ' ', 'Free', 'Gabi', '28-08-2013' ) The Server resonded with the following error:

I am a complete Newb where this PHP malarkey is concerned, however I have picked up a few basics and probably many more bad habits. The problem I have is the INSERT script and the UPDATE scripts have ceased working on Friday, the last time I know the INSERT worked was Thursday as items are added pretty much daily without any problems. All I have done is added 2 fields in the database 'salesperson' and 'made_live' and amended the scripts accordingly, when I realized it had stopped working I re-uploaded the original files and it still wasn't working, however I don't know if this is just coincidence or I've broken something. I can't for the life of me see any errors in the script but what do I know, (actually I wish to re-phrase that, I can't see any errors that would cause this problem, I'm sure that there are plenty of errors in it ;-) I would very much appreciate it if one of you experts could take a peek for me before I yank out what grey hair I have remaining. Many thanks in advance. Ian. INSERT Script: <?php //Connect to the MySQL database include"../scripts/connect_to_mysql.php"; if (!get_magic_quotes_gpc()) { $meta_desc=addslashes($_POST['meta_desc']); $sku=$_POST['sku']; $business_name=addslashes($_POST['business_name']); $address=$_POST['address']; $package=addslashes($_POST['package']); $contact_name=addslashes($_POST['contact_name']); $description=addslashes($_POST['description']); $phone=$_POST['phone']; $e_mail=$_POST['e_mail']; $short_web=$_POST['short_web']; $weblink=$_POST['weblink']; $facebook=$_POST['facebook']; $first_ad=$_POST['first_ad']; $main_menu=$_POST['main_menu']; $category=$_POST['category']; $sub_category=$_POST['sub_category']; $niche_category=$_POST['niche_category']; $display_ad=$_POST['display_ad']; $salesperson=$_POST['salesperson']; $made_live=addslashes($_POST['made_live']); } //* The script below fails to enter anything into the db*// $sql=mysql_query( "INSERT INTO business_list (id, meta_desc, sku, business_name, address, package, contact_name, description, phone, e_mail, short_web, weblink, facebook, first_ad, main_menu, category, sub_category, niche_category, display_ad, salesperson, made_live) VALUES ('NULL', '$meta_desc', 'NULL', '$business_name', '$address', '$package', '$contact_name', '$description', '$phone', '$e_mail', '$short_web', '$weblink', '$facebook', '$first_ad', '$main_menu', '$category', '$sub_category', '$niche_category', '$display_ad', '$salesperson', '$made_live')"); //*$lastid now returns '0' (as the INSERT failed) when the script worked before it would return the id, then that id is used to update the sku in the db for the review section.*// $lastid=mysql_insert_id(); $sql=mysql_query ($sql) or die ('<p></p><p></p>Database successfully updated with all the information relating to:<strong> ' . $business_name . ' </strong>, <p>USE THIS ID FOR AD IMAGE:<strong> ' . $lastid . ' </strong><form action="set_sku.php" method="post" enctype="multipart/form-data" name="set_sku"> <p>Now you need to update the SKU in the Database</P> <label>INPUT ID HERE TO UPDATE SKU AND CONTINUE TO ADD THE IMAGES</label> <input name="sku" type="text" maxlength="7" /> <input type="submit" value="Update SKU" /> </form> </p>'); mysql_close() ?> UPDATE Script: <?php include"../scripts/connect_to_mysql.php"; if (!get_magic_quotes_gpc()) { $ud_id=$_POST['ud_id']; $ud_sku=$_POST['ud_sku']; $ud_business_name=addslashes($_POST['ud_business_name']); $ud_address=addslashes($_POST['ud_address']); $ud_package=addslashes($_POST['ud_package']); $ud_contact_name=addslashes($_POST['ud_contact_name']); $ud_description=addslashes($_POST['ud_description']); $ud_meta_desc=addslashes($_POST['ud_meta_desc']); $ud_phone=$_POST['ud_phone']; $ud_e_mail=$_POST['ud_e_mail']; $ud_short_web=$_POST['ud_short_web']; $ud_weblink=$_POST['ud_weblink']; $ud_facebook=$_POST['ud_facebook']; $ud_first_ad=$_POST['ud_first_ad']; $ud_category=$_POST['ud_category']; $ud_sub_category=$_POST['ud_sub_category']; $ud_niche_category=$_POST['ud_niche_category']; $ud_display_ad=$_POST['ud_display_ad']; $ud_salesperson=$_POST['ud_salesperson']; $ud_made_live=addslashes($_POST['ud_made_live']); } //*The above script works as the data is displayed in the UPDATE form, the below script fails to actually do the UPDATE*// $query="UPDATE business_list SET sku='$ud_sku', business_name='$ud_business_name', address='$ud_address', package='$ud_package', contact_name='$ud_contact_name', description='$ud_description', meta_desc='$ud_meta_desc', phone='$ud_phone', e_mail='$ud_e_mail', short_web='$ud_short_web', weblink='$ud_weblink', facebook='$ud_facebook', first_ad='$ud_first_ad', main_menu='$ud_main_menu', category='$ud_category', sub_category='$ud_sub_category', niche_category='$ud_niche_category', display_ad='$ud_display_ad', salesperson='$ud_salesperson', made_live='$ud_made_live' WHERE id='$ud_id'"; mysql_query($query); echo "Record Updated"; mysql_close(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <META NAME="ROBOTS" CONTENT="NOINDEX, NOFOLLOW"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>SLBD - Admin</title> <link rel="stylesheet" href="../stylesheets/style.css" type="text/css" media="screen" /> </head> <body> <?php include_once("../templates/template_header.php"); ?> <h1> <?php echo "Record Updated"; ?></h1> <div id="contact" class="request"> <a href="log_out.php">[Log Out]</a> | <a href="reports_asc.php"> [Reports]</a> <table width="100%" border="0" cellpadding="40"> <tr><strong> <form action="admin.php" method="get" name="id"> <td align="center"> <input type="submit" value="Add an Advert" /> </td> </form> <form action="imageadmin.php"> <td align="center"> <input type="submit" value="Add or Update an Image" /> </td> </form> <form action="admin_update.php" method="get" name="id"> <td align="center"> <label>Update Ad with ID?</label><br /><br /> <input name="id" type="text" size="5" maxlength="7"> <br /><br /> <input type="submit" value="Update Advert" /> </td> </form> </strong> </tr> </table> </div> <br /> <?php include_once("../templates/template_footer.php"); ?> </body> </html> The CONNECT Script works fine because: the site displays correctly and uses the same script The UPDATE command collects the data, just won't do the UPDATE