Jump to content

Displaying Mysql Results As Hyperlinks - Get Variable


alalj23

Recommended Posts

Trying to pass my results from MYSQL statement as links to card.php. How do I echo out the results as clickable links to card.php passing a get variable so that I can use this variable in card.php. The links should be playerName.

<?php

include_once 'header.php';

 

$con = mysql_connect("localhost","*****","******");

mysql_select_db("cards",$con);

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

 

$sql = "SELECT * FROM cards ORDER BY RAND() LIMIT 4";

 

$results = mysql_query($sql);

$array = mysql_fetch_array($results);

 

$num=mysql_num_rows($results);

 

$i=0;

while ($i < $num) {

$array = mysql_fetch_array($results);

echo '<a href="card.php?cardid=' . $array->id . '">' . $array->name . '</a>';

echo "</br>";

$i++;

}

 

include_once 'footer.php';

 

?>

Well you already have this "$num=mysql_num_rows($results);" with the LIMIT 4 and because the data is returned in rows I use $row = mysql_fetch_array($results); Then

 

$sql = "SELECT * FROM cards ORDER BY RAND() LIMIT 4";

$results = mysql_query($sql);

 

if ($r && (mysqli_num_rows($r) >= 1)) { // run if there is data

while ($row = mysqli_fetch_array($results, MYSQLI_ASSOC)){

echo '<a href="card.php?cardid=' . $row['id'] . '">' .$row['name'].'</a>';

echo "</br>";

}

} else {echo 'Something or nothing here';}

Well you already have this "$num=mysql_num_rows($results);" with the LIMIT 4 and because the data is returned in rows I use $row = mysql_fetch_array($results); Then

 

$sql = "SELECT * FROM cards ORDER BY RAND() LIMIT 4";

$results = mysql_query($sql);

 

if ($r && (mysqli_num_rows($r) >= 1)) { // run if there is data

while ($row = mysqli_fetch_array($results, MYSQLI_ASSOC)){

echo '<a href="card.php?cardid=' . $row['id'] . '">' .$row['name'].'</a>';

echo "</br>";

}

} else {echo 'Something or nothing here';}

 

You can not use mysqli and mysql together in the same connection.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.