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

session variable problem
Session variable is not working in Fire fox i am getting null value but it is working fine in IE.

Array to string conversion
Can anyone help me with this?

Notice: Array to string conversion in /home/..../index.php on l

Making multiple rows with one query
I have a table called efed_handler_characters with two fields handler_id and bio_id. What query 2 is

Shuffle between users ??
I have multiple $users in table. I need to send them $message.

I need to send the next messag

Trouble verifying database password
Thankyou to everyone who responded to my last post (I can't find the posting, it has been buried). <

timed header image rotation
I have a joomla site and I was trying to setup a rotating image based on timing NOT just refreshing

Receive Rosettanet Message to SAP 4.6c
Dear all ,

My customer will send the PO details by rosettanet message , Is it

Values disappear from my array :( HELP!
hey all, I have a lil mysql/php/apache script that queries a database
and pulls put 5 integers.

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

Execure stored procedure on a timer
Can someone tell me an easier way to execute a stored procedure on a timer? I am using Oracle 10g R