[PHP-DB] Assistance on Query

Hi People, I would like some assistance on the following scenario. I have to pull out all records for a particular userid (easy enough) and then only show those entries where the follwing occurs. These records from the table will contain either an entry in the services_type field or the

[PHP-DB] Re: Adding Up MySQL Results

snip I run this mysql query: select sum(quantity)*price,price from sale where dvd_id=1 group by price; I get this result: sum(quantity)*price price 450.00 15.00 29.99 29.99 I want to display the sum of the values in the first column (450.00+29.99), but I

Re: [PHP-DB] Assistance on Query

Shannon Doyle wrote: Hi People, I would like some assistance on the following scenario. I have to pull out all records for a particular userid (easy enough) and then only show those entries where the follwing occurs. These records from the table will contain either an entry in the services_type

[PHP-DB] No communication between PHP 5.0.3 +MySQL 4.1.9

Will somebody please help me!!! I'm trying to set up my web server for PHP and MySQL. I've installed PHP 5.0.3 and it works fine. I've installed MySQL 4.1.9 and it works fine. BUT, I can't access MySQL from PHP. I have put the php_mysqli.dll and libmysql.dll in the C:\PHP folder, removed the

Re: [PHP-DB] No communication between PHP 5.0.3 +MySQL 4.1.9

Thanks Micah, but I've already tried that one. James Micah Stevens [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Have you set the extensions_dir properly? It may not be looking in c:\PHP for the extension.. -Micah On Sunday 16 January 2005 10:37 am, J A Brown wrote: Will

Re: [PHP-DB] No communication between PHP 5.0.3 +MySQL 4.1.9

Well, even if that's not the exact issue, the problem almost certainly lies in the inability of php to properly load the extension. That's where you should look. The connection to MySQL is not in question here. -Micah On Sunday 16 January 2005 12:42 pm, J A Brown wrote: Thanks Micah, but

RE: [PHP-DB] Assistance on Query

Hi Jochem, My apologies, when I typed consecutive, I meant by date. Basically the query is for a report. The client wants to be able to see when there have been 3 or more entries of non_services_type between services_type entries, and then display these entries. I am using MySQL and would Order

Re: [PHP-DB] Assistance on Query

Shannon Doyle wrote: Hi Jochem, My apologies, when I typed consecutive, I meant by date. Basically the query is for a report. The client wants to be able to see when there have been 3 or more entries of non_services_type between services_type entries, and then display these entries. I am using

[PHP-DB] Dealing With MySQL's new Time Calculations

I have an interesting problem I'm trying to solve. Right now, I'm keeping track of sessions starting and ending times with a PHP datetime field, and calculating the total time spent in all sessions with the new PHP time command... something like this: $total_minutes = mysql_query(select

[PHP-DB] Security Question

Hi everyone, I have a security question, I want to see if I am right or wrong. I have programmed a system with PHP and MySQL, the main system resides on a secure server, but the client wants the login page on a NON-Secure server for marketing purposes. Am I the only one who thinks this is a

Re: [PHP-DB] Security Question

If it submits to a secure server the form data will be encrypted before transmission I believe. At least that's my understanding, and that seems to be how ebay does it for example. Once you log-in, it submits to a secure page. -Micah On Sunday 16 January 2005 06:38 pm, Chris Payne wrote:

RE: [PHP-DB] Security Question

Hi It is better from a security point of view to have a secure login. The secure server encrypts the data between the browser and the server, making it impossible to read on its journey from you to the server. However whether it is a major security problem is another question. To view the

Re: [PHP-DB] Security Question

But what I'm saying is that if you're submitting a form from an unsecured page, to a script on a secure server, the data will still be encrypted. Anyone know this for sure to be correct? It sure makes sense this way. On Sunday 16 January 2005 07:27 pm, Peter Lovatt wrote: Hi It is better

Re: [PHP-DB] Assistance on Query

Can you do what you require by grouping by your type. setting a count field and then a where count 3? However if you then need to know the details from the three consecutive fields then I don;t think it can be done in SQL so you'll need to revert to php. graeme Jochem Maas wrote: Shannon

Re: [PHP-DB] Dealing With MySQL's new Time Calculations

Set your select to group by userid, select on min(tourney.start) value and max(tourney.start) value where closed = 1 etc. graeme. [EMAIL PROTECTED] wrote: I have an interesting problem I'm trying to solve. Right now, I'm keeping track of sessions starting and ending times with a PHP datetime

Re: [PHP-DB] Dealing With MySQL's new Time Calculations

Sorry that should have been max(tourney.finish) :-[ graeme graeme wrote: Set your select to group by userid, select on min(tourney.start) value and max(tourney.start) value where closed = 1 etc. graeme. [EMAIL PROTECTED] wrote: I have an interesting problem I'm trying to solve. Right now, I'm