click on a link?

[timstring]

I'm trying to create an alphabetical index from a MySQL database. Here's the code I have so far:

if ($_POST[RecipeSearch] == "")
	{
		echo 'A<br />';
		$result = mysql_query("SELECT RecipeTitle FROM `Recipes` WHERE `RecipeTitle` LIKE 'A%'")
			or die (mysql_error());

	while ($row = mysql_fetch_array($result))
		{
			echo $row[RecipeTitle] . "<br /><br />";
		};

	

And repeated for every letter in the blooming alphabet. The routine works. What I would like to accomplish is to have a link associated with the list items. Here's the algorithm:

SQL generates a list;
click on one item;
set $RecipeSearth = $row[RecipeTitle];
jump to the next phase of the code, or would it be better to jump to another page?

I'm stymied. This should be simple, but I've complicated things.

[Weedpacket]

timstring wrote:

jump to the next phase of the code, or would it be better to jump to another page?

Since the code has already finished running by the time someone gets to click on any links, and going to another page is what clicking on a link does, the second is what you want.

You want to echo <a> tags around the text you want to make into a link, with a URL that goes to another page and includes something to identify which recipe to display the details for - probably an ID number; typically as part of a query string, then on that other page using the [font=monospace]$_GET[/font] array.

[timstring]

I understand what you said about the <a> attribute to generate a link. The code looks like this:

		echo 'A<br />';
		$result = mysql_query("SELECT RecipeTitle FROM `Recipes` WHERE `RecipeTitle` LIKE 'A%'")
			or die (mysql_error());

	while ($row = mysql_fetch_array($result))
		{
			$count++;
			$RecipeTitle[$count] = $row[RecipeTitle];

			echo '<a href="http://192.168.1.2/~tim/Recipes/RecallRecipe.php">' . $RecipeTitle[$count] . '</a><br />';
		};
	

However, I'm too wet behind the ears to figure out how to pass a variable from one page to the next. Wouldn't I need an 'onClick' function?

ty for the help
tim

[Weedpacket]

timstring wrote:

However, I'm too wet behind the ears to figure out how to pass a variable from one page to the next.

Well, I did mention "query string" - try it as a search term. But for PHP's implementation, there is the manual's section on external variables:

Using a GET form is similar except you'll use the appropriate GET predefined variable instead. GET also applies to the QUERY_STRING (the information after the '?' in a URL). So, for example, http://www.example.com/test.php?id=3 contains GET data which is accessible with $_GET['id'].

Which pretty much covers everything that needs to be said on the matter.

[timstring]

I understand now how to generate a search query and access it via $_GET. However, I'm still stuck.

This works:

echo '<a href="http://192.168.1.2/~tim/Recipes/RecallRecipe.php?RecipeTitle=Alfredo">'

I need RecipeTitle to equal $RecipeTitle[count], but this doesn't pass anything:

echo '<a href="http://192.168.1.2/~tim/Recipes/RecallRecipe.php?RecipeTitle=$RecipeTitle[count]">'

Kind sir, I appreciate the response, but you need to get off your high-horse and actually help someone.

[Weedpacket]

timstring wrote:

echo '<a href="http://192.168.1.2/~tim/Recipes/RecallRecipe.php?RecipeTitle=$RecipeTitle[count]">';

That would try to interpolate the value of [font=monospace]$RecipeTitle['count'][/font], which doesn't exist.
Try

 echo '<a href="http://192.168.1.2/~tim/Recipes/RecallRecipe.php?RecipeTitle=">' . urlencode($RecipeTitle[$count]);

where I've added [man]urlencode[/man] in case the title contains any characters that might mangle the URL.

If you have an ID number for your recipes, it would probably be more robust to use that to identify which recipe is being asked for.

Kind sir, I appreciate the response, but you need to get off your high-horse and actually help someone.

You're welcome.

[dalecosp]

Please remember that help comes in many forms; and that sometimes the best help is to teach someone to walk on their own. This kind sir's high-horse is well-earned ... those 20K posts weren't spent trolling about in the Echo Lounge like 50 percent of mine were.

[bradgrafelman]

Also remember that being an ass doesn't make Weedpacket or anyone else want to "help" you - where your definition of "help" probably means "work for you for free and spoonfeed you code that you can copy and paste."

[timstring]

I had the basics worked out, but nothing I tried helped. I would not have found the urlencode function without you.

You have an error in your sin tacks. The code should be:

echo '<a href="http://192.168.1.2/~tim/Recipes/RecallRecipe.php?RecipeTitle=' . urlencode($RecipeTitle[$count]) . '">'

ty
tim