Help passing on an ID in a link for MySQLi

Hi,

I am trying to create a link in MySQLi to pass on an ID (RecipeID) from the result page to the detail page (recipe.php). I know how to do this using MySQL but have not done this in MySQLi. Could someone fill the gap for me?

Here is what I have so far (hope this is correct) and am missing the _______________ part:


<a href=recipe.php?RecipeID=<?php echo($rsRecipes->getColumnVal("RecipeID”)); ?> _________________ <?php echo($rsRecipes->getColumnVal("RecipeTitle")); ?></a>

Thanks a lot.

Best,
Joerg

it's really no different with MySQLi than with MySQL

the format is:

<a href="pagename.php?varName=<Dynamic Binding code for ID column>"><Dynamic Binding code for Lable column></a>

looking at your code, the missing part is a quote to close the href and less than to close the a tag. you are also missing the quote to open the href:

<a href="recipe.php?RecipeID=<?php echo($rsRecipes->getColumnVal("RecipeID”)); ?>"><?php echo($rsRecipes->getColumnVal("RecipeTitle")); ?></a>

Oooops. Looks like it was right there in front of me all the time.

Thanks so much for your help Jason.

Best,
Joerg

you're welcome.