Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesOracle Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today!
  #1  
Old April 16th, 2004, 02:48 PM
jumpyg jumpyg is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Mar 2004
Posts: 5 jumpyg User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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.

Reply With Quote
  #2  
Old April 17th, 2004, 09:58 AM
jumpyg jumpyg is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Mar 2004
Posts: 5 jumpyg User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
I think I solved the problem. I was not doing a commit. After committing, I could run my queries from PHP. Like I said, I'm new at this.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesOracle Development > Queries work in sql*plus, but not PHP


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway