you were right! and I realized that I also had 2 mySQL quotes closing values, rather than regular single '
thnx
Search found 3 matches
- Wed Jul 28, 2004 4:51 pm
- Forum: Databases
- Topic: MySQL ENCODE() question
- Replies: 2
- Views: 306
- Wed Jul 28, 2004 2:27 pm
- Forum: Databases
- Topic: MySQL ENCODE() question
- Replies: 2
- Views: 306
MySQL ENCODE() question
I'm getting an error in my SQL syntax, can't figure out where it is... can anyone spot it? insert into `Client` (`Client_id`,`fname`,`lname`,`email`,`name`,`password`) values('598','tyler','ganske','tyler.ganske@gems2.gov.bc.ca`,encode(administrator1,'tyler1')) and I tried insert into `Client` (`Cli...
- Wed Jul 14, 2004 3:42 pm
- Forum: PHP - Code
- Topic: PHP POST via HTML SUBMIT - unique value pass
- Replies: 2
- Views: 289
PHP POST via HTML SUBMIT - unique value pass
Thought this would be a easy fix, but alas, no other forum has been able to help me... I will show you the code first and then explain the issue... //GET DRILLS BASED OF PYRAMID SUBCATAGORIES $query2 = "SELECT distinct `Drill`.`Drill_id`, `Drill`.`Drill_title`,`Sub_cat`.`Sub_desc` FROM `Drill`,...