how do i get this php script to print out a result from a mysql database?

G

Gaylord

New member
this is what i have so far..all the declaired variables are from a html form..

<html>
<head>
<title>Search Results</title>
<head>
<body>
<?
//establish connection with database system
$conn=mysql_connect(INFO GOES HERE);
mysql_select_db(NAME GOES HERE, $conn);

//read info from form and pass it to db
$searchData=$_REQUEST['searchData'];
$uniRep=$_REQUEST['ur'];
$orgRep=$_REQUEST['or'];
$interaction=$_REQUEST['int'];


//determine which radio button is checked and generates SQL query to use
if ($uniRep = 'true'){
$sql = "SELECT * FROM uniRep LIKE '%$searchData%'";
}
else if ($orgRep = 'true'){
$sql = "SELECT * FROM orgRep LIKE '%$searchData%'";
}

else if ($interaction = 'true'){
$sql = "SELECT * FROM interaction LIKE '%$searchData%'";
}

$result=mysql_query($sql);
 


Write your reply...
Back
Top