Search found 3 matches

by tylerg
Wed Jul 28, 2004 4:51 pm
Forum: Databases
Topic: MySQL ENCODE() question
Replies: 2
Views: 306

cheers -

you were right! and I realized that I also had 2 mySQL quotes closing values, rather than regular single '

thnx
by tylerg
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...
by tylerg
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`,...