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

Image DPI
Hi.

I allow users to upload images, the user then is able to adjust several settings for the

At max how many columns is advisable to create in a table/view
Hi All,
I have two transaction table from which i want to create a simple view or material

All possible combinations of String in PL/SQL
Hi All,

Could you please explain the logic of getting all possible combinations of String

MS are the best!!!
Visit http://www.microsoft.com/australia/windows/default.aspx?h=watch-a-demo and click the massive '

Multi language - seo links
Im trying to figure out the best method to have a multi language website that will function with seo

send message to the java application
Oracle 10g with Windows platform.

I have a java application that periodically pings the d

Trying to add functions to table
I have this list of characters and I'm trying to figure out what I have to do to put the results of

limitations on array_unique()
Does any one know what/how imitations are applied to array_unique? I have an issue where no matter h

How to write on database when a link is clicked?
Hi, I have a list of products in a gridview. When the link is clicked currently it takes to an ext

dropdown menu
Hello everbody,

I am php newbie.
I need to develop a program that once click the drop do