Search results for query: *

It's true that phpBB is affected. However, it's not just phpBB. Other forum boards are also affected. More importantly, it's not just forums. It's PHP itself where the problem originates. The following is from phpBB web site: ____________________________ JustKIDn...

kenrbnsn, Thanks for that bit of code. That was what I needed. However I had to add; selected = $i And to get it to work correctly, I also added; }else{ echo '>'.$sample[$i].'</option>'; } I had played with the selected attribute earlier, but I just couldn't figure out the correct...

When I select an item from a dropdown box and submit. It works correctly, but then when the list is displayed again, it doesn't show what was selected, but rather, the first item in the list. So i.e. if "Select Item" is the first thing on the list. That's what you always see. Another example...

...the dept. I modified what you gave me to include the dept. (you forgot the dept!) print "Results from query <br />"; $sql = mysql_query("SELECT * FROM `tbl_jobs`"); if (!$sql) { //No Connection to the Database. } else { //Connection is OK. $sql_num_rows = mysql_num_rows($sql)...

ArkM, Thanks, but that didn't get me any closer than I was. I'll try to explain differently; tbl_jobs has a list of all the different jobs. tbl_job_link just has links from tbl_people to tbl_jobs. If a person had no jobs, there would be no record for him in tbl_job_link (because there would...

Chessbot, That worked great! I made some modifications, like changing the name of variables etc. But it does exactly what I wanted it to. Now I don't have to log into my server and run phpMyAdmin all the time just to run a simple query. If I could give you more stars I would! Thanks...

Here are the tables; tbl_people - pkey - primary key - dept - varchar - name - varchar etc... tbl_jobs - jkey - primary key - desc - varchar (job titles) tbl_job_link - lkey - primary key - ljkey - foreign key (ties with tbl_jobs.jkey) - lpkey -foreign key (ties with tbl_people.pkey)...

Oh, of course, That's the stuff I have in my db_link.php file. Thanks, I'll give it a try and let you know how it turns out. ____________________________ JustKIDn ____________________________ Families can be together forever...

Chessbot, This looks like just what I've been trying to get to. Judging by it's completeness and how quick you came up with this. You must have had this snippet laying around. Where do I find this getInfo() ? Is it inside youre database.php file? It looks to me, this won't work without your...

...have so far works great. However, I need it to be flexible, in that it needs to be able to pull data from any of the tables / fields. i.e. SELECT * FROM tbl_address When I code for this I have no way of knowing what table or fields have been called for. How can I print the results if the...

You're welcome, Thank you for the help. Without the help, there would be no stars! [roll2][&nbsp;][&nbsp;] [roll1][&nbsp;][&nbsp;] [spin][&nbsp;][&nbsp;] [spin2][&nbsp;][&nbsp;] [spin][&nbsp;][&nbsp;] [roll1][&nbsp;][&nbsp;] [roll2] ____________________________ JustKIDn...

Vragabond, nl2br() was the answer I needed. I know you should be careful with nl2br because if HTML tags are inserted into the textarea, problems could arise. For this application, I won't have to worry about that too much. I will be the primary user and there are 3 others and they know...

That's a good idea to add trim(). Another question. This is related. If I enter some text in the TEXTAREA and press enter and add more text. The next time I display the text in a TEXTAREA box. It displays correctly, complete with newlines/carraige returns etc. On the other hand, if I display...

Thanks for the help! It's fixed. It turns out, it's not always good to code neatly. In my code, I had; <textarea name="ud_notes" rows=3 cols=33><? print "$notes"; ?> </textarea> As I do with many items like this, if the line is long, I like to have the closing tag on the next line so it's...

DaButcher, Thanks for your input. I don't know why I put the variable in quotes. I think I did that in another piece of code with javascript, and had to put it in quotes to make all the syntax work. Then I just copy/pasted it somewhere else and then again, and again, etc... you get the idea...

In one of my forms I use; <textarea name="ud_notes" rows=3 cols=33><? print "$notes"; ?></textarea> It works fine except, if it's an existing record, when you enter into the field, the cursor lands about 60 or 70 charactor spaces in from the beginning. How do I get it to start at the...

thanks bcastner. I had looked through there, but I didn't know it was called "common tasks". ____________________________ JustKIDn ____________________________ Families can be together forever...

Thanks linney, We tried the first one (from Doug Knox). After a reboot the problem was gone. You get a S T A R Question; how did it get on there? ____________________________ JustKIDn ____________________________ Families can be together forever...

r937, I need to apologize. I was about to say it won't work because lpkey is never null. But as I looked closer at your code, I realized that it sets up a one to one relationship. So if there's no match in lpkey to pkey then that is a null. I had tried doing it with joins but I hadn't thought...

...can't find the answer to this. This is one thing I've tried that seems like it should work. select pkey, name from tbl_1 where not exists (select * from tbl_2 where lpkey = pkey) lpkey from tbl_2 is a foreign key to pkey from tbl_1 I just want to list the names of those whose key from...