At 10:46 + 3/22/03, Andrew wrote:
Hi MySQL
I am now working on the insert into two tables :)
items and items_city
In each table there is the ID which is unique. This is what I have
so far and I
am not getting very far with it.
select from city and display ready for check box selection.
[
Hi MySQL
I am now working on the insert into two tables :)
items and items_city
In each table there is the ID which is unique. This is what I have so far and I
am not getting very far with it.
select from city and display ready for check box selection.
[code]
echo "Select Cities and Towns";
e
ve" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 28, 2002 3:48 PM
Subject: Php query from sql
> Hello everybody,
>
> I'm quite new with all this php mysql "cooperation thing" but somehow I
> already managed to set up mysql database
Hello everybody,
I'm quite new with all this php mysql "cooperation thing" but somehow I
already managed to set up mysql database and I'm able to also make
query's based on any keyword...
Now I wonder how to add to this basic query also option to select some
concrete data.
For example in the dat
>> I have a column of amounts that was getting adding in a loop but I see
>> there's a sum() function to do this. Should have known. But I can't
>> make it work. Can someone give me a simple query syntax using php?
$table="my_table";
$field="some_field";
$sql="SELECT sum(cost) AS cost FROM
On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>At 19:53 -0500 2/7/02, Floyd Baker wrote:
>>I have a column of amounts that was getting adding in a loop but I see
>>there's a sum() function to do this. Should have known. But I can't
>>make it work. Can someone give me a simple query syntax usi
At 21:28 -0500 2/7/02, Floyd Baker wrote:
>On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>
>>At 19:53 -0500 2/7/02, Floyd Baker wrote:
>>>I have a column of amounts that was getting adding in a loop but I see
>>>there's a sum() function to do this. Should have known. But I can't
>>>make it work
At 19:53 -0500 2/7/02, Floyd Baker wrote:
>I have a column of amounts that was getting adding in a loop but I see
>there's a sum() function to do this. Should have known. But I can't
>make it work. Can someone give me a simple query syntax using php?
The SQL SUM() function has nothing to do w
At 22:58 -0500 2/7/02, Floyd Baker wrote:
>On Thu, 7 Feb 2002 21:07:44 -0600, you wrote:
>
>>At 21:28 -0500 2/7/02, Floyd Baker wrote:
>>>On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>>>
At 19:53 -0500 2/7/02, Floyd Baker wrote:
>I have a column of amounts that was getting adding in a loo
On Thu, 7 Feb 2002 22:09:18 -0600, you wrote:
>At 22:58 -0500 2/7/02, Floyd Baker wrote:
>>On Thu, 7 Feb 2002 21:07:44 -0600, you wrote:
>>
>>>At 21:28 -0500 2/7/02, Floyd Baker wrote:
On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>At 19:53 -0500 2/7/02, Floyd Baker wrote:
>>I ha
On Thu, 7 Feb 2002 21:07:44 -0600, you wrote:
>At 21:28 -0500 2/7/02, Floyd Baker wrote:
>>On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>>
>>>At 19:53 -0500 2/7/02, Floyd Baker wrote:
I have a column of amounts that was getting adding in a loop but I see
there's a sum() function to do th
On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>At 19:53 -0500 2/7/02, Floyd Baker wrote:
>>I have a column of amounts that was getting adding in a loop but I see
>>there's a sum() function to do this. Should have known. But I can't
>>make it work. Can someone give me a simple query syntax usi
I have a column of amounts that was getting adding in a loop but I see
there's a sum() function to do this. Should have known. But I can't
make it work. Can someone give me a simple query syntax using php?
TIA
Floyd
--
--
On Thu, 7 Feb 2002 22:09:18 -0600, you wrote:
>At 22:58 -0500 2/7/02, Floyd Baker wrote:
>>On Thu, 7 Feb 2002 21:07:44 -0600, you wrote:
>>
>>>At 21:28 -0500 2/7/02, Floyd Baker wrote:
On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>At 19:53 -0500 2/7/02, Floyd Baker wrote:
>>I ha
At 22:58 -0500 2/7/02, Floyd Baker wrote:
>On Thu, 7 Feb 2002 21:07:44 -0600, you wrote:
>
>>At 21:28 -0500 2/7/02, Floyd Baker wrote:
>>>On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>>>
At 19:53 -0500 2/7/02, Floyd Baker wrote:
>I have a column of amounts that was getting adding in a loo
On Thu, 7 Feb 2002 21:07:44 -0600, you wrote:
>At 21:28 -0500 2/7/02, Floyd Baker wrote:
>>On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>>
>>>At 19:53 -0500 2/7/02, Floyd Baker wrote:
I have a column of amounts that was getting adding in a loop but I see
there's a sum() function to do th
At 21:28 -0500 2/7/02, Floyd Baker wrote:
>On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>
>>At 19:53 -0500 2/7/02, Floyd Baker wrote:
>>>I have a column of amounts that was getting adding in a loop but I see
>>>there's a sum() function to do this. Should have known. But I can't
>>>make it work
On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>At 19:53 -0500 2/7/02, Floyd Baker wrote:
>>I have a column of amounts that was getting adding in a loop but I see
>>there's a sum() function to do this. Should have known. But I can't
>>make it work. Can someone give me a simple query syntax usi
On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>At 19:53 -0500 2/7/02, Floyd Baker wrote:
>>I have a column of amounts that was getting adding in a loop but I see
>>there's a sum() function to do this. Should have known. But I can't
>>make it work. Can someone give me a simple query syntax usi
At 19:53 -0500 2/7/02, Floyd Baker wrote:
>I have a column of amounts that was getting adding in a loop but I see
>there's a sum() function to do this. Should have known. But I can't
>make it work. Can someone give me a simple query syntax using php?
The SQL SUM() function has nothing to do w
I have a column of amounts that was getting adding in a loop but I see
there's a sum() function to do this. Should have known. But I can't
make it work. Can someone give me a simple query syntax using php?
TIA
Floyd
--
--
- Original Message -
From: "Felicia" <[EMAIL PROTECTED]>
To: "mysql post" <[EMAIL PROTECTED]>
Sent: Sunday, July 01, 2001 2:06
Subject: mysql/php query from 2 tables
> im having problems getting results querying two tables but I am not sure
of
>
im having problems getting results querying two tables but I am not sure of
the correct php syntax for the query statement below. It always yields 0
results.
$query2 = "select * from dir,free where 'dir.inst' = free.inst'";
This is what I use in mySQL database but I get 0 results when querying
So sprach Kelly Alexander Zia am Sat, Mar 17, 2001 at 11:08:04AM -0700:
> Warning: Supplied argument is not a valid MySQL result resource in
> c:\phpweb/searchresults1.php on line 462
The database connection is somehow broken.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) ht
Hi,
I am having problems with my query trying to call a list of interests.
When someone signs up too the site they choose 7 different interests
from a list and it can be in any different configuration. I am having a
hard time getting it to query, and amy getting this error message:
SELECT
clien
uot;;
> $query .= "ORDER BY Restaurant.Price ";
> $mysql_result=mysql_query($query, $db) OR DIE ("died at query");
>
> -code here-
>
>
> -Original Message-
> From: Rolf Hopkins [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, Febr
";
$query .= "FROM Restaurant ";
$query .= "WHERE '$CuisineTemp' = Restaurant.Cuisine AND '$AreaTemp' =
Restaurant.Area ";
$query .= "ORDER BY Restaurant.Price ";
$mysql_result=mysql_query($query, $db) OR DIE ("died at query");
---
nsman, Scott" <[EMAIL PROTECTED]>
To: "'Rolf Hopkins'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, February 14, 2001 23:29
Subject: RE: mySQL/php query help
> hey rolf--
>
> everything works fine if the user chooses "ALL&quo
Original Message -
From: "Stinsman, Scott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 23:17
Subject: mySQL/php query help
> can anyone figure out why the following code works fine when both select
> variables = "ALL" and also
PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 23:17
Subject: mySQL/php query help
> can anyone figure out why the following code works fine when both select
> variables = "ALL" and also when only 1 of the 2 ="ALL" but NOT when BOTH
> select var
can anyone figure out why the following code works fine when both select
variables = "ALL" and also when only 1 of the 2 ="ALL" but NOT when BOTH
select variables equal something other than "ALL"?
here is the code:
What area of the city would you like to dine in?
\n";
$select.="ALL\n";
w
31 matches
Mail list logo