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: http:/
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 sho
Dear List -
I think I've lost the database connection.
I put in the following code:
$sql31= "select Lname, Fname, Phone, Cust_Num from Customers order by
Lname";
echo $sql31; //echos correctly
$result31 = mysqli_query($cxn,$sql31);
var_dump($result31); // result n
On Sat, Feb 2, 2013 at 8:08 PM, Ethan Rosenberg, PhD
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 not checking error returns f
$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_cnt";
}
else
{
echo "Ouc
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 differe
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
y
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
you have renamed places_data table to 'a'
2011/1/13 Harvey :
> 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:
>
> select c
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
rom: Artur Ejsmont [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
> 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 functi
From: "Vinay Kannan"
To: "PHP DB" , "php mysql"
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 an insert query.
I wanted to know if there is way to insert an arra
On Wed, Nov 17, 2010 at 8:51 AM, Vinay Kannan 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) hobbies = 5 co
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 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
Hawx wrote:
On Mon, 27 Apr 2009 07:19:23 -0700, "Miller, Terion"
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,
cr
On Mon, 27 Apr 2009 07:19:23 -0700, "Miller, Terion"
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,
> crime
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,
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 n
a MySQL database.
> >
> > - Original Message - From: "Micah Gersten" <[EMAIL PROTECTED]>
> > To: "YVES SUCAET" <[EMAIL PROTECTED]>
> > Cc:
> > Sent: Thursday, September 25, 2008 7:55 PM
> > Subject: Re: [PHP-DB] query
ces.
Can you help out rewriting the query using EXISTS syntax?
Thanks in advance,
Yves
- Original Message -
From: "Micah Gersten" <[EMAIL PROTECTED]>
To:
Sent: Friday, September 26, 2008 11:47 AM
Subject: Re: [PHP-DB] query optimization - DB
MySQL queries use 1 in
database.
>
> - Original Message - From: "Micah Gersten" <[EMAIL PROTECTED]>
> To: "YVES SUCAET" <[EMAIL PROTECTED]>
> Cc:
> Sent: Thursday, September 25, 2008 7:55 PM
> Subject: Re: [PHP-DB] query optimization
>
>
>> Other question is, what
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:
Sent: Thursday, September 25, 2008 7:55 PM
Subject: Re: [PHP-DB] query optimization
me help re-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
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 b
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
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
ip.block
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 come
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 fro
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 in
You just drew my attention my 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);
> >
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 p
An easier way would be to use the built-in MySQL functions directly. That way,
you avoid issues with date-format conversions between PHP and MySQL.
Look at: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
You code then becomes:
switch ($type) {
case "today": $sql = "... where
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 t
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");
Just mind the line-wrapping in this message. ;-P
--
Daniel P. Brown
Senior
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
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 = mysql_result($search_result,$i,"reference_numb
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 [mailto:[E
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 listing_approv
If I understood you correctly (and I'm not sure I did), this should do
it
$query="SELECT * FROM table WHERE listing_type LIKE '%$listing_type%'
AND listing_approved IN( '1' ,'2') ORDER BY name ASC";
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http:
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
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 | 2006-01-2
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: php-db@lists.ph
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
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
Here is the entire function
function Executequery($Query)
{
global $Error, $Hostname,$Loginname,$Passwd,$Dbname,$Conn;
$Conn = mysql_pconnect($Hostname,$Loginname,$Passwd);
$Re
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
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"]--";
echo"Submit = $submit ";
but
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"]--";
echo"Submit = $submit ";
but still query is
"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
> th
-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
t
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 a
hen all selected
scores, then loop through them individually. Doing 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: [PH
e 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 Ji
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:
> SE
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
pr
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
odbc_fetch_
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: Tuesda
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 "";
$thisMonth = $result[3]; //
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 ad
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
sta
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
7:11
To
[EMAIL PROTECTED]
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,
ki" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[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
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
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
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 b
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
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 side
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.
>
[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
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
> >
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 us
or a horse!
-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 err
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
t Sossomon; [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_
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 aw
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 value
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 sa
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] Qu
--- Original 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
>
>
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
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, vish.ko
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.
http:
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
> The error I am getting on the browser is:
>
> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
> result resource in http://www.martekbiz.com/KCS/utils.inc on line 52
line 52 is the following return statement in the db_fetch function :
function db_fetch($results) {
return
ts!
Aaron
-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
- 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 argume
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 T
As usual.
John knows best.
Thanks!
Aaron
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: July 25, 2003 3:05 PM
To: Aaron Wolski; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] query and display acting weird...
Probably need:
ORDER BY t.manufacturer, t.colourID
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 " style=
<[EMAIL PROTECTED]>
.net.il> cc:
Subject: RE: [PHP-DB] Query problem
Assuming you run MySQL, why don't you just remove the " ' "?
SELECT * FROM MyTable WHERE MyField=NULL
Sincerely
berber
Visit http://www.weberdev.com/ Today!!!
To see where PHP might take you tomorrow.
Share your code : http://addexample.weberdev.com
-Original Message-
From: Ron All
How would the entire query look
select * from ticket where Type = 'Phone' and ???
"Dirk Kredler" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Am Dienstag, 22. Juli 2003 11:29 schrieb Ron Allen:
> > This is what I have
> > select * from ticket where Type = 'Line' and Closeddate
select * from ticket where Type = 'Line' and (Closeddate IS NULL OR
Closeddate ='')
or
select * from ticket where Type = 'Line' and Closeddate IS NULL
HTH
Peter
-Original Message-
From: Ron Allen [mailto:[EMAIL PROTECTED]
Sent: 22 July 2003 10:29
To: [EMAIL PROTECTED]
Subject: [PHP-DB]
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 Close
> 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 t
1 - 100 of 206 matches
Mail list logo