[PHP] selecting based on a month in a date

2003-08-28 Thread Creative Solutions New Media
Hi, Asked this on the mySQL list but it seems to be more of a PHP syntax thing that a mySQL thing. In have the following line in PHP I have a mySQL table which contains dates formatted as dates(-xx-xx) I want to select all records based on a specific month. This is my select statement S

RE: [PHP] Newbie Question regarding Syntax

2003-08-17 Thread Creative Solutions New Media
PROTECTED] Sent: August 17, 2003 8:45 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Newbie Question regarding Syntax * Thus wrote Creative Solutions New Media ([EMAIL PROTECTED]): > Sorry guys.It think there is a bit of confusion. > > I miss typed what I need to do. > >

RE: [PHP] Newbie Question regarding Syntax

2003-08-17 Thread Creative Solutions New Media
Zirzow [mailto:[EMAIL PROTECTED] Sent: August 17, 2003 8:28 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Newbie Question regarding Syntax * Thus wrote Creative Solutions New Media ([EMAIL PROTECTED]): > HREF="mailto:[EMAIL PROTECTED]">'.$row_rep_RS['repEmail'].'

[PHP] Newbie Question regarding Syntax

2003-08-17 Thread Creative Solutions New Media
mailto:[EMAIL PROTECTED]">'.$row_rep_RS['repEmail'].''; ?> Obviously this isn't working. What is the proper syntax when you have to use double quotes inside the tag? Thx Tim Winters Manager, Creative Development Sampling Technologies Incorporated (STI) [EMAIL PROTECTED] [EMAIL PROTECTED] W: 902

[PHP] detecting referer

2003-08-14 Thread Creative Solutions New Media
Hello, Bit of a newbie question I guess. What is the best way, using php, to detect information about the referrer to a page. Is this possible/difficult using PHP? Thanks, Tim Winters Manager, Creative Development Sampling Technologies Incorporated (STI) [EMAIL PROTECTED] [EMAIL PROTECTED] W:

[PHP] Calling to a page without having to load it

2003-08-14 Thread Creative Solutions New Media
Hello, I have a weird problem I was hoping someone could help with. I have a client who hosts a site on a standard server (No PHP et all) Currently he has some Flash based content. Within the Flash content I can call to PHP pages in another domain to push and pull data from a mySQL DB into the

RE: [PHP] detecting referer

2003-08-14 Thread Creative Solutions New Media
PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP] detecting referer --- Creative Solutions New Media <[EMAIL PROTECTED]> wrote: > What is the best way, using php, to detect information about the > referrer to a page. echo $_SERVER['HTTP_REFERER']; To see all of the informatio

RE: [PHP] Problem sortiing dyn query

2003-08-10 Thread Creative Solutions New Media
D] Subject: Re: [PHP] Problem sortiing dyn query Creative Solutions New Media wrote: > Hi > > Can someone give me some indication why this might not be working? > > $query_Recordset1 = sprintf("SELECT * FROM sti_tracking ORDER BY '%s' '%s'", $query_Re

[PHP] Problem sortiing dyn query

2003-08-08 Thread Creative Solutions New Media
Hi Can someone give me some indication why this might not be working? $query_Recordset1 = sprintf("SELECT * FROM sti_tracking ORDER BY '%s' '%s'", $reSort_Recordset1,$direction_Recordset1); the values for $reSort_Recordset1 and $direction_Recordset1 are passed through from another page. $reSort

RE: [PHP] PHP, JavaScript and populating DropDowns

2003-07-30 Thread Creative Solutions New Media
ws($results); $i=0; echo "Select Car"; while ($i < $num) { $id=mysql_result($results,$i,"CarID"); $name=mysql_result($results,$i,"CarName"); echo "$name"; ++$i; } echo ""; echo "-- Select Color --"

[PHP] PHP, JavaScript and populating DropDowns

2003-07-29 Thread Creative Solutions New Media
Hello, I am using mySQL and PHP to pull some data into my page. I have 2 dropdown boxes. As an example lets say dropbox1 has a list of cars and dropbox2 has a list of colours. Here's the thing. The colours for each car vary so I won't know what colours to populate the 2nd dropbox with until a