Re: [PHP] Difference of queries in PHP/mySQL?
Check the return value of mysql_query(). It should either evaluate to false, or true. If false, then output some error messages using mysql_error() and mysql_errno(). -JasonGarber IonZoftDotCom At 01:29 PM 11/17/2001 -0500, Jeff Lewis wrote: I am wondering if there are any difference between using PHP and using the command line for mySQL. Entering this at the comman line returns all the membergroups properly. When I use this in my PHP program, it doesn't continue past this line: $request = mysql_query(SELECT membergroup FROM membergroups WHERE 1 ORDER BY ID_GROUP); Jeff -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Difference of queries in PHP/mySQL?
I am wondering if there are any difference between using PHP and using the command line for mySQL. Entering this at the comman line returns all the membergroups properly. When I use this in my PHP program, it doesn't continue past this line: $request = mysql_query(SELECT membergroup FROM membergroups WHERE 1 ORDER BY ID_GROUP); Jeff -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Difference of queries in PHP/mySQL?
are you actually doing anything with $request? that just gets a mysql result back in a variable, you then have to extract the data from it... Jeff Lewis wrote: I am wondering if there are any difference between using PHP and using the command line for mySQL. Entering this at the comman line returns all the membergroups properly. When I use this in my PHP program, it doesn't continue past this line: $request = mysql_query(SELECT membergroup FROM membergroups WHERE 1 ORDER BY ID_GROUP); Jeff -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]