I'm re-raising an issue I never quite resolved which has become more
critical. I want to sort a table on two columns. There are about 440
rows of which about 400 are blank in the first sort column (CBC); the
other rows show B in that column. When I use the coding below, the two
column sort t
On Thu, 4 Mar 2004 10:55:20 -, Ford, Mike [LSS]
<[EMAIL PROTECTED]> wrote:
On 03 March 2004 17:07, [EMAIL PROTECTED] wrote:
I'm re-raising an issue I never quite resolved which has become more
critical. I want to sort a table on two columns. There are
about 440
rows of which
On Fri, 5 Mar 2004 15:59:47 -, Ford, Mike [LSS]
<[EMAIL PROTECTED]> wrote:
On 05 March 2004 14:49, Ken Colburn wrote:
Mike -
I've tried your options and I get either an error message, no
sorting, or sorting that does not do both columns with B's at the
top. It's my understand
How can I have the explanation above a php table on a sort come out as
something different than the sort coding? For example, the sort line
below results in the following text above the sorted table: "Data Set
Sorted by (ssa1202.total/vapall.vapall)*100 in Descending Order". I'd
prefer simply
I'm not clear on your question. The code I quoted, set forth below, has
the text that ends up above the table. The following introduces the
series of column headings with sort statements (of which the initial code
is one):
# write out title
if ($sort_order == "asc") {$sort_title = "Ascending"
I asked this question several weeks ago; search for kc68 on this list
archives and you should find the more complete response. The coding with
my fields is:
?sort_field=cbc asc, net_receipts&sort_order=desc Play with the order and
asc and desc as another response suggested. What's
This should be ultimately simple; it just doesn't work. I want to limit
display to rows from a single table in which the status column contains
i. Only options are i, c, o. After the select line I have "where status
= i" (no quote marks). I get an error message to the "while" line that
cal
$get_data_query = "select state, cd, representative, status, party,
netreceipts,
individualcontributions, paccommcontributions, candidatesupport,
netdisbursements
from fec33104
where status = i
order by $sort_field $sort_order";
**
On Sat, 29 May 2004 07:50:52 -0700, Daniel Clark <[EMAIL
How do I put two tables, one below the other, on a single web page using
php? Each table is in the database. I have tried repeating the entire
script calling the second table, and placing this below the initial
script. I have also tried starting the second script where the select
language be
I get only the table headings and text before and after the table, but not
the table, when I add the "where" clause as below. Without the "where"
clause, the table does come up but (as expected) is repetitive and very
long. I'm using a template that I've used many times. I've tried
chang
I am trying to limit results pulled from two tables, each with all states
and
congressional districts, to specified congressional districts. I want
each college to
appear once matched to each congressional district (that is in one table
and is easy to do)
and also include a column from a sec
How do I write a link which results in a page with part of the data in the
mysql table and do that multiple times on a single php script page? That
is, I want to be able to click on state names on a single page and bring
up a page with only that state's data. I understand use of the "where"
That sounds like it, but help me a step further as I work from a template
and haven't fully absorbed the syntax. My basic query is:
$get_data_query = "select a, b, c from table order by $sort_field
$sort_order";
Where do I put the syntax you suggest? Where do the words go on which to
cli
I have a table created from two mysql tables which shows all Members of
Congress with related data. The Representative's name is pulled from one
sql table and the data from another sql table. When the php table comes
up on the web page, the name of the Representative for Maryland's 2nd
di
Here's the query (actually pulled from 3 sql tables; no joins):
"select
109fh4.rep,
veteransdata04.state,
veteransdata04.cd,
109fh4.party,
1091vote224.vote1091224,
veteransdata04.vetpop,
veteransdata04.totalexpend*1000,
veteransdata04.totalpatients,
veteransdata04.medexpend*1000,
veteransdata04.
That didn't do it. I tried with parentheses around the 109fh4.rep and
without the parentheses. The really curious thing is that the repetition
only happens within Maryland and starts with the second Maryland entry.
The next state is Maine (alphabetical by the abbreviation ME) and there is
I made tiny changes to my php file and sql table and the table won't come
up. I updated the table name (and php file name) from 109fh5 to 109fh6.
In the table, I changed 6 cells, leaving a couple blank. Then I changed
only the digit "5" to make it a "6" (109fh6) in the following:
$get_da
After adding echo mysql_error(); I get the same result. I tried changing
the query to include 109fh7 (a table which doesn't exist) and got the same
result as with 109fh6. Changing to 109fh5 does pull up that table. The
line to which the error message refers is while ($row = mysql_fetch_ass
Thanks to everyone for your help. It was a minor problem with the
variables. Out of practice.
Ken
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I sent an update to a php script to the server but the page in the browser
didn't change. Viewing the file on the server shows the new script. I
changed the file name on the hard drive and sent it to the server and the
browser didn't find the newly-named file, though I see that the
newly-
Yes, I've checked that I'm uploading to the right folder (the script on
the server has changed, so I don't know what the browser is reading to
show the old wording). The fact that the coding is showing when I open
the script on the hard drive suggests that something like an angle bracket
i
ws_ftp as I've done numerous times before.
On Wed, 22 Mar 2006 21:39:08 -0500, Chris <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] wrote:
Yes, I've checked that I'm uploading to the right folder (the script
on the server has changed, so I don't know what the browser is reading
22 matches
Mail list logo
