**
IMPORTANT NOTICE
This communication is for the exclusive use of the intended recipient(s)
named above. If you receive this communication in error, you should
notify the sender by e-mail or by telephone (+44) 191 224 4461,
for not including that.
Thanks
-Rich
-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 9:13 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Question on CURDATE()
What SQL server are you using?
On Tuesday 13 September 2005 7:08 pm, reclmaples
I am trying to write a statement that will basically do this:
SELECT * FROM WEEKS WHERE BEGIN = CURDATE() and END = CURDATE;
But for some reason I can only use one CURDATE() reference in my sql
statement, does anyone know why? Is there a way I can get around this?
Any help would be greatly
using?
On Tuesday 13 September 2005 7:08 pm, reclmaples wrote:
I am trying to write a statement that will basically do this:
SELECT * FROM WEEKS WHERE BEGIN = CURDATE() and END = CURDATE;
But for some reason I can only use one CURDATE() reference in my sql
statement, does anyone know why
All,
I know this is the wrong distro to be sending this request for help to
but I dont know which one to send this to. If you could either point me in
the direction that I should go or help me, I would greatly appreciate it.
Here is my issue.
I have a set of date that I want returned in
Sorry, the data under 'Looking something like this' should be in a table
format with 3 columns and 4 rows.
-Original Message-
From: ReClMaples [mailto:[EMAIL PROTECTED]
Sent: Friday, July 29, 2005 8:46 PM
To: PHP
Subject: [PHP-DB] Help Needed
All,
I know this is the wrong distro
You ROCK!!! Thanks so much, this worked perfectly!!!
Thanks
-Rich
-Original Message-
From: Alain Rivest [mailto:[EMAIL PROTECTED]
Sent: Friday, July 29, 2005 10:10 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Help Needed
ReClMaples a écrit :
Sorry, the data under 'Looking
..
Sorry for not catching this earlier, I didn't realize the query itself
was stored in the DB.
ReClMaples wrote:
All,
Here is the code that I'm using. I have a form that feeds that top
values to this page:
?php
$pos = $_POST['sel_pos_name'];
$year = $_POST['sel_year_name'];
$cat_name = $_POST
I am having a problem getting a sql statement to run.
I have this in a table called stat_categories, in a field called sql2
select a.name,a.position,a.team,sum(b.yards) as Results from player
a,passing b
where
a.player_num = b.player_num
and a.position = '$pos'
and b.year = '$year'
group by
= $div group by a.name order by Results desc
limit '$display'
As you can see the variables aren't being changed, any ideas?
Thanks
-Rich
-Original Message-
From: Jason Walker [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 6:54 PM
To: 'ReClMaples'
Subject: RE: [PHP-DB] Can someone
: Tuesday, June 07, 2005 7:21 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Subject: RE: [PHP-DB] Can someone help me out?
can you show the code around it? are you using single quotes in defining the
sql statement? or double quotes?
Bastien
From: ReClMaples [EMAIL PROTECTED
The default for limit starts at one, so you don't need the two variables.
My issue is with the variables not putting their value in.
Thanks
-Rich
-Original Message-
From: Isidor Stankov [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 7:56 PM
To: ReClMaples
Subject: Re: [PHP-DB
..
Sorry for not catching this earlier, I didn't realize the query itself
was stored in the DB.
ReClMaples wrote:
All,
Here is the code that I'm using. I have a form that feeds that top
values to this page:
?php
$pos = $_POST['sel_pos_name'];
$year = $_POST['sel_year_name'];
$cat_name = $_POST
Hello all,
I am having an issue with displaying a variable from another php script.
Can you help please?
Here is the code that Im using:
?php
$item_ttlprice = $_POST[$ttl_price];
?
html
body
Your price is: $
?php
echo $item_ttlprice;
?
body
/html
pretty simple I would think but I cant
I'm not sure if this is the correct distro to be sending this question to,
if it's not, let me know which one I should send it to.
I am having an issue where a variable in on php file won't go to the next
php file:
Here is the code I am using:
get colors
$get_colors = select Cat_Name from
I apologize but I figured out my mistake.
Thanks
-Rich
-Original Message-
From: ReClMaples [mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 10:05 PM
To: PHP
Subject: [PHP-DB] Help with PHP
I'm not sure if this is the correct distro to be sending this question to,
if it's
Can someone help me out with an issue I'm having?
Here is my code:
$res = mysql_query(SELECT ZG_LATITUDE, ZG_LONGITUDE FROM zip_code
wherezg_zipcode = '$zip');
List($Lat,$Lon) = mysql_fetch_row($res);
$Lat1 = ($Lat-2);
$Lat2= ($Lat+2);
$Lon1= ($Lon-2);
$Lon2= ($Lon+2);
//echo ($Lat1);
; $Lon2=Lat+2;
Now you can use the values in your final query.
Hth Henrik Hornemann
-Oprindelig meddelelse-
Fra: ReClMaples [mailto:[EMAIL PROTECTED]
Sendt: 16. april 2005 22:38
Til: php-db@lists.php.net
Emne: [PHP-DB] PHP and MySql question
Hello, I'm kinda new at PHP programming with MySQL
Hello, I'm kinda new at PHP programming with MySQL. I am having an issue
and am not sure if this is the corret way to do this: Here is my code, I'll
start there:
?php
$Lat1 = mysql_query(
SELECT (ZG_LATITUDE-2) FROM zip_code where zg_zipcode =
'$zip');
if (!$Lat1) {
All,
I have a question as how I can return some results that I am looking
for. Ideally I'd like to run this sql statement but for some reason MySql
won't allow me to run it:
SELECT
*
FROM
zip_code
WHERE
zg_latitude between ((select zg_latitude from zip_code where zg_zipcode =
I have a quick, probably easy to answer question. I am trying to add the
ability to email from like a quest book or a calendar event and get an
authentication error in my error log. I can only believe that this is due
to my smtp server needed to know my login and password. Is there a way I
can
21 matches
Mail list logo