Re: [PHP] function not returning query

2009-11-23 Thread Allen McCabe
Okay, suddenly I got it to filter the results, but I still can't figure out where this part of the query is coming from, at the end of the query string in the URL, I have this "filter.x=0&filter.y=0". No where in my form do I have a field named filter.x or filter.y. I DO however, have 3 forms (I d

Re: [PHP] Query based on Server offset TimeStamp

2009-11-23 Thread Philip Thompson
On Nov 23, 2009, at 7:37 PM, Don Wieland wrote: > Hello, > > I have a mySQL database server in Florida USA (EST) and I want to do a query > on a record in California, USA (PST) 3 hours earlier using PST instead of EST. > > I would like to add to my CORE page that offset of the timezone so I can

Re: [PHP] function not returning query

2009-11-23 Thread Philip Thompson
On Nov 23, 2009, at 6:22 PM, Allen McCabe wrote: > Hi, thanks for reading, I hope you can help: > > In my main file for an orders page I have the following code: > > > if (isset($_GET['filterby'])) > { > $resultOrders = adminFilterQuery(); > $numberOfOrders = mysql_num_rows($resultOrders); >

[PHP] Re: My experience with the "Forms Generation and Validation" class

2009-11-23 Thread Manuel Lemos
Hello Anonymous complainer, on 11/22/2009 09:23 AM LinuxManMikeC said the following: > Just like to share my real world experience with Manuel Lemos' > "formsgeneration" library. > http://www.phpclasses.org/formsgeneration > > At work early this summer we had a project under a tight deadline that

[PHP] Query based on Server offset TimeStamp

2009-11-23 Thread Don Wieland
Hello, I have a mySQL database server in Florida USA (EST) and I want to do a query on a record in California, USA (PST) 3 hours earlier using PST instead of EST. I would like to add to my CORE page that offset of the timezone so I can use it in a query like: Select * FROM aTable WHERE

Re: [PHP] function not returning query

2009-11-23 Thread Phpster
Likely your query failed due to an error. Try adding an or die(mysql_error()) to the end of your mysql_query statement to see what that error maybe Bastien Sent from my iPod On Nov 23, 2009, at 7:22 PM, Allen McCabe wrote: Hi, thanks for reading, I hope you can help: In my main file for

[PHP] function not returning query

2009-11-23 Thread Allen McCabe
Hi, thanks for reading, I hope you can help: In my main file for an orders page I have the following code: if (isset($_GET['filterby'])) { $resultOrders = adminFilterQuery(); $numberOfOrders = mysql_num_rows($resultOrders); } else { $resultOrders = mysql_query("SELECT * FROM afy_order;

[PHP] Re: PHP and XML

2009-11-23 Thread Nathan Rixham
Juan Marcelo Rodríguez Monti wrote: > Hi people, > I have some doubts about this topic that I'm gonna explain. > > I have a few sites in flash, and I was requested to write a PHP frontend > to send news. I have this already done and it works perfect. It's a LAMP > App to send and edit news, post v

Re: [PHP] Change styling depending on var value

2009-11-23 Thread Phil Matt
Mari Masuda wrote: This may be a dumb question, but did you actually fetch the db query's results and put them in $row before trying to use $row? In MySQL you could do something like: $query = "select * from my_table"; $result = mysql_query($query); $row = mysql_fetch_array($result); //this

Re: [PHP] Which query is more correct?

2009-11-23 Thread LAMP
Rick Pasotto wrote: On Fri, Nov 20, 2009 at 04:41:58PM -0600, LAMP wrote: Hi, I need to pull all records from the table Registrants they are NOT in the table ToBeRecleared Registrants.Reg_ID is PK ToBeRecleared.tbrc_Reg_ID is PK Which query is more correct? SELECT r.* FROM registrants r wh