Search found 13 matches

by rainbow
Sat Nov 16, 2002 11:27 am
Forum: Databases
Topic: trouble with decode function
Replies: 6
Views: 1374

Thanks for help! Now it 's more or less clear. In Oracle, it can be used to remap values, sort of like a simple case statement (or like an expanded IFNULL function). Is there an analog to this in MySQL? Well, i don't know exactly. I'm not sure if there is that kind of function in MySQL, which is lik...
by rainbow
Sat Nov 16, 2002 2:35 am
Forum: Databases
Topic: trouble with decode function
Replies: 6
Views: 1374

to twigletmac: Yep, i'm getting an error message.

to MeOnTheW3: ok, but should be the second value ? I mean that $pass_str ?
About the column type:yes, it's blob in the database
by rainbow
Fri Nov 15, 2002 2:25 am
Forum: Databases
Topic: trouble with decode function
Replies: 6
Views: 1374

trouble with decode function

Hi folks! I have a trouble running encode function in MySQL. The code is something like this <?phpif(!($insert = mysql_query("INSERT INTO ct_assistant VALUES(NULL,'$student_id','$a_username', ENCODE('$ct_assistant_pwd'))",$con))) { Error(sprintf("Internal Error %d:%s\n",my...
by rainbow
Sat Sep 07, 2002 3:14 pm
Forum: PHP - Code
Topic: deleting files and folders
Replies: 9
Views: 1128

to Takuma:
This also mean that I'm useless
Don't worry. :lol: Actually the idea about the problem came to my mind after you said , that i don't need to use chdir.
So, you are not useless :D
by rainbow
Sat Sep 07, 2002 2:26 pm
Forum: PHP - Code
Topic: deleting files and folders
Replies: 9
Views: 1128

Thanx people for replies! :) I guess i figured out what was the problem. The problem was with while loop. Because actually sometimes it needs to run few times to delete few folders. But it occured so that it ran across empty or none existing folders, because they have been already deleted at first r...
by rainbow
Sat Sep 07, 2002 4:14 am
Forum: PHP - Code
Topic: deleting files and folders
Replies: 9
Views: 1128

deleting files and folders

I have some problem with deleting files and folders. I have a script that deletes the files and folders inside another folder. Here it is: <?php $centre_id = 16; if(!($result11 = mysql_query("SELECT ct_centre_id, ct_centre_name from ct_centre WHERE ct_centre_id = '$centre_id'", $con...
by rainbow
Tue Aug 27, 2002 10:32 am
Forum: General Discussion
Topic: problems changing mode
Replies: 1
Views: 1997

problems changing mode

I need to move a web site to a server. So when i want to change the mode of files, ftp says: "500 'SITE chmod ... ' command not understood. !Chmod failed. It might be not understood on a remote site." It says this always no matter what mode i change it to. And because of that the images ca...
by rainbow
Sat Aug 24, 2002 1:55 pm
Forum: PHP - Code
Topic: What does it mean?
Replies: 2
Views: 558

Thanks a lot ! :)
by rainbow
Sat Aug 24, 2002 1:21 pm
Forum: PHP - Code
Topic: What does it mean?
Replies: 2
Views: 558

What does it mean?

I'm working on a script which has been developed by another person. It deals with folder removing. Here is the part of code: if ($dir = @opendir("$dir2remove")) { while (($file = readdir($dir)) !== false) { if (!($file=="." || $file==".." || $file==&qu...
by rainbow
Sat Aug 24, 2002 2:33 am
Forum: Databases
Topic: MySQL suddenly quits
Replies: 5
Views: 1709

Anyway,I found the bug. :D The problem was that the table didn't have a primary key specified for some reason. But again it's a bit weird that MySQL reacted to this problem in a such way. It could just give an error
by rainbow
Fri Aug 23, 2002 1:18 am
Forum: Databases
Topic: MySQL suddenly quits
Replies: 5
Views: 1709

Starting with MySQL Version 3.23.13, you can check MyISAM tables with the CHECK TABLE command.

Yeah, you are right, the problem with "check table" is in the version. :(
by rainbow
Thu Aug 22, 2002 3:08 pm
Forum: Databases
Topic: MySQL suddenly quits
Replies: 5
Views: 1709

Thanks for the advice, maybe i should really try to reinstall MySQL .
I also tried to use 'check table' . But when i typed "CHECK TABLE table_name EXTENDED;" it gave an error that there's something wrong in this query ? Is there ?
by rainbow
Thu Aug 22, 2002 6:03 am
Forum: Databases
Topic: MySQL suddenly quits
Replies: 5
Views: 1709

MySQL suddenly quits

When I want to add the data to one table, after clicking on a submit button, MySQL shows the message "DBUG: Test signal" and then it says that "this program has performed an illegal operation..." and it closes the connection. I tried to add the data both with a php script and wit...