search function

Posted on 16th Feb 2014 07:03 pm by admin

HI guys,

if anyone could point us in the right direction of how to do this, or provide some test code for a similar problem would be great!

Basically, I have user profiles on my site, and I have a search by for example firstnames will list all usernames with the first name 'bob'. With this list I want to turn the output of each name to a link to their profile.

the profile page is profile-view.php and I am using the statement "select username from members where firstname = $input";

and
$num_results = mysql_num_rows($result);


$username = $row['username'];

for ($i=0; $i <$num_results; $i++)
{
$num_found = $i ;
$row = mysql_fetch_assoc($result);
echo "<a href='profile-view.php?username = $username'>{$row['username']}</a><br/>";
}

I know the <a href> wont work, but is there anyway of being able to do this, all usernames are unique across the site too thats why I thought the link it by this.

Thanks in advance

Your Answer:

Login to answer

Other forums

getting rid of quotes in strings
sick of trying to deal with them in multiple ways (entering in and taking from database, echoing, ec

Calling strings from other php class
I have test1.php{
$string1;
$string2;
....
... //10 strings in this class <

How to display objects in a row
I have 7 codes that i want to display in a row one next to another.
The first is {$ads->ad

i have no idea why this isn't working
Code: <?php
session_start();
include("connect.php");

error_reporting(E

why aint this working?
i have this code:

Code: $num = 250;
$count = ($num - $rcount);

echo $rc

mail()
Hi all. I have a problem with emails. I am trying to set up a mail system where customers can subscr

Multiple if statements
Ok so seems basic but for some reason I'm not doing it right. What I want is to be able to have 2 se

mysql_real_escape_string
Let me preface this that I am very much a PHP noob, but I have some SQL training (not necessarily My

Consuming third party Payment Gateway API from Procedure.
Hi All,

First of all i would like to thank all the people of the oracle forum for providi

mod_rewrite.c on windows ??
why it's not working on windows while it's working on other hosts???

this is the code i got