I'm not sure if this is the correct distro, if not please let me know which
one I should send this to.
I am having an issue that I can't figure out. I have a table that has a
HOME and AWAY fields in it. I want to make those two fields (the result
will be one record in HOME and one record in AWAY
.16
Sorry 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
**
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,
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
>
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 a
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 '
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
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 3
nside the DB, you
have to manually pull them out..
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:
>
>
nside the DB, you
have to manually pull them out..
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:
>
>
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: [P
ariable and they all come back, except in
the variables sql1 and sql2.
Thanks
-Rich
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: 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 m
team_div = $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'
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 a.na
te any help you could
offer.
Thanks
-rich
-Original Message-
From: Philip Hallstrom [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 11, 2005 4:36 PM
To: ReClMaples
Cc: PHP
Subject: Re: [PHP-DB] Need some help
> I am having an issue with displaying a variable from another php script.
>
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:
Your price is: $
pretty simple I would think but I cant figure out what Im doing wrong.
The above is the new script. Below is the script that the
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&
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 l
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);
net
Subject: SV: [PHP-DB] PHP and MySql question
Hi,
Your problem is that your variables $Lat1,$Lat2,$Lon1,$Lon2 all reffer
to resultsets and not the Latitudes or Longitudes.
Try something like this:
$res = mysql_query(
"SELECT ZG_LATITUDE, ZG-LONGITUDE FROM zip_code where
zg_zi
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:
Error performing query: " .
mysql_error() . "");
exit();
}
$Lat2 = mysql_query(
"SELECT (ZG_LATITUDE+2) FR
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 =
'78730')
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 p
23 matches
Mail list logo
