Problem with AJAX/PHP

[LeeMC1989]

Hi there, I'm not new to the forum but I have misplaced my other account..

 

This is a script where when you type a Album name it retrieves the album name from database.

 

Ok well heres my problem, I have a script that when typing something into a text input ajax requests are sent/recieved and displayed in a div with results, with this I have made it so can click the result and it will populate into the input.

 

I have tried to modify this the best I can but failed while doing so.., I have it set up so when you type the album name into the box it will retrieve the album name but when I click the result I want the album URL to populate the input box..

(Usually the thing you are searching for populates the input)

 

The problem is when I click the album its populating the input with any albumart URL and not the albums correct matching URL from database..

 

This probably sounds confusing :s..

 

Search Album in input > Click album result > Populate input with albumart URL from database

 

I'm sorry if I'm confusing you but I can't seem to be able to explain this properly :s..

 

<?php
// Fill up array with names

include("../connectvars.php");
$query = mysql_query("SELECT * FROM `Music` GROUP BY musicalbum");
$b=mysql_fetch_array($query);
while ($art=mysql_fetch_array($query)) {
$a[] = $art['musicalbum'];
$b[] = $art['musicalbumart'];
}

//get the q parameter from URL
$q=$_GET["a"];

//lookup all hints from array if length of q>0
if (strlen($q) > 0)
{

$hint="";
for($i=0; $i<count($a); $i++)
{

	if (strtolower($q)==strtolower(substr($a[$i],0,strlen($q))))
	{

		if ($hint=="")
		{

			$hint="<a href=# onclick=document.getElementById('malbumart').value='".$b[$i]."'>".$a[$i]."</a>";
		}
		else
		{

			$hint="<a href=# onclick=document.getElementById('malbumart').value='".$b[$i]."'>".$hint."</a> , <a href=# onclick=document.getElementById('malbumart').value='".$b[$i]."'>".$a[$i]."</a>";

		}
	}
}

}

// Set output to "no suggestion" if no hint were found
// or to the correct values
if ($hint == "")
  {
  $response="No AlbumArt Suggestions";
  }
else
  {
  $response=$hint;
  }

//output the response
echo $response;
?>

 

I guess a way to explain this..

 

DATABASE EXAMPLE:

AlbumName1 | Albumart1

AlbumName2 | Albumart2

AlbumName3 | Albumart3

 

Okay so if I search Albumname1 in the searchbox and click the name it should populate the box with Albumart1 (But it doesn't it populates it with some other albumart..) I want the matching albumart to match up with the album name..

[gizmola]

I have a hard time following the code.  But I can tell you this is wrong:

 

 

$query = mysql_query("SELECT * FROM `Music` GROUP BY musicalbum");
$b=mysql_fetch_array($query);
while ($art=mysql_fetch_array($query)) {
$a[] = $art['musicalbum'];
$b[] = $art['musicalbumart'];
}

 

You fetch one row and assign it to $b. If you var_dump($b) after that line I think you'll be surprised by what it contains.  Then you proceed to fetch other rows, but now you add additional array elements, each of which is the contents of the 'musicalbumart' column.  Things would be a lot cleaner if you just did this:

 

$query = mysql_query("SELECT musicalbum, musicalbumart FROM `Music` GROUP BY musicalbum");
while ($row = mysql_fetch_assoc($query)) {
  $rows[] = $row;
}

 

Now you have an array ($rows) which has one entry for each album/albumart row in the database.

 

Truly this is a mess. 

 

I'm not sure why you're trying to make 2 arrays when 1 will do.  I don't really understand you 

 

[LeeMC1989]

Well my friend got it from this site http://www.w3schools.com/ajax/ajax_aspphp.asp, I recoded it with your code and now it says "No Albumart found" for everything I search, I can't seem to figure it out...

[LeeMC1989]

Well thanks for the help , I just recoded the whole thing using my own knowledge.. and it works like a charm now!

[gizmola]

Sorry about the trailing off above.. i was going to write something like I don't understand your approach to .... whatever, but I trailed off and posted that accidently. 

 

At any rate, I'm glad you got things sorted out, and hopefully I put you on the right track.