rockindano30

no help?

hello all, i have a problem. this line here says that i have 0 records SELECT * FROM users WHERE Uname='user1' AND Pword='user1' but i realy have on record with user name (Uname) user1 and Password (Pword) user1 but if i do this it does show my record SELECT * FROM users WHERE Uname='user1'; and it also says that i have 0 records if i use SELECT * FROM users WHERE Pword='user1'; any help?

why won't this give me or show me my records? SELECT * FROM users WHERE Uname='{$Uname}' AND Pword='{$Pword}';

or it doesn't even display any records also if i use select * from users where Pword='user1'; im using MD5() to encrypt the Pword when its being add into db

yes, there are two records that im using for testing. it does display it the record with select * from users where Uname='user1'; but not with select * from users where Uname='user1' and Pword='user1';

Hello all i'm having a little difficulties with this sql syntax. SELECT * FROM users WHERE Uname='user1' and Pword='user1'; with the above sql syntax it returns 0 records and with SELECT * FROM users WHERE Uname='user1'; it returns one record. now i have two records in this database but having this problem. please help.

well thank you darkwater and others for your help. but this one is a dead project as of may 12, 2008 4:06

<table width="100%" border="0" cellspacing="0" cellpadding="1"><form method="post" action="searchemps.php"> <tr> <td colspan="4"><font style="font-size:12px; color: #000000">Type in name of employee to search:</font></td> </tr> <tr> <td width="22%"><font style="font-size:12px; color:#000000">First Name: </font></td> <td width="29%"><input type="text" name="search" size=15 maxlength=25></td> <td width="21%"><font style="font-size:12px; color:#000000">Last Name:</font></td> <td width="28%"><input type="text" name="search2" size=15 maxlength=25></td> </tr> <tr> <td colspan="2"><input type="Submit" name="Submit" value=" " style="background:url(images/searchbutton.png) no-repeat center; height:35px; width:70px; border:0px; cursor:pointer" /> </form></td> <td colspan="2"><form method="post" action="allKeys.php"> <input type="submit" name="vall" value=" " style="background:url(images/viewallbutton.png) no-repeat center; height:35px; width:70px; border: 0px; cursor: pointer" /> </form> </td> </tr> </table> </div> <div class="p" style="clear:both"> <div align="center"> <?php if(!($db = @ mysql_connect('server', 'username', 'password'))) { echo 'Error: Could not connect to our database sorry for any inconvience.<br /> Please try at a later time.'; exit; } //select which database you want to edit mysql_select_db("db name); $vall=$_POST["vall"]; if(!isset($vall) || empty($vall)) { print"<p>No employees in Database."; } else{ $emp_id=$_GET["emp_id"]; //get the mysql and store them in $result //change whatevertable to the mysql table you're using //change whatevercolumn to the column in the table you want to search $query = "SELECT e.*, k.*, d.dept FROM employees as e, emp_keys as k, departments as d WHERE e.emp_id = k.emp_id AND d.k_id = k.k_id"; $result = mysql_query($query); //grab all the content while($r=mysql_fetch_array($result)) { //the format is $variable = $r["nameofmysqlcolumn"]; //modify these to match your mysql table columns $dept=$r["dept"]; $asscc=$r["accss"]; $Fname=$r["Fname"]; $Lname=$r["Lname"]; $email=$r["email"]; $key_num=$r["key_num"]; $emp_id=$r["emp_id"]; ?> <table width="100%" border="0" cellpadding="1" cellspacing="0" class="table1"> <tr> <td width="14%"><font face="Arial, Helvetica, sans-serif"><?php print $dept; ?></font></td> <td width="17%"><font face="Arial, Helvetica, sans-serif" style="color:#CC6600"><?php print $Fname." ".$Lname; ?></font></td> <td width="28%"><font face="Arial, Helvetica, sans-serif"><?php print $email; ?></font></td> <td width="10%"><font face="Arial, Helvetica, sans-serif"><?php print $key_num; ?></font></td> <td width="50%"><font face="Arial, Helvetica, sans-serif"><?php print $asscc; ?></font></td> <td width="50%"> <?php print"<a href='delete.php?emp_id={$emp_id['emp_id']}'>Remove</a><br />";?> </td> </tr> </table> <?php }//end while loop } ?>

nothing no output. i think i'm just going to give up and trash this project.

nope doesn't display anything

sql line on my cmd prompt i have posted the output of the sql syntax that dark told me to run.

mysql> SELECT d.*, k.*, e.* FROM employees as e, departments as d, emp_keys as k LIMIT 1 \G; *************************** 1. row *************************** dept_id: 1 dept: City Manager's phone: 383-1800 k_id: 1 emp_id: 1 key_num: 3456 accss: data room, office emp_id: 1 dept_id: 1 Fname: Danny Lname: Vera email: dvera@ci.edinburg.tx.us 1 row in set (0.00 sec) ERROR: No query specified mysql>

it doesnt give me an error did the copy/paste but how can i copy cmd prompt

i dont know how to copy to and from cmd prompt

how can i add a image

that syntax gives me a an syntax error in my mysql client

it has to be a sql syntax problem but i can seem to figure it out.

k i ran the query in mysql client and it only displays the same thing half the records

it displays each employee thirty times and there are thirty employees. and if remove the while statement it doesn't display anything

k removing that displays all records (the whole table) thirty time

k heres an example: Department | Employee name | email | key_num | access | remove ------------------------------------------------------------------------------------------- Public Roxy Gomez ventura@mail.com 08998 blank Remove

lol no i'm not connecting to that, edit that part for the forum

this file is called allKeys.php oh yeah i forgot to type in that quote there my bad but thats not the problem. i have been breaking my head in trying to find why it only displays half my records

yes i'm connecting. as i mentioned it does everything works except that it only displays half my records