473,321 Members | 1,667 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

how can i display a search output like of this that could be clicked or have a link

this is my code
Expand|Select|Wrap|Line Numbers
  1. <?php
  2.     mysql_connect ("localhost", "root","")  or die (mysql_error());
  3.     mysql_select_db ("nsca_alumni");
  4.  
  5.     $firstname = $_POST['firstname'];
  6.     $lastname= $_POST['lastname'];
  7.     $year_grad= $_POST['year_grad'];
  8.     $country= $_POST['country'];
  9.     $sql = mysql_query("select * from mymembers where firstname like '%$firstname%' and lastname like '%$lastname%' and year_grad like '%$year_grad%' and country like '%$country%'");
  10.  
  11.  
  12.     echo "<center><table width='50%' border='0' class='tbody' cellpadding='5'>";
  13.         echo "<tr class='thead'> <th>First Name</th><th>Last Name</th><th>Year Graduated</th><th>Country</th><th></th></tr>";
  14.  
  15.     while ($row = mysql_fetch_array($sql)){
  16.         $ID =$row['id'];
  17.           $ID=$row['id'];
  18.  
  19.  
  20.     echo "<tr class='t_text'><td>"; 
  21.     echo $row['firstname'];
  22.     echo "</td><td>"; 
  23.     echo $row['lastname'];
  24.     echo "</td><td>"; 
  25.     echo $row['year_grad'];
  26.     echo "</td><td>"; 
  27.     echo $row['country'];
  28.     echo "</td><td>"; 
  29.  
  30.  
  31.  
  32. echo "</table>";
  33.  
  34. ?>
  35.  
how could i display like of http://alumni.guilford.edu/s/1397/in...&pgid=8&cid=46

when u search on this site like firstname or lastname.you will see the output..can u help me please about the code..thanks
Feb 5 '12 #1
0 1212

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Nicolla MacPherson | last post by:
Hi I'm a newbie and want to display a pattern that will increment with each line of display. I thought i might be able to count the rows and use that info to increment my display. I've got my...
0
by: Daniel | last post by:
for listbox is there anyway to get the event of a mouse over a particular list item? e.g. to display a bubble that shows the item incase the text is long and cut off by the text box?
4
by: Newbie | last post by:
Is it possible to set up an event handler or something else so that when *any* link on the page is clicked it 'fires-up', executes some JS and then continues to process the link that was clicked?...
1
by: Francois Suter | last post by:
Hi all, Now that I have an installation of PostgreSQL on Mac OS X 10.3.2 with national language support, I'm trying to get it to display in some other language, of course. Although my interest...
5
by: Martien van Wanrooij | last post by:
I have been using phpdig in some websites but now I stored a lot of larger texts into a mysql database. In the phpdig search engine, when you entered a search word, the page where the search word...
18
by: Terry Holland | last post by:
I have an asp.net (1.1) application that connects to a SQL server 2000 db. I have a stored procedure in my db that out puts data in xml format. What I need to be able to do is display that xml...
1
kirubagari
by: kirubagari | last post by:
rivate Sub cmdscan_Click() Const a As Byte = 4 Const b As Byte = &HFF Dim I As Long Dim AnyChanged As Boolean Dim changeMade As Boolean Dim value As Byte Dim x Dim tmp As String
1
idsanjeev
by: idsanjeev | last post by:
<%@ Language =vbscript%> <% Option Explicit %> <html> <head><TITLE>VOICE OF BARAUNIANS</TITLE></head> <body> <!--#include file="front.inc"--> <div style="Position:Absolute; width:700; TOP:0;...
3
by: FutureShock | last post by:
What would be the BEST way to output text to a webpage but only be viewable with 'view source', not HTML. The reason I ask is that I have been tasked to update some already created pages and...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.