search query in mysql in php problem

Posted on 16th Feb 2014 07:03 pm by admin

my search query wont work, i know, that my codes are correct.please help

Code: [Select]<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<div id="insidebox1">
<form name="form3" method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">

<tr><td><p>physician_ID: <td><input type="text" name="pat5" id="pat5" size="15" maxlength="11" value=""/></p></td></tr>
<tr><td><p><input type="submit" name="btn7" id="btn7" value="Search Physician"/></p></td></tr>


</form>
</div>
</table>

<?php
if (isset($_POST['btn7'])) { echo "<center/><a href='physicians.php'>Check the search results
</a></p>";
mysql_query("SELECT * FROM physicians WHERE Physician_ID={$_POST['pat5']}") or die (mysql_error());

}

Your Answer:

Login to answer

Other forums

script and html conflict in trying to create a header.
I have an error is occurring because of an html webpage with a "php require" at the top of

code help - pagination
Hi all, I have this code, basically a user logs into my site and they get this page.

The pro

Run function every 5 mins ??
I have a function PostMessage()

How can I run it every 5 mins ??

Packet Design
Hi All,
Im new about network programming and I want to design a protocol but I have some question

Rss feed question
Hi

My blog and my website are different. Am i able to take my rss feed
from my blog and p

SESSION question
I am building an application , a directory for auctions.
For SEO i made a script which copies a p

PHP Blog help
Need help with posting comments in a word press blog? I have a comments page where the comments are

Displaying pictures
i have worked my way through storing images in directory and storing the location in mySQL db.Now i

Problem with Subscreen
Dear Experts ,
I am facing a problem with the subscreens. My senario is as follows :

PHP / MySQL Associative Multidimensional Array:
Hello.

I have data in a MySQL Table that adheres to the below: (note, no index, could add if