So print out $query before you execute it and see what you're actually sending to MySQL. You're apparently sending a valid query, but it's not matching any rows...
---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ > -----Original Message----- > From: Beauford.2002 [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 18, 2002 11:28 PM > To: PHP General > Subject: [PHP] PHP and MySQL queries > > Hi, > > I am having a real problem with variables in PHP and trying to query my > MySQL database. I have a form that a user inputs information and then that > info is used to query my database, but it's not working. I don't get any > errorrs and it appears every thing worked, but nothing gets displayed (see > code below). I know the info is getting passed from the form as it appears > correct in the address bar of my browser. The query below also works if I > use the command line in MySQL and hard code the information. > > Any help is appreciated. > > http://etc/etc?FromTrade=TRUE&name=1&from=2 > > $query = "select tmanager.idn, tmanager.total, troster.idp, user, > position, > points from troster join treference > join tmanager where tmanager.idn=treference.idn and > treference.idp=troster.idp and tmanager.name like '$name' and > troster.player like '$from'"; > > $results = mysql_query($query) or die("Query failed"); > > while ($line = mysql_fetch_array($results, MYSQL_ASSOC)) { > > echo $line[idn]; > echo $line[total]; > echo $line[idp]; > echo $line[position]; > echo $line[points]; > > This just displays an empty page. So it appears the query found nothing, > but > like I said, it works from the command line and there should be one entry > (see below). So I have to assume it is a problem with the variables. > > +-----+--------+-----+--------+----------+--------+ > | idn | total | idp | user | position | points | > +-----+--------+-----+--------+----------+--------+ > | 1 | 746.75 | 2 | Trevor | F | 45.00 | > +-----+--------+-----+--------+----------+--------+ > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
