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

Rss feed question
Hi

My blog and my website are different. Am i able to take my rss feed
from my blog and p

login page does not execute a else statement
I've created a login page using sessions.
When an incorrect user name or password is entered then

Big Problem!! Please help
Hi Guys,

Im making a website for a friend have encountered a really annoying problem. When ev

Need help urgant
why down my code ony return one item instead of all the items selected.

$arr = array($date,$

Pspell with my own dictionary
Hello!
I've tested two cases using pspell functions.
1)
Code: $dictionary_link = pspell_new

Parse XML
Good day,

I use oempro software and try to parse XMLReturn but it's not working for me, simpl

styling a RadioButtonList
HiI need to have a radio button and close to it, its lable, then a space then another set of those.

SQL Injection
In my attempts to protect my database from mySQL injection I have created another problem for myself

Functions Not Loading Into Div
I had some help doing some of this but what I'm trying to do is get my functions to retrieve its val

have trouble in a if condition
The if below is working ok, it check when indexes, name, zipcode and state are empty.
Code: &