Search found 14 matches

by os2al
Fri Oct 04, 2002 11:31 am
Forum: Databases
Topic: Access checkbox translates to tinyint(3) field in Mysql ...
Replies: 3
Views: 1295

Thanks for the checkbox info

It's kind of what I thought; that is, that the tinyint(3) field didn't make a lot of sense. At least, that is what I figure you're saying, as well as providing the rest of the checkbox info.

I'm thinking of what to do with what I have, and thanks for your help.

Al
by os2al
Sun Sep 29, 2002 12:44 pm
Forum: Databases
Topic: php form to do multiple searches mysql
Replies: 9
Views: 2099

One more question, if you will ...

Thanks again. I have one more question, if you don't mind. When I try to get input from a checkbox into a MySQL database, it doesn't seem to accept it. I'm not positive the problem is with the checkboxes, but I suspect that it might be. My SQL translator, which is great, creates a tinyint(3) field i...
by os2al
Wed Sep 25, 2002 2:26 pm
Forum: Databases
Topic: php form to do multiple searches mysql
Replies: 9
Views: 2099

Code above

I'm talking about the code that is above. It works by a pull-down menu to select a topic and a word is input into a search form. I'm wondering how I might be able to have it take input from a checkbox that limits the search, either in addition or in place of the pull-down menu. To wit, you check a b...
by os2al
Tue Sep 24, 2002 6:24 pm
Forum: Databases
Topic: php form to do multiple searches mysql
Replies: 9
Views: 2099

Modifying the search from a checkbox ... How?

Takuma or Volka, Would you be able to tell me how I could add a checkbox on my form side, allowing choice of a "Country" or some other field, to modify the search using the code above? I'm trying to put on a checkbox to limit searches, but I'm not sure how I would get that to function usin...
by os2al
Mon Sep 16, 2002 9:02 pm
Forum: Databases
Topic: php form to do multiple searches mysql
Replies: 9
Views: 2099

Code for basic search, not exactly what you want but ...

I'm rather new at this myself, but I have gotten some good help here, so let me try to offer you some help. I have a working search below for you that searches a MySQL database. (I don't think you said what database you are using, but I'm guessing it's MySQL.) Of course, the answer is in two parts. ...
by os2al
Sun Sep 15, 2002 10:41 pm
Forum: Databases
Topic: Access checkbox translates to tinyint(3) field in Mysql ...
Replies: 3
Views: 1295

Access checkbox translates to tinyint(3) field in Mysql ...

Hello, I have an Access-to-Mysql translator, which works very well, except I'm stuck on one thing. I think the problem with my query not working is that I'm feeding checkbox data into the field, tinyint(3), which is the field type the translator created from an Access database checkbox. I ended up d...
by os2al
Sun Sep 15, 2002 10:19 pm
Forum: PHP - Code
Topic: Have code here for displaying data but ... need help ...
Replies: 9
Views: 1469

Works as before the change

:o Well, it works just as it did before. The window opens and the data shows, the only "problem" (if this is a problem) is that it's a different window but one that doesn't allow me to use the browser's back button to go back to the list. To get to the list again, I have to switch windows,...
by os2al
Fri Sep 13, 2002 9:10 am
Forum: PHP - Code
Topic: Have code here for displaying data but ... need help ...
Replies: 9
Views: 1469

Well, it's the same ...

8O Sorry to say, despite your heroic efforts, that the code does the same thing, from what I can see. Much appreciate your effort, though.

Al
by os2al
Tue Sep 10, 2002 8:13 am
Forum: PHP - Code
Topic: Have code here for displaying data but ... need help ...
Replies: 9
Views: 1469

Sorry about the English ...

:? As I tried to explain but didn't well enough, so that the data appears not on the same page as the list but in a way that let's me move back and forth to the list using the brower's Back button -- on a new web page is perhaps I'm trying to say. Just as, say, when you login to a site, you could go...
by os2al
Mon Sep 09, 2002 7:42 pm
Forum: PHP - Code
Topic: Have code here for displaying data but ... need help ...
Replies: 9
Views: 1469

Many thanks, Volka ...

:D Followed your instructions and they worked perfectly, so I am very grateful for your help. You truly are a master and could teach Yoda a few tricks. I'm ashamed to ask for anything else, but it would be that the data opens in a way that would allow me to use the browser's back button to go back a...
by os2al
Sun Sep 08, 2002 9:34 pm
Forum: PHP - Code
Topic: Have code here for displaying data but ... need help ...
Replies: 9
Views: 1469

Have code here for displaying data but ... need help ...

This bit of code displays member names in a <li> list </ul>, and when you click on a member name in the list, it shows you the data (name, address, city, state, zip) from a Mysql database at the bottom of the same list page; in other words, on the same page. Click on any name, you get the data info ...
by os2al
Sat Jun 29, 2002 5:29 pm
Forum: Databases
Topic: mysql-php question re: clickable listed fields
Replies: 4
Views: 2267

Almost got there. Any suggestions to finish it?

Can you tell me what's wrong with this someone? I can only get the last record in the database to list the info, when I wanted to be able to click on each name on the list and get database information. Thanks in advance, again. <? $db_name = "database"; $table_name = "table"; $co...
by os2al
Thu Jun 27, 2002 3:29 pm
Forum: Databases
Topic: mysql-php question re: clickable listed fields
Replies: 4
Views: 2267

"Data" I almost got it but ...

Much appreciate your help, but I haven't quite got it working, and you'll see why, I'm sure, in following post when you see what I've got. There is a line out of place or some such thing. I seem always to be printing out the last record even though I see each record name listed by their name as I dr...
by os2al
Tue Jun 25, 2002 3:26 pm
Forum: Databases
Topic: mysql-php question re: clickable listed fields
Replies: 4
Views: 2267

mysql-php question re: clickable listed fields

I hope I explain this well enough. I can access my Mysql database and get a list of record_id fields as in below in a list: ... $sql = "SELECT record_id, name ... etc. FROM $table_name "; $result = @mysql_query($sql,$connection) or die("Couldn't execute query."); $member_list = &...