passing two variables

brauchi

I am running into a small problem. i would like to pass two variable in a hyperlink.

here is the part of the script that seems to have a problem as no values are actually passed to the next page when following the hyperlink.

$dbcnx=@mysql_connect("localhost","root","jan1971tenth");
mysql_select_db("jokes");
$jokelist=@("select joketext, id, JokeCategory from jokes");

while ($joke=mysql_fetch_array($jokelist))

  {
   $id = $joke["id"];
   $textjoke = $joke["joketext"];
   $categoryjoke = $joke["JokeCategory"];
   echo ("<a href='article_test.php?textjoke=$joketext&categoryjoke=$jokecategory'>$textjoke<a/>"."<br />");
  }

thank you in advance

andrea

J_ystick_FI

you shuol have to concatenate the variable names with operator . that concatenates two strings..

echo ("<a href='article_test.php?textjoke=".$joketext."&categoryjoke=".$jokecategory."'><?=$textjoke?><a/>"."<br />");

.......................this way shuold work

😃 J@ystick_FI😃

brauchi

I tried to use this code. but now none of the hyperlinks show up. with the code i had before i saw the hyperlinks -- although they didn't work.

J_ystick_FI

are u sure they are not empty ?

try these before:

echo($joketext);
echo($jokecategory);

if it is, the problem is in your sql-query

😃 J@ystick😃

brauchi

the variables are not empty. i wtook a look into the mysql database and saw that there are values assigned to those variables.

i didn't get any outcome when using the plain echo-thing. but i will try to figure it out. thank you for your help anyway

Rohan_Hill

If you didn't get any outcome using the plain echo thing, the variables are empty. You must have a problem with the database.

cahva

Well, I see a little bug in your code:

$categoryjoke = $joke["JokeCategory"];
echo ("<a href='article_test.php?textjoke=$joketext&categoryjoke=$jokecategory'>$textjoke<a/>"."<br />");
}

You first use $categoryjoke for your $joke['JokeCategory'], but you are using $jokecategory in your href which doesnt exist.
So change $jokecategory to $categoryjoke in your echo and it should work.

brauchi

ok now i have the four links on my screen. there are still two problems
1.) the links looks as if i am only passing the first variable
2,) nothin shows up on the landing page

code for orginal page
while ($joke=mysql_fetch_array($jokelist))

  {
      $joketext = $joke["joketext"];
   $JokeCategory = $joke["JokeCategory"];
   echo ("$joketext");

echo ("<a href='article_page.php?joketext=$joketext.&JokeCategory=$JokeCategory'>read more<a/>"."<br />");
}

code on landing page
<?php

echo $JokeCategory;
echo $joketext;

Thank you in advance

Andrea

cahva

Well, you could use htmlentities() function in your echo:

echo ("<a href='article_page.php?joketext=".htmlentites($joketext)."&JokeCategory=".htmlentities($JokeCategory)."'>read more<a/>"."<br />");

I quess thats why it takes only the first variable. Plus you had an . for some reason after the $joketext in your echo. Whys that?

If nothing shows up when you click read more. It could be that register_globals are turned off(like they should be), so when you call them on the second page, use $GET['joketext'] & $GET['JokeCategory']. But in my opinion, dont put the $joketext in the link. Instead put the id number of the joke to that. In that way, you can select the joke in second page just by fetching the row from the table which has the id-number.