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

How to find OS bit version
How can I tell the person browsing my site is running 32, or 64 bit operating system?

this code is strange !
Hi i got this code from the web.. It checks for live and dead socks
It is working perfectly on my

Using real time in php
I'm very average at PHP and im looking to introduce time to something on my site.
Its a sports si

PHP SUBMIT
Code: <input name="doLogin" type="image" src="images/loginsubmit.jpg

question about n
I was looking at some of the things you could do with php and one of the things I have tried is n.<

empty() error
Why does

Code: empty($USER_ID = $_SESSION["USER_ID"])
create this error...

=> and <=
So I was digging through some code when I came across the <= operator. This is the first tim

Redistributing dependent dlls
Hai all ,

I have created an application in VC++ using VS2008 in a development machine which r

Limiting uploaded file type
I am working on a simple upload script, and I need it to limit the allowed file type that is uploade

Upload file and add HTML
Hey everyone,

I have a client has meeting agendas and minutes that should be posted online. I