Hi,
Finally got the first drop-down to appear, I'd put '\n' in the php
rather than "\n" - Oooops!!
Still not sure how to get the second field on my form to update based
on the input to the first autocomplete, any suggestions?
This is what I've tried:
$(document).ready(function(){
$("#lotno1").autocomplete("../js/autocomplete.php?SaleNo=103", {
matchContains: true,
mustMatch: true,
});
$("#descno1").autocomplete("../js/autocomplete.php?SaleNo=103", {
extraParams: {
first: function() {
return $("#lotno1").val();
}
}
});
});
The two columns from the db are 'LotNo' and 'Description' returned
from the php as:
echo ($row['LotNo'].$row['A'].'|'. $row['Description']."\n");
I need $row['LotNo'].$row['A'] => to #lotno1 (this works) and
$row['Description'] => #descno1
Thanks
Matt
On Aug 27, 10:13 pm, Mattl <[EMAIL PROTECTED]> wrote:
> Hi Jorn,
>
> I now have the following based on your suggestion to populate the
> second input field:
>
> $(document).ready(function(){
>
> $("#lotno1").autocomplete("../js/autocomplete.php?SaleNo=102", {
> matchContains: true,
> mustMatch: true,
> });
>
> $("#descno1").autocomplete("../js/autocomplete.php?SaleNo=102", {
> extraParams: {
> first: function() {
> return $("#lotno1").val();
> }
> }
> });
>
> });
>
> where 'autocomplete.php' looks like:
>
> <?php require_once('../../../Connections/Oundle_DB.php'); ?>
> <?php
> $SaleNo = ($_GET["SaleNo"]);
> $q = strtolower($_GET["q"]);
>
> mysql_select_db($database_Oundle_DB, $Oundle_DB);
> $query = "SELECT `LotNo`, `A`, `Description` FROM batemans WHERE
> `SaleNo`
> LIKE $SaleNo ORDER BY LotNo ASC";
> $result = mysql_query($query, $Oundle_DB) or die(mysql_error());
> while($row=mysql_fetch_assoc($result))
> if (strpos(strtolower($row['LotNo']), $q) !== false) {
> echo ($row['LotNo'].$row['A'].'|'.
> $row['Description'].'\r');}
>
> ?>
>
> You can view the page
> at:http://www.batemans-auctions.co.uk/new_site/absentee_form.php
>
> (first input box under 'Lot No' is where to type, any number between 1
> and 500:
>
> If I enter '1' the autocomplete does not return all values in the
> mySQL field that
> contain a '1', I thought adding matchContains: true, would fix this,
> any ideas?
>
> Also when clicking the value from the drop down, it does not populate
> the
> second field (id= descno1) with the coresponding value from the
> Description
> column, any ideas?
>
> Many thanks for your support.
>
> Regards
> Matt
>
> On Aug 27, 1:05 am, VirusMinus <[EMAIL PROTECTED]> wrote:
>
> > Hi Jorn,
>
> > Is there a way to call a function when no results are returned by the
> > input the user has typed into the autocomplete?
>
> > This would be ideal as an option or a method for the autocomplete
> > object.
>
> > I've seen a few people ask for this on your site and also here. You
> > mentioned including such functionality in a future release but I don't
> > think it was done.
>
> > Anyone mange to do this or have pointers on how I could go about
> > implementing it myself?
>
> > If I succeed maybe we can add this as a feature to the current build
> > of autocomplete?
>
> > Cheers,
> > VM
>
> > On Aug 27, 8:04 am, "Jörn Zaefferer" <[EMAIL PROTECTED]>
> > wrote:
>
> > > The download includes demo PHP scripts that you can look at. Or check
> > > it online
> > > viahttp://dev.jquery.com/view/trunk/plugins/autocomplete/demo/search.phps
> > > (linked fromhttp://jquery.bassistance.de/autocomplete/demo/)
>
> > > Jörn
>
> > > On Tue, Aug 26, 2008 at 10:11 PM, Mattl <[EMAIL PROTECTED]> wrote:
>
> > > > Thanks Jörn,
> > > > Is there a tutorial or demo that shows what the php file that queries
> > > > the db should look like, or in what format the results need to be
> > > > returned in?
>
> > > > ie what does 'my_autocomplete_backend.php' look like?
>
> > > > I've not been able to find one.
>
> > > > Thanks in advance,
> > > > Matt
>
> > > > On Aug 25, 11:32 pm, "Jörn Zaefferer" <[EMAIL PROTECTED]>
> > > > wrote:
> > > >> The autocomplete plugin
> > > >> (http://plugins.jquery.com/project/autocompletex) can do that. Set the
> > > >> one up as usual, and configure the other one with a dynamic extra
> > > >> paramter:
>
> > > >> $("#second").autocomplete("url", {
> > > >> extraParams: {
> > > >> first: function() {
> > > >> return $("#first").val();
> > > >> }
> > > >> }
>
> > > >> });
>
> > > >> Jörn
>
> > > >> On Mon, Aug 25, 2008 at 11:22 PM, Mattl <[EMAIL PROTECTED]> wrote:
>
> > > >> > Hi,
> > > >> > Anyone know of a jQuery plugin similar to the Autocomplete that could
> > > >> > do the following?
>
> > > >> > I have a mysql db with two columns, 'Lot No' and 'Description'.
>
> > > >> > I have a form with two input fields, 'Lot No' and 'Description' and
> > > >> > I'd like the 'Description' input field to be auto-populated from the
> > > >> > database based on the entry the user puts into the 'Lot No' input
> > > >> > field.
>
> > > >> > ie if they typed in '1' into the 'Lot No' field then the
> > > >> > 'Description'
> > > >> > input field would call up the corresponding row entry to '1' from the
> > > >> > database.
>
> > > >> > Hope I've explained this clearly enough...
>
> > > >> > Many thanks
> > > >> > Matt
