webbie1985

Ahhhhh! mate you are a living LEGEND!! it didnt occur to me that i could include the jquery in the php script totally over looked it !!!

just looked through my html and there is no call for that specific path

loads fine here, just check on my ftp and there is no directory called jquery, the jquery files are located in the root of pmanagement

using jquery ui autocomplete live link is www.swifttrading.co.uk/pmanagement/index.php admin admin it is just a live test server and database

thanks a bunch, usually do just slipped my mind (!WOOPS!)

ok lol so ive been so long changed my code abit now i have a searching box for the product code using jQuery but i still cant get it to put the other data from the table in the other text boxes product description and price ill show you my new code: <script type="text/javascript"> $(document).ready(function() { $('#auto').autocomplete( { source: "search1.php", minLength: 2, }); }); </script> <div class="content" id="addpro"> <form style="text-align:right"action="saveproduct.php" method="post"> <div style="width:400px; text-align:right"> <div style="margin-left: 48px;"> Service Centre: <input name="servicecentre" type="text" /> </div> <br /> <div style="margin-left: 97px;"> PO Number: <input name="ponumber" type="text" /> </div> <br /> <div style="margin-left: 80px;"> Product Code:<input name="productcode12" type="text" id="auto" /> </div> <br /> <div style="margin-left: 80px;"> Product Description: <input name="proddesc" value=""type="text" /> </div> <br /> <div style="margin-left: 80px;"> Price: £<input id="price" name="price" type="text" /> </div> <br /> <div style="margin-left: 80px;"> Quantity: <input name="quantity" type="text" /> </div> <br /> <div style="margin-left: 80px;"> Total: £<input name="total" type="text" /> </div> <div style="margin-left: 127px; margin-top: 14px;"><input name="" type="submit" value="Save" /></div> </div> </form> </div> <?php $mysqli = new mysqli(); $text = $mysqli->real_escape_string($_GET['term']); $query = "SELECT * FROM products WHERE productcodes LIKE '%$text%' ORDER BY productcodes ASC"; $result = $mysqli->query($query); $json = '['; $first = true; while($row = $result->fetch_assoc()) { if (!$first) { $json .= ','; } else { $first = false; } $json .= '{"value":"'.$row['productcodes'].'"}'; } $json .= ']'; echo $json ; ?> Thanks millions

i agree with D4Y0's (#5) Post. make your <h2> tag look the same as your <h1> in your CSS file you can use as many <h2>'s as you want according to my SEO agency

Prestashop all the way for me

We use prestashop it has great feature, lots of community support, hundreds of free and paid modules and templares, easy to customise, and nearly every payment gateway is available for it we use secure trading but there are hundreds that are available for it and the majority of them are installed when you install it

I would probably change the white text that's in the header to black just to tie the colours in on the header, great first site well done

A lot of people over look adobe muse

D4Y0 I DID that but no errors think I need to use Ajax inlinediv said, great! lol don't know Ajax at all can you guys help as I dont have time to learn it just to do this one bit of code pleassssse

Thanks guys for your input i really appreciate it, @D4YO it still doesnt display the query result in the textbox using your code

i agree with stephenOC but try http://www.codecademy.com it teaches you what you need but you have to complete tasks to progress really good way of learning

Hi guys (Again), I'm sorry to keep posting and i am trying to figure it out my self before posting (books, google etc) but cant really find anything that helps me; What I am trying to do is for the staff to type in a product number text box (number already in database (table 1)) and echo the product description in another textbox called "product description" ready for the form to be posted to the database (table 2); Heres the PHP please dont laugh at the code as i am still learning PHP: <?php include ("db.php"); $prodsearch1 = mysql_real_escape_string($_POST['productcode']); $prodfind = mysql_real_escape_string(mysql_query("SELECT productdescription FROM products WHERE productcode = '{productcode}'")); while($row5 = mysql_fetch_array($prodfind)); ?> and HTML: <div class="content" id="addpro"> <form style="text-align:right"action="saveproduct.php" method="post"> <div style="width:400px; text-align:right"> <div style="margin-left: 48px;"> Service Centre: <input name="servicecentre" type="text" /> </div> <br /> <div style="margin-left: 97px;"> PO Number: <input name="ponumber" type="text" /> </div> <br /> <div style="margin-left: 80px;"> Product Code: <input name="productcode" type="text" /> </div> <br /> <div style="margin-left: 80px;"> Product Description: <input name="proddesc" value="<?php include ("proddesc.php"); echo $row5;?>"type="text" /> </div> <br /> <div style="margin-left: 80px;"> Price: £<input name="price" type="text" /> </div> <br /> <div style="margin-left: 80px;"> Quantity: <input name="quantity" type="text" /> </div> <br /> <div style="margin-left: 80px;"> Total: £<input name="total" type="text" /> </div> <div style="margin-left: 127px; margin-top: 14px;"><input name="" type="submit" value="Add" /></div> </div> </form> </div> Thanks again guys really appreciate your patience