php-general Digest 24 Nov 2009 02:54:56 -0000 Issue 6457

2009-11-23 Thread php-general-digest-help
php-general Digest 24 Nov 2009 02:54:56 - Issue 6457 Topics (messages 300038 through 300043): Re: Change styling depending on var value 300038 by: Phil Matt Re: PHP and XML 300039 by: Nathan Rixham function not returning query 300040 by: Allen McCabe 300041

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

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

[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 video,

[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

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 allenmcc...@gmail.com wrote: Hi, thanks for reading, I hope you can

[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

[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

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); } else

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 use

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=0filter.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