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

am I using this for loop correctly
Dear buddies!

Right now I am generating a report with some details for all the dealers.

PHP code for a proxy
I was wondering which function I could use to create an online proxy tool. I was thinking cURL would

Text to picture Generator
Hello, i have found this script and it works really good^^ But i have one problem, i would like to c

Using system() and bringing back the results
I am aware that you can use system() within PHP to execute system commands, but I was wondering if t

Probably Easy, Need help with Check Boxes in PHP Code
hello,

Thanks for looking this over and helping me out. My problem is I have a online store l

What are the two different files you download to update kernel?
What are the two different files you download to update kernel?

Month String to Numeric?
Hi guys,

Given a month as a string, is there a simple way to find the numeric representation

gmdate() - want 1 hr before time
Hi,
I am using php gmdate().
Now I am entering all dates in my dbase using gmdate("Y-m-d

Generate multilayered array from string.
ok so i have a string that looks like this:
Code: blog:edit_all,delete_all|users:edit_all,delete_

PHP mail() returns true but doesn't work
First off I apologize if this is a newbie question, and I generally don't like asking questions that