Welcome Guest ( Log In | Register )



2 Pages V  < 1 2  
Reply to this topicStart new topic
> Wondering If I'm Having A Code Problem Or If Its My Database
Hercco
post May 25 2006, 05:52 AM
Post #11


Super Member
Group Icon

Group: Members
Posts: 595
Joined: 4-September 04
Member No.: 228



It must the queries. Syntax-wise there's nothing wrong with them but it must be something. I recommend you print out errors generated by mysql_query, it might help to solve the issue or better yet do as the guys before proposed, run the queries directly in the database.

You can run the queries easily from phpMyAdmin or from command line if you have SSH access. Or you could just create a small PHP test page that connect to the database and run the queries and print out errors. Just don't use any user input, just fixed values that will give some results.

In this kind of situations debugging is usually the best option. Staring and analyzing your code tends to be quite hard. I know from experience that I tend to screw up with SQL and usually I create the query, run it on the database and then insert it into the code.


Go to the top of the page
 
+Quote Post

2 Pages V  < 1 2
Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. phpBB Database Transfer(10)
  2. Embedded Database(7)
  3. Need Advice On Creating Online Music Database(6)
  4. Mirror My MySQL Database To Another Mysql Server(4)
  5. The Best Database(48)
  6. Database Program With GUI(14)
  7. MySQL Output Database Question(18)
  8. What Is Maximum Capacity Of Astahost MySQL Database?(11)
  9. Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database(4)
  10. Permission Problem With Mysql Database Creation(8)
  11. Need Info On Database Programming Courses(2)
  12. Database Programming In Vba 6.0(1)
  13. How Many Concurrent Users For Oracle Database?(1)
  14. Database Size?(10)
  15. My Sql Database Help?(3)
  1. Need Help In Database Auto_increment(9)
  2. Connecting To A Remote Database(9)
  3. Database(1)
  4. Integrate Access Database Onto Intranet Site(5)
  5. Accessing Ms Access Database From A Centralized Location?(5)
  6. Mysql Database Management(1)
  7. Mysql Database Entry By Excel Sheets(2)
  8. Space Needed For Database(10)
  9. Database Access On Remote Server W/jsp(0)
  10. Some Useful Database Links.(7)
  11. Best Database(13)
  12. How To Understand A Database Schema(4)
  13. Free Or Opensource Database/schema Browser?(6)


 



- Lo-Fi Version Time is now: 5th December 2008 - 04:53 PM