On 02/07/14 04:43, Ethan Rosenberg, PhD wrote:
while ($row31 = mysqli_fetch_row($result31)) {
printf (%s %s %s %s %s\n, $row31[0], $row31[1], $row31[2], $row31[3]);
Try
print_r( $row31 );
} // no output
How can I loose a db connection in the middle of a program?
This is not showing
Once again you have provided the group with RANDOM pieces of code,
completely out of context since you have already shown me that your
query and db connection are being used in a function, hence your loss of
$cxn.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
$sql13 = UPDATE `Customers` SET `Lname` = 'Barnet', `City` =
'Lakewood', `State` = 'NJ' WHERE `Cust_Num` = 1089;
$result13 = mysqli_query($cxn, $sql13);
if(mysqli_num_rows($result13) 0)
{
$row_cnt = mysqli_num_rows($result13);
echo row count result13 is $row_cntbr /;
}
else
{
echo Ouch
On Sat, Feb 2, 2013 at 8:08 PM, Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com wrote:
I must be missing something fundamental!!
Yes.
I was using the worker@localhost, which did not have the Update privilege.
Added the privilege that, and everything worked.
Please explain why you are
I would keep the db names and/or schema names in your queries.
It clarifies what you are doing with the query making it easier for
someone else to debug, improve, ... Certainly for those not familiar
with your db structure.
I am not aware of any drawbacks that can result from this. (Ok, maybe
That's a very good point,
but since I use postgres that's one point that doesn't affect me and as
such didn't cross my mind at the time.
(Postgres uses schemas where mysql uses databases, a different database
on postgres usually means a different database machine. And joining
tables from
you have renamed places_data table to 'a'
2011/1/13 Harvey har...@harveyk.com:
Hello,
I have a query on a page that used to work fine, but is now generating an
error.
I assume that the version of php or mysql was updated on the webhost server
or something like that?
Here is the query:
Thanks, I got it working now, had to use the a/b/c thing a few times
-Original Message-
From: jose [mailto:jojap...@gmail.com]
Sent: Thursday, January 13, 2011 9:52 AM
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Query syntax error?
you have renamed places_data table to 'a'
2011/1
well i guess you could do that. but it gets complicated after a
while and there will be a lot of work and probably after a while you
will get into some problems. You have to handle escaping, special
types etc. Then what about performance? how to query the data ...
using similar approach or is
On Wed, Nov 17, 2010 at 8:51 AM, Vinay Kannan viny...@gmail.com wrote:
Hello PHP Gurus,
I need your help on an insert query.
I wanted to know if there is way to insert an array of values into a DB. An
eg would explain this better :
If I have 2 tables in a DB, 1) users has 3 columns 2)
From: Vinay Kannan viny...@gmail.com
To: PHP DB php-db@lists.php.net, php mysql
php_mysql_usergr...@yahoogroups.com
Sent: Wednesday, November 17, 2010 2:51:35 PM GMT +01:00 Amsterdam / Berlin /
Bern / Rome / Stockholm / Vienna
Subject: [PHP-DB] query help
Hello PHP Gurus,
I need your help on
Hello PHP Gurus,
I need your help on an insert query.
I wanted to know if there is way to insert an array of values into a DB. An
eg would explain this better :
If I have 2 tables in a DB, 1) users has 3 columns 2) hobbies = 5 columns
I was thinking of having a single function which
[mailto:ejsmont.ar...@gmail.com]
Sent: 17 noiembrie 2010 16:07
To: Vinay Kannan
Cc: PHP DB; php mysql
Subject: Re: [PHP-DB] query help
well i guess you could do that. but it gets complicated after a while
and there will be a lot of work and probably after a while you will get into
some
The most performant methods are to use well parameterized stored procedure or a
prepared parameterized statement.
: Ashay
-Original Message-
From: Niel Archer [mailto:n...@chance.now]
Sent: Wednesday, November 17, 2010 6:30 AM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] query help
On 18/10/10 06:55, Ron Piggott wrote:
Is there a query you could help me write a SELECT query that would search table
`ministry_profiles` for where column `organization` has the same organization
more than once? I am trying to delete the duplicate organization records, but
I am working with
On Mon, Apr 27, 2009 at 10:19 AM, Miller, Terion
tmil...@springfi.gannett.com wrote:
I need help/advice figuring out why my query dies after 2 records. Here is
the query:
// Build your INSERT statement here
$query = INSERT into `warrants` (wid, name, age, warrant, bond, wnumber,
On Mon, 27 Apr 2009 07:19:23 -0700, Miller, Terion
tmil...@springfi.gannett.com wrote:
I need help/advice figuring out why my query dies after 2 records. Here
is
the query:
// Build your INSERT statement here
$query = INSERT into `warrants` (wid, name, age, warrant,
Hawx wrote:
On Mon, 27 Apr 2009 07:19:23 -0700, Miller, Terion
tmil...@springfi.gannett.com wrote:
I need help/advice figuring out why my query dies after 2 records. Here
is
the query:
// Build your INSERT statement here
$query = INSERT into `warrants` (wid, name, age,
Yves Sucaet wrote:
Hi Jack,
I'm expecting less than 10 records in the resulting set.
The BlockUnit table contains 337,253 records; the InteractionParts table
contains 279,953 records.
It takes currently 8.3 seconds to execute the query as I have it.
Erh, this is embarassing but I'm going to
-writing it with
EXISTS...
Thanks for the help so far,
Yves
- Original Message -
From: Jack van Zanen
To: Chris
Cc: YVES SUCAET ; php-db@lists.php.net
Sent: Thursday, September 25, 2008 7:49 PM
Subject: Re: [PHP-DB] query optimization
If you can answer the other questions
Oh, sorry I forgot to mention this. It's a MySQL database.
- Original Message -
From: Micah Gersten [EMAIL PROTECTED]
To: YVES SUCAET [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Sent: Thursday, September 25, 2008 7:55 PM
Subject: Re: [PHP-DB] query optimization
Other question
.
- Original Message - From: Micah Gersten [EMAIL PROTECTED]
To: YVES SUCAET [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Sent: Thursday, September 25, 2008 7:55 PM
Subject: Re: [PHP-DB] query optimization
Other question is, what DB is this for?
Thank you,
Micah Gersten
onShore Networks
Internal
you help out rewriting the query using EXISTS syntax?
Thanks in advance,
Yves
- Original Message -
From: Micah Gersten [EMAIL PROTECTED]
To: php-db@lists.php.net
Sent: Friday, September 26, 2008 11:47 AM
Subject: Re: [PHP-DB] query optimization - DB
MySQL queries use 1 index per
PROTECTED]
To: YVES SUCAET [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Sent: Thursday, September 25, 2008 7:55 PM
Subject: Re: [PHP-DB] query optimization
Other question is, what DB is this for?
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
What indices do you have?
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
YVES SUCAET wrote:
How could I rewrite the following query so it runs faster:
select distinct location from blockunit where blockid in (
select bu.blockid from blockunit bu inner
Micah Gersten wrote:
What indices do you have?
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
YVES SUCAET wrote:
How could I rewrite the following query so it runs faster:
select distinct location from blockunit where blockid in (
select bu.blockid
Hi
If I am not mistaken,
the second part of the union contains all rows that are in the first part of
the union. just remove the first part.
Also
What is the table sizes of the tables?
How many records are expected to come back from the union sub query?
How many records are expected to
Jack van Zanen wrote:
Hi
If I am not mistaken,
the second part of the union contains all rows that are in the first part of
the union. just remove the first part.
Kind of.
The first part is a join, the second isn't.
I was going to suggest rewriting the subquery into a single:
where
If you can answer the other questions that would help as well
you can try rewriting using exist instead of in
But without the basic information like number of records expected and
explain plan it is very hard to come up with a better solution.
Brgds
Jack
2008/9/26 Chris [EMAIL PROTECTED]
Other question is, what DB is this for?
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
YVES SUCAET wrote:
How could I rewrite the following query so it runs faster:
select distinct location from blockunit where blockid in (
select bu.blockid from
Ron Piggott wrote:
I have an interesting question.
When I run the following query through my PHP script it produces 1
result. I know this because I echo the value of $num to the screen from
the following syntax: $num=mysql_numrows($result);
When I do the query in the SQL tab of
You just drew my attention my include that brings in the site menu and
was changing the conflict. Thanks :) Ron
On Thu, 2008-05-01 at 13:19 +1000, Chris wrote:
Ron Piggott wrote:
I have an interesting question.
When I run the following query through my PHP script it produces 1
Dee Ayy wrote:
Is there something which can perform a query across different database systems?
It would extend the database.table.field notation to maybe
dbms.database.table.field and allow queries across MySQL and MSSQL
I don't think so.
Both mysql and mssql would need to know how to parse
On Fri, Feb 29, 2008 at 12:22 AM, Ron Piggott
[EMAIL PROTECTED] wrote:
$reference_number = mysql_result($search_result,$i,reference_number);
$description = mysql_result($search_result,$i,description);
?
$sql = SELECT reference_number FROM table WHERE this='whatever' OR
that NOT LIKE
Ron Piggott wrote:
I need help populating an array based on the output of a mysql query.
$reference_number is a value assigned by auto_increment
$description is what I want the value of the array to be --- a few words
in length
$reference_number =
Ron Piggott wrote:
This line of code
while ($row = mysql_fetch_assoc($result)) {
Gave me this error message:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
result resource
I ran
select reference, description from table
in mySQL and it worked --- Any idea what caused
The mysql_affected_rows() function will tell you how many rows were affected
by the DELETE query you just fired. You can also test for TRUE or FALSE on
the mysql_query() function if you just want to know if the query was
successful or not.
Rich
-Original Message-
From: ron.php
SELECT * FROM table
WHERE listing_type LIKE '%$listing_type%'
AND (listing_approved = '1' OR listing_approved = '2')
ORDER BY name ASC
(notice the parentheses around the OR part of the clause)
or you can do this...
SELECT * FROM table
WHERE listing_type LIKE '%$listing_type%'
AND
At 08:47 25/02/2006, you wrote:
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary=_=_NextPart_001_01C63997.1A6B1B7D
Date: Sat, 25 Feb 2006 08:07:36 +0900
Message-ID: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
To: 'php-db@lists.php.net'
Subject: FW: [PHP-DB] Query select
Dear All,
I have table like this :
Id | Category | Date|
Value
1 | A | 2005-02-21 |
2000
2 | A | 2004-01-21 |
3000
3 | B |
John Burroughs wrote:
Hi everyone,
I've created a database for my poetry that I've written. I have a
table called Titles. It is made up of:
[snip]
How can I do this. Everytime I tried adding to the above code, I kept
getting error messages in php saying that there was an unexpected
''character
Hi,
Please send the code that you used with the hrefs so we can see where the
error occurs. Tell us what line the error occured (and what line in your
copied code that is).
Jos
-Original Message-
From: John Burroughs [mailto:[EMAIL PROTECTED]
Sent: 21 March 2005 03:29
To:
This is a common procedure. $Query is being passed to it. As I had
said before, i had tried echoing $Query before and after the
mysql_query statement and it displays a proper query.
That's what driving me nuts! :-(
On Wed, 16 Mar 2005 22:36:13 -0800, Stephen Johnson [EMAIL PROTECTED] wrote:
I
Here is the entire function
function Executequery($Query)
{
global $Error, $Hostname,$Loginname,$Passwd,$Dbname,$Conn;
$Conn = mysql_pconnect($Hostname,$Loginname,$Passwd);
I do not see where you are populating $Query -- therefore your query
would be empty --
On Mar 16, 2005, at 10:30 PM, Vinayakam Murugan wrote:
Hi
I have an application in which i am connecting to three different
databases. I have three connect and query procedure. I am facing
problems with one
hallo,
see below code. query is not executing and data is not shown in table of
database.after submit button hit.
how to evaluate $submit true. have Tried these statements before if statement
echo --$submit--;
echo --$_POST[submit]--;
echoSubmit = $submit ;
but still query is not
amol patil wrote:
hallo,
see below code. query is not executing and data is not shown in table of database.after submit button hit.
how to evaluate $submit true. have Tried these statements before if statement
echo --$submit--;
echo --$_POST[submit]--;
echoSubmit = $submit ;
but still
This is a common join issue. If you don't specify ANYTHING to connect
between the two tables, it'll do one row from the first table, then ALL
the rows from the second. Row #2 from the first, then ALL the rows from
the second.
If you had 600 rows in each table, you'd end up with 360,000 rows as
-Original Message-
From: Chip Wiegand [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 11, 2004 3:28 PM
To: PHP DB
Subject: [PHP-DB] query of two tables returns too many rows, many more
than the two tables contain
I have two tables I want to get out the rows that are different between
Gryffyn, Trevor [EMAIL PROTECTED] wrote on 11/11/2004
01:39:37 PM:
This is a common join issue. If you don't specify ANYTHING to connect
between the two tables, it'll do one row from the first table, then ALL
the rows from the second. Row #2 from the first, then ALL the rows from
the
On Wed, 21 Jul 2004 16:29:37 -0400, Brock Jimmy D Contr 74 MDSS/SGSI
[EMAIL PROTECTED] wrote:
My query is returning duplicates rows.
table: elements
elementId
standardId
elementtext
category
mcode
linenum
table: scores
scoreId
taskId
scores
Here's my query:
SELECT distinct
the criteria for that particular
element.
Thanks for the help though.
-Original Message-
From: Justin Patrin
To: Brock Jimmy D Contr 74 MDSS/SGSI
Cc: [EMAIL PROTECTED]
Sent: 7/21/2004 5:02 PM
Subject: Re: [PHP-DB] Query returns duplicate rows
On Wed, 21 Jul 2004 16:29:37 -0400, Brock Jimmy D
a join without an
ON clause is IMHO not a good choice.
-Original Message-
From: Justin Patrin
To: Brock Jimmy D Contr 74 MDSS/SGSI
Cc: [EMAIL PROTECTED]
Sent: 7/21/2004 5:02 PM
Subject: Re: [PHP-DB] Query returns duplicate rows
On Wed, 21 Jul 2004 16:29:37 -0400, Brock Jimmy D Contr
Thompson, Jimi wrote:
I'm trying to figure out how to write a MySQL query that will return the
highest primary key a table.
1) Why?
2) SELECT MAX(id) FROM table
3) If you're trying to find the key of the last row inserted to an
auto_increment column, use mysql_insert_id() or LAST_INSERT_ID() in
Try left joining your states table also. MySQL may be joining the
property_photos and the states table first, which would screw up your
left join. Haven't had my morning coffee yet so I can't say for sure.
Put EXPLAIN in front of your query to see what MySQL is doing.
SELECT
...
FROM
Yes!
That worked! (It was returning the same field values not column names, my mistake).
Now it returns what it should return. Onwards to the next snafu!
Thanks!
Ryan Jameson (USA) [EMAIL PROTECTED] wrote:
One thing may be that you need to do a fetch to increment the result row
Peppe
Don't search by month at all - use a start and stop date then order by date.
Now you have one result set with all the dates in it and you can use your
PHP code to figure out where to close one table and open a net one:
$result = mysql_query($sql);
echo TABLE;
$thisMonth = $result[3];
One thing may be that you need to do a fetch to increment the result row
odbc_fetch_row($result);. Though that doesn't explain your column names
being in the array unless that's what's in the table.
Ryan
-Original Message-
From: Karen Resplendo [mailto:[EMAIL PROTECTED]
Sent: Tuesday,
From: Larry Sandwick [EMAIL PROTECTED]
I need to sum the field *COST* in this query where data in *STATUS* is
equal to HELD and OPEN, so I will have 2 totals passed below and do
not know where to begin .
SELECT status, SUM(cost) FROM Table WHERE status IN ('HELD','OPEN') GROUP BY
status
From: Larry Sandwick [EMAIL PROTECTED]
I appreciate the quick response, but I should have been more clear.
I understand the query below, but I would only have 2 total and it is
not group by the companies.
The query below gives me the main information without totals.
How do I add the 2
]; [EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 5:46 AM
Subject: Re: [PHP-DB] Query Case In-sensitive
Generally in DBs, data is case sensitive.
Simply you can do an uppercase or lowercase conversion in both sides.
Ex : Select item number from item where upper(item_code) = upper(m1234
]
cc
Subject
Re: [PHP-DB] Query Case In-sensitive
Use LIKE clause instead of =
SELECT item_number FROM item WHERE item_code LIKE 'M1234' ;
This will perform case-insensitive matching on all databases I used
before (Including Oracle, MySQL, SQL-Server)
- Original Message
19, 2003 2:36 PM
Subject: Re: [PHP-DB] Query Case In-sensitive
As an Oracle DBA (9+ years, versions 7.x - 9.x) I just wanted to make a correction.
The LIKE command uses wild card characters ( _ and % ) for substitutions. Oracle IS a
case-sensitive RDBMS and the LIKE command will NOT do
you can convert both of the sides to one case, similar to this:
select item_number from item where upper (item_code) = upper (M1234);
this way you ensure that both the value in the database and the selection
variable are in one and the same case: capital. this should work in just
about every
In Oracle you have a couple of choices.
(1) If you can ensure that the data stored is in one case you can apply a
function to the keyed in data
SELECT item_number FROM item WHERE item_code = lower('M1234');
(2) If you can not ensure data case then you can apply the function to
both
From: Larry Sandwick [EMAIL PROTECTED]
Is there a way to run a query so that it ignores the case, and the query
is not case sensitive?
What's this have to do with PHP and what database are you using?
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
Hey!
At least in Postgresql you can do something like:
SELECT * FROM table where item_code ILIKE 'blabla';
But I guess it's standard, so you can use it in any DB.
Larry Sandwick wrote:
Is there a way to run a query so that it ignores the case, and the query
is not case sensitive?
The data
Generally in DBs, data is case sensitive.
Simply you can do an uppercase or lowercase conversion in both sides.
Ex : Select item number from item where upper(item_code) = upper(m1234);
-ramki
- Original Message -
From: Larry Sandwick [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
From: Peter Beckman [EMAIL PROTECTED]
I have this data:
Table Log: appid userid points datetype
Table Score: appid userid score
I want to verify that the last entry in table log of type x is equal to
the sum of the scores in table score for the same appid and userid.
Can
On Thu, 6 Nov 2003, CPT John W. Holmes wrote:
From: Peter Beckman [EMAIL PROTECTED]
I have this data:
Table Log: appid userid points datetype
Table Score: appid userid score
I want to verify that the last entry in table log of type x is equal to
the sum of the
[EMAIL PROTECTED] wrote:
On Thu, 6 Nov 2003, CPT John W. Holmes wrote:
From: Peter Beckman [EMAIL PROTECTED]
I have this data:
Table Log: appid userid points datetype
Table Score: appid userid score
I want to verify that the last entry in table log of type x is equal to
the sum of
On Thu, 6 Nov 2003, John W. Holmes wrote:
I'd still like an answer to this question. Why is there a need for a
separate table with scores?
The log is a snapshot in time -- what was the total points at the time
of the log entry.
The score table is always the accurate current score.
Can
From: Robert Sossomon [EMAIL PROTECTED]
And here is the additem.php file where it check for the info in the
field and it is erroring out.
It would be rather useful to know the error...
$get_iteminfo = select * from GCN_items where 'item_num' LIKE
'%$_POST[sel_item_id]%';
Take away the
; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Query Error
From: Robert Sossomon [EMAIL PROTECTED]
And here is the additem.php file where it check for the info in the
field and it is erroring out.
It would be rather useful to know the error...
$get_iteminfo = select * from GCN_items where
From: Robert Sossomon [EMAIL PROTECTED]
The errors as it prints are:
The query I just ran was: select * from GCN_items where `item_num` =
'%fm-a294%'
The query I just ran was: Resource id #2
0
Those aren't errors; it's just what you asked the script to display. Your
query simply isn't
!
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 1:31 PM
To: Robert Sossomon; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Query Error
From: Robert Sossomon [EMAIL PROTECTED]
The errors as it prints are:
The query I
You're using an alias of 'date' instead of DateOfOrder, so that should be
reflected in the array key.
So:
$Date = $OrderDate[date];
-Micah
On Sun October 26 2003 4:22 pm, Graeme McLaren wrote:
Hey everyone, the following query and code works fine but I can't
understand why I can't echo
SELECT *
FROM table
WHERE column IN ( 'this', 'that', 'theother' )
Ignatius
_
- Original Message -
From: Robbie Staufer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 12:10 AM
Subject: [PHP-DB] query for multiple values
how are you testing the check boxes?, looks like the the query string is empty because
both the tests you are doing in the code below return false.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 22 September 2003 15:01
To: [EMAIL PROTECTED]
Subject: [PHP-DB]
From: [EMAIL PROTECTED]
I have a PHP GUI in which a select box gets populated by a query of a
MySQL DB for all CD's by all artists when the page is first opened. I am
now trying to implement
the same query but with a WHERE clause that filters the returned CD's to
be displayed in the same
[EMAIL PROTECTED]
To: vish.kohli [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, August 18, 2003 8:28 AM
Subject: Re: [PHP-DB] Query runs fine on Console but not in PHP
What platform are you using? Since it appears that the script is
crashing, you are probably on Linux or some other
Message -
From: Robert Twitty [EMAIL PROTECTED]
To: vish.kohli [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, August 18, 2003 8:28 AM
Subject: Re: [PHP-DB] Query runs fine on Console but not in PHP
What platform are you using? Since it appears that the script is
crashing, you
What platform are you using? Since it appears that the script is
crashing, you are probably on Linux or some other UNIX flavor. If this is
the case, the TDS protocol setting may not be correct. What type of date
are you retrieving with this stored procedure?
-- bob
On Sun, 17 Aug 2003,
From: Matt Babineau [EMAIL PROTECTED]
For some reason my MySQL doesn't seem to be caching queries!
And you expect PHP to solve this how? Do you want PHP to cache the queries?
You must say please...
You need to set the four variables mentioned at the following URL in your
my.cnf file.
- Original Message -
From: Aaron Wolski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, August 03, 2003 9:59 AM
Subject: [PHP-DB] query works fine on console but not with PHP - why?
The error I am getting on the browser is:
Warning: mysql_fetch_array(): supplied argument is
-Original Message-
From: Matt [mailto:[EMAIL PROTECTED]
Sent: August 3, 2003 10:11 AM
To: Aaron Wolski; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] query works fine on console but not with PHP -
why?
- Original Message -
From: Aaron Wolski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday
You have an error in your PHP code, just as the error says.
Including only the query, which you've already tested, isn't very helpful.
The error message is telling you that the result link identifier used in your fetch
statement isn't the same as returned by the query statement OR there was an
Aaron Wolski wrote:
Hi Guys,
Have a multiple select box. I'm trying to group columns and display
records under their paired groupings.
[snip]
What I'd like is to display them like:
Manufactuer - Type
Manufacturer - Type
Manufacturer - Type
I tried this code but only seems to group one
Probably need:
ORDER BY t.manufacturer, t.colourID
---John Holmes...
- Original Message -
From: Aaron Wolski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, July 25, 2003 2:58 PM
Subject: [PHP-DB] query and display acting weird...
Hi Guys,
Code:
echo select
Am Dienstag, 22. Juli 2003 11:29 schrieb Ron Allen:
This is what I have
select * from ticket where Type = 'Line' and Closeddate = ' empty space'
and have tried the following
select * from ticket where Type = 'Line' and Closeddate = 'Null'
select * from ticket where Type = 'Line' and
:
Subject: RE: [PHP-DB] Query problem
07/22/2003 03:16
Okay... and? Do you have a question? Are you wanting us to write this for
free? Do you want bids on the project?
---John Holmes...
- Original Message -
From: Ryan Holowaychuk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 16, 2003 2:30 PM
Subject: [PHP-DB] query selection
Sorry forgot to state the question.
No bids. Looking for help.
the first list that is displayed has an ID for each product. But when I
click on it, it goes to the next page but does not display the rest of the
products that are listed in the second table.
$query = SELECT * FROM
the first list that is displayed has an ID for each product. But when I
click on it, it goes to the next page but does not display the rest of the
products that are listed in the second table.
$query = SELECT * FROM product_list WHERE productid = id;
Id being the description ID that came
What database are you using?
Also, are all the fields involved in the joins and whare clause
properly indexed? Depending on the database you are using, it is possible
to determine if the indexed fields are being used.
-- bob
On Tue, 3 Jun 2003, André Sannerholt wrote:
Hi everybody,
now I
Awsome!
Thanks, That is exactly what I was looking for. Work great now!
Leif K-Brooks [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
To answer your question, you should urlencode() the team name. However,
I would store the user in a cookie or session, and fetch the team name
on
On Sun, 2003-06-01 at 22:26, Ian Fingold wrote:
I'm trying to build a query string for one of my links.. for example...
fant_stnd3.php?week=1team=fun%20team
I need to be able to grab the values of 'week' and 'team' from an array, I
can do that no problem, but when the code runs it cuts off
Sorry I don't think I explained very well... heres my situation...
I have a mysql database set up... I have a user table with 2
fields...team_name and fant_week.
What I want to do is, depending on who is logged in, I want my link to
change the value of 'team' to the logged in members team name,
Check out http://www.php.net/manual/en/ref.url.php
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Ian Fingold [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, 01 June, 2003 23:20
Subject: Re: [PHP-DB] query string
Sorry I don't think I explained
On Sun, 2003-06-01 at 23:20, Ian Fingold wrote:
Sorry I don't think I explained very well... heres my situation...
I have a mysql database set up... I have a user table with 2
fields...team_name and fant_week.
What I want to do is, depending on who is logged in, I want my link to
change
1 - 100 of 186 matches
Mail list logo
