Suddenly having trouble..

SephirGaine · #1 Aug 4th, 2006, 21:26

I really don't get this.. however I had this script working flawlessly yesturday, and I went to change a couple things, and now suddenly it's not working properly. I am entirely confused as to why, because as far as I know, I didn't change a single thing. But here it is.. lemme know if you guys see anything wrong. Otherwise I'll have to assume something's up with my DB..

Code: Select all

<?php
    $query = "SELECT * FROM `EMPLOYEES` where loginName='$logname'";
        $result = mysql_query($query) or die(mysql_error());
        while ($text = mysql_Fetch_assoc($result)); {
            echo ''.$text['name'].'<br>
            '.$text['phone'].'<br>
            '.$text['email'].'';
            }
?>

<?php
    $query = "SELECT * FROM `Techs` where name='$Tech'";
        $result = mysql_query($query) or die(mysql_error());
        while ($text = mysql_Fetch_assoc($result)); {
            echo ''.$text['Name'].'<br>
            '.$text['Phone'].'<br>
            '.$text['Email'].'';
            }
?>

ukgeoff · #2 Aug 4th, 2006, 22:29

First problem is case sensitivity.

Code: Select all

while ($text = mysql_Fetch_assoc($result)); {

Both of these lines in your code have a uppercase 'F' which should be lowercase.

Second problem.

Code: Select all

$query = "SELECT * FROM `EMPLOYEES` where loginName='$logname'";

In both these line, you don't need the single quotes around the table name and I prefer coding like;

Code: Select all

...loginName='".$logname."'";

Potential third problem.

Code: Select all

echo ''.$text['name'].'<br>
         '.$text['phone'].'<br>
         '.$text['email'].'';

Unless you did this when you posted the code, PHP will think you have unterminated lines, etc.

SephirGaine · #3 Aug 4th, 2006, 23:28

Aye, it was kind of a combination of all the above. However the single quotes around the table name are actually backticks.. not necessary in most cases, but I tend to use them to be precautionary.

Thanks a lot!

Compumaniac12 · #4 Aug 9th, 2006, 11:58

SELECT * FROM `EMPLOYEES` where loginName='$logname

i always used the thought ``='' like `loginName`='$logname'

(do that incase you ever have a column named table or where or any mysql commands, so it doesnt get confused.

also, never capitalize columns or you will get very confused.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Having trouble with PHP	voodoo465	PHP Forum	5	Feb 20th, 2007 21:47
Browser trouble?	sheltomlee	Starting Out	4	Jan 28th, 2007 21:47
CGI Trouble	Maverick25r	Other Programming Languages	0	Jul 31st, 2006 18:24
js menu suddenly disappeared in ie	mendel69	JavaScript Forum	7	Jul 31st, 2006 17:16
Text suddenly awful in Photoshop 7	autumn_whispers2me	Graphics and 3D	4	Jun 12th, 2006 12:51

		Webforumz.com > Main Forums > Program Your Website > PHP Forum
Suddenly having trouble..