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

Dealing with code in db query
I am dealing with C code and I need to make sure it is encoded some how to ensure its integrity and

insert mysql embeded videos as blobs?
Using TinyMCE my client will be able to embed images and flash videos into large columns of text whi

Request-URI Too Large
I have created a simple submit form for a mysql database that puts a piece of code into database.<

Display search result
Hi!

I have a SQL database with information about albums and track (music).

This is wh

unexpected T_SL without a shift left token
Nothing too see here, I'm an idiot and resolved the problem.

selectbox+database connection retrive problem
Code: [Select]
<tr>
<th align="left" scope="c

disabling a button server-side then re-enabling client-side breaks button postback
I have a tabbed container and a button (not in the container) on a page. If the first tab is selecte

Passing vars to the DB
I have 3 small testing tables:

ID TYPE
1 pepperoni
2 C. bacon
3 taco

ID TY

Connection Timeout
I'm using xmii 12.0

I'm calling a transaction as a web service from a windows application

Can I use a loop
Hi buddies!

Once again with my doubts here.

Right now I am using this sql stat