Recent content by joep

Hello, After succesfully installed MySQL i have to change the password of the administrator. In the user table of the mysql database stands the User 'root' and no password filled in (seems normal to me) For Host i've filled in the localhost plus my domain. (i think thats' all normal, right?)...

Hello, Can someone explain me how to uninstall MySQL on a FreeBSD UNIX machine? (so no .rpm) Can i just delete all the mysql folders and related files or do i find problems doing that? Best regards Joep

Thanks to you all. Joep

Column

No and yes. It's either UPDATE or INSERT. That depends on what i want. The connection_id is made by INSERT or updated by UPDATE. I just want to be able to write information to two databases at one time. Joep

Allright, that makes sence. But i don't understand some things (I'm dutch.... ha ha) Can you give me a concrete answer? I'll explane the need: I've to INSERT var1, var2, var3 in tableA and var4 in tableB with the tableA_id = tableB_id. (These id's are not the auto_increment_id and primory but...

MySQL 3.22.32 with php3 installed. (I didn't tested the other answers yet because i was out of office all day. Tomorrow i'll work with those. But if you have new information.. Please !!) Greets, Joep

Doesn't work. Sorry. Greets, Joep

Hello, With the following string you can update/fill a table: ------------- $sql = "INSERT INTO tableA (name,address,fax,email) VALUES ('$name','$address','$fax','$email')"; ------------- That's easy ands works. But now i want to insert values to another table at the same time. I...

Hello, With the following string you can update/fill a table: ------------- $sql = "INSERT INTO tableA (name,address,fax,email) VALUES ('$name','$address','$fax','$email')"; ------------- That's easy ands works. But now i want to insert values to another table at the same time. I...

Hello,<br><br>I want to print the results of a query horizontal in colums instead of the usual rows.<br>'Normally':<br>result 1<br>result 2<br>result 3<br>etc.<br><br>My idea:<br>result 1 ¦ result 2 ¦ result 3 ¦ etc.<br><br>I thought something out like this:<br>&lt;?<br>$sql = &quot;SELECT *...

Hello,<br>I hav written 3 scripts. All with a little bit of other output.<br>What i want to do is let the script decides which piece it has to read. (you know, if/ else etc.) The 'problem' is that the script has to 'look' to the value of an ENUM (i've got an ENUM with three choices) and then...

Hello,<br><br>Thanks for the reply.<br>But that wasn't the problem. I had forgotten single quotes (') after $opstartcd $webmail etc.<br>Ofcourse i had to connect first. But this piece of script only works when the 'submit' button is pressed. (first line)<br>Thanks anyway.<br><br>Joep

Hello, <br><br>I've got three checkboxes on which i want to search for results in my database. Code: <br>--------------------------- <br>if ($submit) { <br><br>if ($webmail ¦¦ $opstartcd ¦¦ $telnet) { <br>$sql = &quot;SELECT * FROM access WHERE &quot;; <br><br>if ($webmail) <br>{$sql .=...

Hello,<br><br>I have a searchform where i want to be able to search for persons who are married and display the selected records in a table. That's going o.k.<br>But if i don't check the checkbox, there has to be a 'zero' value so that all the records in the database will be displayed. What am i...