Hello Everyone
Got a simple / stupid question.
Worked on this all night. I'm over looking something very basic here.
The query event_time brings back the calendar id for each event that is
pending in the future.
ie 12, 13, 14, 26 (There could be 100 of them out there)
The second query
Matthew Ferry wrote:
Hello Everyone
Got a simple / stupid question.
Worked on this all night. I'm over looking something very basic here.
The query event_time brings back the calendar id for each event that is
pending in the future.
ie 12, 13, 14, 26 (There could be 100 of them out
Try this as your SQL. It should give you all the results, then you can use PHP
to sort it all out.
SELECT * FROM egw_cal WHERE cal_category='501' and cal_id in (SELECT cal_id
FROM egw_cal_dates where cal_start $tstamp)
-TG
= = = Original message = = =
Hello Everyone
Got a simple /
This is a join - Read up on them, they're very useful and don't require
the overhead of a sub-query.
SELECT egw_cal.* FROM egw_cal_dates
LEFT JOIN egw_cal using (cal_id)
where egw_cal_dates.cal_start $tstamp
AND egw_cal.cal_category = '501'
-Micah
On 02/12/2007
;
} while ($event = mysql_fetch_array($events));
} else {
echo No Public Events Are Currently Scheduled...;
}
?
- Original Message -
From: Matthew Ferry [EMAIL PROTECTED]
To: php-db@lists.php.net
Sent: Monday, February 12, 2007 11:14 AM
Subject: [PHP-DB] SQL Query - Using variable from
Chris Carter wrote:
What wrong with this syntax, its not giving any error on runtime but I am
facing a blank page while paging.
$query= SELECT * FROM gurgaonmalls WHERE mallname = '$mallname' limit $eu,
$limit ;
Have you tried...
echo p $query /p;
...to unsure the variables have the values
What wrong with this syntax, its not giving any error on runtime but I am
facing a blank page while paging.
$query= SELECT * FROM gurgaonmalls WHERE mallname = '$mallname' limit $eu,
$limit ;
--
View this message in context:
http://www.nabble.com/SQL-query-error-tf2831052.html#a7903857
Sent
Hello list,
Whats wrong with my SQL query:
$query=select email from usuarios where userName = (select username from
fussv where folio = 'FUSS-130-2006');
I get an error!
I have tested the two individual sentences and they worked OK!
---
Miguel Guirao Aguilera
Asunto: [PHP-DB] SQL query
Hello list,
Whats wrong with my SQL query:
$query=select email from usuarios where userName = (select
username from fussv where folio = 'FUSS-130-2006');
I get an error!
I have tested the two individual sentences and they worked OK
Check your version. Subselects were only added in MySQL Version 4.1.
Regards,
Dwight
-Original Message-
From: Edwin Cruz [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 28, 2006 10:53 AM
To: 'Miguel Guirao'; php-db@lists.php.net
Subject: RE: [PHP-DB] SQL query
Make sure
OK, this makes my day clear!!
I have versión 3.23.49-3 of MySQL
Thanks Dwight!
-Original Message-
From: Dwight Altman [mailto:[EMAIL PROTECTED]
Sent: Jueves, 28 de Septiembre de 2006 11:32 a.m.
To: php-db@lists.php.net
Subject: RE: [PHP-DB] SQL query
Check your version. Subselects
I have this code below, it fetches data on a mysql database. I was hoping
you could give me a code hint on where could, my goal is to display this
data on a browser which i did already and be able to edit it via a form.
edit? - table1=value - table2=value
I dont know where to start. please help
Silva
World Editing
Portugal
-Original Message-
From: Louie Miranda [mailto:[EMAIL PROTECTED]
Sent: quinta-feira, 15 de Janeiro de 2004 8:00
To: [EMAIL PROTECTED]
Subject: [PHP-DB] sql query, editing?
I have this code below, it fetches data on a mysql database. I was
hoping you could
SELECT DISTINCT(file_name), Count(file_name) FROM $table_name WHERE date
BETWEEN '2003-10-01' AND '2003-12-31' group by file_name order by ???
desc
In the above sql statement, I'm trying to achieve:
1. select all file names, between two dates.
2. list them, and order by the highest number
SELECT DISTINCT(file_name), Count(file_name) FROM $table_name WHERE date
BETWEEN '2003-10-01' AND '2003-12-31' group by file_name order by ???
desc
In the above sql statement, I'm trying to achieve:
1. select all file names, between two dates.
2. list them, and order by the highest number of
Ah...
you can name the count()..
live and learn, cheers dude...
brett king [EMAIL PROTECTED]
15/01/2004 11:17
Please respond to
[EMAIL PROTECTED]
To
[EMAIL PROTECTED], [EMAIL PROTECTED]
cc
Subject
RE: [PHP-DB] SQL query...
SELECT DISTINCT(file_name), Count(file_name) FROM $table_name
: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 4:31 PM
Subject: [PHP-DB] SQL query...
SELECT DISTINCT(file_name), Count(file_name) FROM $table_name WHERE date
BETWEEN '2003-10-01' AND '2003-12-31' group by file_name order by ???
desc
In the above sql statement
: Thursday, January 15, 2004 1:01 PM
Subject: [PHP-DB] SQL query...
SELECT DISTINCT(file_name), Count(file_name) FROM $table_name WHERE date
BETWEEN '2003-10-01' AND '2003-12-31' group by file_name order by ???
desc
In the above sql statement, I'm trying to achieve:
1. select all file names
From: Muhammed Mamedov [EMAIL PROTECTED]
Try this
SELECT DISTINCT(file_name), Count(file_name) AS cnt FROM $table_name
WHERE
date
BETWEEN '2003-10-01' AND '2003-12-31' group by file_name order by cnt;
desc
If you're GROUPing by file_name then you don't need DISTINCT(file_name)...
it's
why does this
select date(date_file_created) from files
create the error
error near near '(date_file_created) from files' at line 1
trying to extract the date part of the date_tile filed
tia
pete
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
i'm starting out in this whole thing, and i'm trying to program a zine that
uses a sql database for content and calls the content into a template. what
i am unclear on how to do is set up the links so that I can get the info
from the database. anyone willing to help me out?
--
PHP Database
Hi Guys I have written this SQL Query :
CREATE TABLE tasks (id INT AUTO_INCREMENT, name VARCHAR(50), desc TEXT, address
VARCHAR(50), startDate DATE, lastWork DATE, progress INT(3))
I'm sending it in through php and I can't get it to work correctly. Please help.
Also, I would like to make id
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY
Adam
On Sat, 7 Sep 2002, Bryan McLemore wrote:
Hi Guys I have written this SQL Query :
CREATE TABLE tasks (id INT AUTO_INCREMENT, name VARCHAR(50), desc TEXT, address
VARCHAR(50), startDate DATE, lastWork DATE, progress
I'll try that one again
I have a query:
$sql = SELECT * FROM contacts ORDER BY ContactType;
There are two types of contacts:
* Commissioners
* Staff
As they are ordered by the ContactType then 'Commissioners' are
displayed first followed by 'Staff'.
I'd like to be able to display a
Mailing List (E-mail)
Subject: [PHP-DB] SQL query prob
I'll try that one again
I have a query:
$sql = SELECT * FROM contacts ORDER BY ContactType;
There are two types of contacts:
* Commissioners
* Staff
As they are ordered by the ContactType then 'Commissioners' are
displayed first followed
I have a database layout similar to this-
id order title namepagecat
0 0 title1 blueap
1 2 blue1 page1 ap
2 3 blue2 page2 ap
3 1 blue3 page3 ap
I would like to get title1 (title
.
Regards,
SenthilVelavan.P
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, June 15, 2002 2:39 AM
Subject: [PHP-DB] sql query problem
I have a database layout similar to this-
id order title namepagecat
0 0 title1 blue
I am having a minor problem doing a simple sql query.
Error performing service query : You have an error in your SQL syntax near '' at line 1
Here is a snip of the code: Please let me know what you think.
if ($submit):
$status=0;
// REQUEST INFO FOR SERVICES
$results = mysql_query(
SELECT *
PROTECTED]]
// Sent: Tuesday, 19 February 2002 9:31 AM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] sql query
//
//
// I am having a minor problem doing a simple sql query.
//
// Error performing service query : You have an error in your
// SQL syntax near '' at line 1
//
// Here is a snip
to make sure you are getting the right thing.
HTH
/b
// -Original Message-
// From: CrossWalkCentral [mailto:[EMAIL PROTECTED]]
// Sent: Tuesday, 19 February 2002 9:31 AM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] sql query
//
//
// I am having a minor problem doing a si
/ANSI_diff_Sub-selects.html
-Original Message-
From: Pierre
Sent: Mon 11/12/2001 12:20 AM
To: Gonzalez, Lorenzo; [EMAIL PROTECTED]
Cc:
Subject: Re: [PHP-DB] SQL query
Thanks but I think subselect
I have two tables, one call category, the other chapter
Category table
[id][name]
[1][a]
[2][b]
[3][c]
[4][d]
Chapter table
[id][FK_name]
[1][a]
[2][a]
[3][c]
I would like to get the list of names of the Category table that are NOT present in
the Chapter table.
On this example, I should find
Sent: Sun 11/11/2001 10:01 PM
To: [EMAIL PROTECTED]
Cc:
Subject: [PHP-DB] SQL query
I have two tables, one call category, the other chapter
Category table
[id][name]
[1][a]
[2][b
Thanks but I think subselect is not possible with MYSQL.
Pierre
- Original Message -
From: Gonzalez, Lorenzo [EMAIL PROTECTED]
To: Pierre [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, November 12, 2001 1:08 PM
Subject: RE: [PHP-DB] SQL query
in other RDBMs this is easily done
hi:
I have 2 tables, lesson and lesson_gle, where lesson
holds lesson data and lesson_gle holds repeating data
that are how the lesson correlates to various state
standards (one lesson can have many
correlations)...one particular lesson may have a math
correlation as well as a language arts
35 matches
Mail list logo
