Member Avatar for ayesha789

Dears
I am using Query, then I use mysql_num_rows for finding number of records, and then echo Num_rows.
Now I want to make a hyperlink on count so it can show all details of query in new <div>.
How I can make echo"$num_rows \n"; dynamic link.

$result = mysql_query("SELECT * FROM lims_payment WHERE `crDate` LIKE '0000-00-00' AND `cDate` NOT LIKE '0000-00-00' AND `Reasons` !=  ''");
$num_rows = mysql_num_rows($result);
echo "$num_rows \n";
  • 2 Contributors
  • 1 Reply
  • 72 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by praveen_dusari
Member Avatar for praveen_dusari

link to num rows?
do you mean like this

echo "<a href='youpage.php?id=$num_rows'>$num_rows</a>";
Edited by praveen_dusari because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.