Displaying Mysql Results As Hyperlinks - Get Variable

[alalj23]

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';

 

?>

[floridaflatlander]

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';}

[MDCode]

  On 12/4/2012 at 1:23 AM, floridaflatlander said:

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.

[floridaflatlander]

  On 12/4/2012 at 1:39 AM, SocialCloud said:

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

 

Yes,I just copied and pasted and should use mysqli if at all posssible.