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!
Did you know?Explore Trending and Topic pages for more stories like this.
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
No comments posted yet
Your Answer:
Login to answer
121 
35 
Other forums
this code is not working????
it says this error.. Warning: Division by zero in ..
the variables are correct, so why is th
DB2 for z/OS, LUW, iSeries
Hello,
In this forum a lot of threads related to other members of the DB2 family than DB2 for z/OS
no idea what to do...
I'm fed up. I had issues with code that I have working on a different site that didn't work on my cu
Drawing Images in classes
I'm quite new to Object Oriented PHP. What I'm trying to do is draw some images but also have other
finding key position of specified value in multi-dimensional array
Code: $openedfile = fopen($tfc_file4, "r");
$rc = 1;
while(!feof($openedfile))
{<
Trigger tag in aspx is not coming
hi all ,iam new to ajax, iam using file upload inside the update pannel but right now i want to use
listing help
Hi,
at first, great new design!!! I like it,
i got a problem,
I want to list so
MySQL-PHP Query Results Help
Hello all. I'm hoping to be able to get some help in solving a problem with query/rowcount output. I
Relative path
I have a absolute path to an image - like so: C:/Program Files/Apache Software Foundation/Apache2.2/
tag inside php...
hi
Code: <?php
echo "<td width="$columnWidth%" align=&
| 
