I have a textbox that will search the employee database by entering in the employee ID and it will return the result on the same page.
Query
Code: if(isset($_GET['findagentid']) && $_GET['findagentid']<>""){
$emp_id = $_GET['findagentid'];
mysql_select_db($database_cnccoems, $cnccoems);
$query_rsagentquery1 = "SELECT tblEmployees.employee_pdl_mgr_id, tblManagerOverrides.manager_id, tblEmployees.employee_first_name, tblEmployees.employee_last_name, tblEmployees.employee_id FROM tblEmployees LEFT JOIN tblManagerOverrides ON tblEmployees.employee_id = tblManagerOverrides.employee_id WHERE tblEmployees.employee_id LIKE '%$emp_id%' ";
$rsagentquery1 = mysql_query($query_rsagentquery1, $cnccoems) or die(mysql_error());
$row_rsagentquery1 = mysql_fetch_assoc($rsagentquery1);
$totalRows_rsagentquery1 = mysql_num_rows($rsagentquery1);
if(!is_null($row_rsagentquery1['manager_id'])){
$manager_id=$row_rsagentquery1['manager_id'];
}
else
{
$manager_id=$row_rsagentquery1['employee_pdl_mgr_id'];
}
}
Form
Code: <form method="get" id="agentretrieval" action="callDetail1.php">
<table align="center" cellpadding="2" cellspacing="0">
<tr>
<td><div align="right">Find Agent Info :</div></td>
<td><div align="left"><input type="text" name="findagentid" id="findagentid" class="textboxstyle" size="10" maxlength="7" /> (Digits Only)</div><div class="accenttext"><?php echo $tNGs->displayFieldError("NS_data", "flagentTID"); ?></div> <div align="left"><input type="submit" class="button1" name="findagentbutton" id="findagentbutton" value="Find" /></div></td>
</tr>
</table>
</form>
This works great if entering in digits only like 845787 as they are stored in the database like 00845787. Problem I have is that the ID's are sometimes retrieved by users from another DB with a letter infront of the numbers (eg t845787 or x845787) in one database, but the one I retrieve from has no letter in front.
Hard to explain. Basically Im trying to accomplish this. They can put t845787 in the text box, hit search and it will strip off the t or x from the ID and search the database.
Did I explain that right? Can't figure this out
type check while uploading
Hi Everyone,How can I check the exact type of a file while uploading on my site?Here is the scenario:I have allowed only .jpg, .gif, .png files to be uploaded on my site. Suppose an user renames his
Typing math
I've added support for typesetting math using LaTeX on the forums.Example:Code: [Select][tex]\sum_{n = 0}^\infty \frac{1}{n!} = \lim_{n\to\infty} \left(1+\frac{1}{n}\right)^n = e[/tex]Outputs:Just in
PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page will use code to pull information from a database and display it on the page in a formatted way.Code:
FTP Programs
Here is a list of commonly suggested FTP Programs to use:FileZillaSmartFTPCuteFTPRightFTPCoreFTPJFTPFireFTP
Creating web pages by php
Hello again,I was just wondering us there a way to use a php script to create a new web page. I guess the best example is something like YouTube where when a video is uploaded, it's assigned a new
Code doesn't print what i wanted it too. Please help!
Hi there,I wrote this code to mae it so that in the form before it that the user said their username and then on this page it matches up the username with the username on the database and then uses
Parse Error Help
Hello, I got the parse error "Parse error: syntax error, unexpected ',' in register.php on line 21Heres the code:Code: <body
Multiple server callbacks (NOT POSTBACKS)
Hello,
Paypal
Hi all,I have an advanced basic knowledge of php I want to try something new for a site I am working on, its a members site with a monthly fee for being a member of the site. Basically what I want to
PHP and Javascript
Hi Guys,Im trying to load the contents of an html file into a text area for editing, this is the code I have so far but it doesnt seem to be working. I think it's because some of the $line have
