Search found 15 matches

by Fife Club
Wed Oct 29, 2003 7:21 pm
Forum: mySQL & php coding
Topic: Updating records thru page form doesn't work. Please help.
Replies: 3
Views: 859

I have now narrowed down the root of the problem, but I don't know why it won't work. All the problems stem from form elements that are pulldowns. <select name="league_organization"> <option selected>Government <option>Private Business <option>Religious </select> will cause ALL entry field...
by Fife Club
Tue Oct 28, 2003 6:49 am
Forum: mySQL & php coding
Topic: Updating records thru page form doesn't work. Please help.
Replies: 3
Views: 859

Updating records thru page form doesn't work. Please help.

You can read this first post if you want but I've since narrowed down the cause of the problem. See 3rd post I'm a novice looking for some help. I have this php page I use to update data in a table and it's worked fine for years on another site of mine. Now I'm trying to use this same code on a new...
by Fife Club
Fri Sep 12, 2003 12:25 pm
Forum: mySQL & php coding
Topic: Easy table "linking" question: how to
Replies: 2
Views: 704

Very nice article. Thanks.
by Fife Club
Fri Sep 12, 2003 7:30 am
Forum: mySQL & php coding
Topic: Easy table "linking" question: how to
Replies: 2
Views: 704

Easy table "linking" question: how to

I've got the this php page that displays the results of my mySQL database table. This unimpressive work marks the limits of my mySQL experience, but I want to learn more so I ask for your help. In particular, can somebody please show me how to make use of a second table. I read about primary key an...
by Fife Club
Thu Dec 12, 2002 6:36 am
Forum: PHP coding => General
Topic: browser & version detect
Replies: 3
Views: 1383

Thanks. In total I tried 6 different code suggestions. Only two worked for my specific needs. Here are the two codes incase somebody else needs something like it: <? $browser = strtolower($_SERVER["HTTP_USER_AGENT"]); if (strstr($browser,"opera")) { $...
by Fife Club
Tue Dec 10, 2002 11:21 am
Forum: PHP coding => General
Topic: browser & version detect
Replies: 3
Views: 1383

browser & version detect

Hi everybody. I was wondering if somebody could help me out. I don't know diddly squat about php except for echo and print and to always put a \ before a quote. I'm working on a page that absolutely needs absolute positioning (css) but I've learned that some browsers just screw it up so bad that I n...
by Fife Club
Tue Oct 22, 2002 6:20 pm
Forum: mySQL & php coding
Topic: limit per page with Previous / Next Links
Replies: 1
Views: 5337

limit per page with Previous / Next Links

Somebody else made this suggestion for limiting results to 15 per page with previous/next links: Have a $page variable... -------------------- if(!isset($page)) { $page = 0; } $per_page = 15; $limit = $page * $per_page; $query = "SELECT * FROM table LIMIT $limit,$per_page"; -------------------- Some...
by Fife Club
Tue Oct 15, 2002 9:13 pm
Forum: mySQL & php coding
Topic: Linking a row to diplay further information
Replies: 1
Views: 1425

Linking a row to diplay further information

I've got a list of names. I want to make the names a link, that will go to a second page which will display much more info about that name (more information from that same row - according to id field). I'm new and I've been trying a bunch of stuff for hours and I'm just not getting it right. Rather ...
by Fife Club
Mon Oct 14, 2002 7:53 am
Forum: phpMyAdmin
Topic: Importing table from text file
Replies: 3
Views: 2576

Follow Up: I kinda figured it out - or at least I found a work around. It seems that the spaces in each row after the first were caused by the "return" that brought me to the next line. The way I fixed it was to put notepad in no-wrap and to backspace the beginning of every row so it immediately fol...
by Fife Club
Fri Oct 11, 2002 2:02 pm
Forum: phpMyAdmin
Topic: Importing table from text file
Replies: 3
Views: 2576

Well if somebody knew why it was happening and how to avoid it, it would be pretty easy for me to reimport the data. Otherwise, are you saying that I can instruct mySQL to take the first field of every row, remove the space (or the first character), and leave the remaining characters in tact? How is...
by Fife Club
Fri Oct 11, 2002 6:57 am
Forum: phpMyAdmin
Topic: Importing table from text file
Replies: 3
Views: 2576

Importing table from text file

I have a text file that I successfully uploaded into a mySQL database table. The only problem is that starting with the second line, every row places a space before the first item in the row. This causes a problem because when I sort by the first column ("lastname"), everyrow after the first sorts, ...
by Fife Club
Fri Oct 11, 2002 6:42 am
Forum: mySQL & php coding
Topic: how do you deal with blanks in this example
Replies: 4
Views: 2079

Hooray!!! Thanks!!! It worked great. I then made a few very minor adjustments with spaces, commas, and parenthesis, but I was only able to do so because your example showed me how to structure it.

:D :D :D
by Fife Club
Thu Oct 10, 2002 7:17 pm
Forum: mySQL & php coding
Topic: how do you deal with blanks in this example
Replies: 4
Views: 2079

Use the print statement instead of printf if (!empty($myrow['maidenname'])) print "(".$myrow['maidenname'].")"; Thanks, but since I'm just starting out I don't know what to do with it. I tried removing the "f" and that gave me errors. Plus I'm not sure ho...
by Fife Club
Thu Oct 10, 2002 1:47 pm
Forum: mySQL & php coding
Topic: how do you deal with blanks in this example
Replies: 4
Views: 2079

how do you deal with blanks in this example

Here's my page: m And here's my code that I adjusted from tutorial examples: <html> <body> <?php $db = mysql_connect("localhost", "pstvalu_director", "XXXXXXX"); mysql_select_db("pstvalu_directory",$db); $result = mysql_query("SELECT *...
by Fife Club
Wed Oct 09, 2002 8:29 pm
Forum: mySQL & php coding
Topic: Several Newbie Qustions
Replies: 2
Views: 1766

Several Newbie Qustions

First things first. This site is a great resource. Glad I found it. Now some background. Like most of the people posting questions, I'm very new to both php and mySQL. I'm only stumbling thru all this stuff because of one database I wanted online. After just a few days screwing around with online t...