
April 16th, 2004, 02:48 PM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 5
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Queries work in sql*plus, but not PHP
Hi,
I am new to using PHP to interface with Oracle. I am developing a video store database for class. I have a nice web interface in PHP that I was using successfully to run queries. However, I recently added a column to one of my tables. I then deleted all of my tables and recreated them with the extra column using scripts I have. After I did this, I can no longer get queries to work properly with my Web interface--I never get any results.
I have the query output to the screen for debugging purposes, and when I copy the query and run it in sql*plus, the query returns results. Why is it working in sql*plus, but not PHP? Everything was working before, but now nothing! I don't get any error messages when I run the queries--it's just not returning any rows. I tried restarting Apache, etc. I'm on Windows XP using Apache 1.x and the latest version of PHP.
Thanks for any suggestions!
Last edited by jumpyg : April 16th, 2004 at 03:30 PM.
|