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
Search found 14 matches
- Fri Oct 04, 2002 11:31 am
- Forum: Databases
- Topic: Access checkbox translates to tinyint(3) field in Mysql ...
- Replies: 3
- Views: 1295
- 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...
- 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...
- 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...
- 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. ...
- 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...
- 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,...
- 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 ...
Al
- 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...
- 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...
- 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 ...
- 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...
- 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...
- 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 = &...