two column searching the same record in database

-

i want use 2 column typing words match database

in 1 column ,it works

but in tow column , first 1 disable

 

the first column c_staffname

the secord column c_stafftel

 

and have code here

$colname_data = "-1";

if (isset($_post['c_staffname'])) {

  $colname_data = $_post['c_staffname'];

}

$colname_data = "-1";

if (isset($_post['c_stafftel'])) {

  $colname_data = $_post['c_stafftel'];

}

 

mysql_select_db($database_lungfung_conn, $lungfung_conn);

$query_data = sprintf("select * db_client c_staffname %s", getsqlvaluestring("%" . $colname_data . "%", "text"));

$query_data = sprintf("select * db_client c_stafftel %s", getsqlvaluestring("%" . $colname_data . "%", "text"));

$data = mysql_query($query_data, $lungfung_conn) or die(mysql_error());

$row_data = mysql_fetch_assoc($data);

$totalrows_data = mysql_num_rows($data);

 

as result

by using c_stafftel , can find record

however , using c_staffname , cannot display record

try replacing code this:

 

 

$colname_data = "-1";

if (isset($_post['c_staffname'])) {

  $colname_data = $_post['c_staffname'];

$query_data = sprintf("select * db_client c_stafftel %s", getsqlvaluestring("%" . $colname_data . "%", "text"));

} elseif (isset($_post['c_stafftel'])) {

  $colname_data = $_post['c_stafftel'];

$query_data = sprintf("select * db_client c_staffname %s", getsqlvaluestring("%" . $colname_data . "%", "text"));

} else {

echo "no search term provided";

}

 

mysql_select_db($database_lungfung_conn, $lungfung_conn);

$data = mysql_query($query_data, $lungfung_conn) or die(mysql_error());

$row_data = mysql_fetch_assoc($data);

$totalrows_data = mysql_num_rows($data);



More discussions in Dreamweaver support forum


adobe

Comments

Post a Comment

Popular posts from this blog

Illustrator CS6 Ocurrío un error E/S en el archivo.

-
este error me me sale cada ves que guardo un archivo que ya estado trabajando varias veces, sale cuando ya esta finalizando el proceso de guardar, ya probe cambiar nombre del archivo, ubicación de guardado, convertí curvas las fuentes y sigue saliendo el mismo error, no se que mas hacer, si alguien le ha sucedido y sabe como solucionarlo por favor ayuda. versión exacta (acerca de illustrator) de illustrator? versión sistema operativo?   guardas en el disco duro principal del ordenador o en otro disco, memoria pendrive,...? ese disco que clase de disco, modelo, antiguedad, espacio libre,...? More discussions in Foro en español adobe
Read more

Why is os_ViewContainer running?

-
when open illustrator (cc) opens window os_viewcontainer cannot view or close. shows in taskbar second window illustrator when mousing on ai icon. have tried select no luck. have tried clear using red x, no luck. close when close illustrator. wondering why there , if should concerned. oh, running windows 10. hi ccsachs,   as per query when launch illustrator opens " os_viewcontainer "   i request please share screenshots along below-mentioned details:   exact version of illustrator  graphic card using , when updated last time how performs in safe mode? ( https://support.microsoft.com/en-in/help/12376/windows-10-start-your-pc-in-safe-mode ) if works fine in safe mode please share antivirus using?   regards srishti More discussions in Illustrator adobe
Read more

Animate - problem with duplicating scripts after loop

-
hi all,   i have problem simple button script @ first frame. fine when timeline playing first time. after when timeline loops , stop again @ 0 frame button script fireing 2 times, when loops third time fireing 3 times etc...   here script:   this.stop(); exportroot.mc_cta.cursor = "pointer";   this.mc_cta.on("click", clickfunc.bind(this));   function clickfunc() {     console.log("clicked");     eb.useractioncounter("clicked");     exportroot.gotoandplay(1); }   anybody ideas? wrong?   thanks! kris use:   this.stop(); exportroot.mc_cta.cursor = "pointer";   if(!this.alreadyexecuted){ this.alreadyexecuted=true; this.mc_cta.on("click", clickfunc.bind(this));   function clickfunc() { console.log("clicked"); eb.useractioncounter("clicked"); exportroot.gotoandplay(1); } } More discussions in Adobe Animate CC - General adobe
Read more