[PHP-DB] I'm not getting any mailing list messages

I just subscribed to the list yesterday and have yet to receive any messages from the list. Any ideas? -- Chip Wiegand Computer Services Simrad, Inc 425-778-8821 425-771-7211 (FAX)

Re: [PHP-DB] I'm not getting any mailing list messages

Did you get this one?? On Aug 12, 2004, at 2:02 PM, [EMAIL PROTECTED] wrote: I just subscribed to the list yesterday and have yet to receive any messages from the list. Any ideas? -- Chip Wiegand Computer Services Simrad, Inc 425-778-8821 425-771-7211 (FAX) Dan Brunner Web Software Developer/IT

Re: [PHP-DB] I'm not getting any mailing list messages

nothing's been sent to it? This is not a heavy traffic list. I get maybe 4-5 messages a day from this one. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Thu, 2004-08-12 at 12:02 -0700, Chip Wiegand wrote: I just

Re: [PHP-DB] I'm not getting any mailing list messages

Well, it's working over here. I think it just had to do with the list being quiet at the moment because I don't recall seeing any new posts in a while. --JMR Chip Wiegand wrote: I just subscribed to the list yesterday and have yet to receive any messages from the list. Any ideas? -- -- PHP

[PHP-DB] How to do an update with arithmetic from a user input

I have an existing database and web page showing the query results. I have added another field to allow a user to input a two digit number. I want that number to change the number in one of the existing columns for the item it was input next to. I have these columns - Part Number

Re: [PHP-DB] How to do an update with arithmetic from a user input

On Thu, 12 Aug 2004 12:46:19 -0700, Chip Wiegand [EMAIL PROTECTED] wrote: I have an existing database and web page showing the query results. I have added another field to allow a user to input a two digit number. I want that number to change the number in one of the existing columns for the

Re: [PHP-DB] I'm not getting any mailing list messages

On Friday 13 August 2004 03:06, Peter Ellis wrote: nothing's been sent to it? This is not a heavy traffic list. I get maybe 4-5 messages a day from this one. sarcam that's because all the php-db questions (and more) are handled over at php-general /sarcasm To the OP, if you want to check

Re: [PHP-DB] How to do an update with arithmetic from a user input

Justin Patrin [EMAIL PROTECTED] wrote on 08/12/2004 12:55:24 PM: On Thu, 12 Aug 2004 12:46:19 -0700, Chip Wiegand [EMAIL PROTECTED] wrote: I have an existing database and web page showing the query results. I have added another field to allow a user to input a two digit number. I want

Re: [PHP-DB] How to do an update with arithmetic from a user input

Unless $part_number is a number, you're going to want to put quotes around it. Well, actually, you want to run mysql_real_escape_string() on it. You also don't seem to have an end to that if statement. Usually, people use curly braces around those: if(true) { //do something } - Original

[PHP-DB] Multiple queries using mysqli

Hello, I'm having a little bit trouble with mysqli (PHP 5.0.0 attached to MySQL 4.1.3-beta): I have a table test and two tables testdetails1 and testdetails2. Now let's see (I left out error checking to simplify my problem): 01| $db = new mysqli($host,$user,$passwd,$dbname); 02| 03| $qry =

Re: [PHP-DB] How to do an update with arithmetic from a user input

Justin Patrin [EMAIL PROTECTED] wrote on 08/12/2004 01:37:35 PM: Unless $part_number is a number, you're going to want to put quotes around it. Well, actually, you want to run mysql_real_escape_string() on it. You also don't seem to have an end to that if statement. Usually, people use

Re: [PHP-DB] How to do an update with arithmetic from a user input

You don't need the colon as well as the curly brace on your if. Again: if (isset($submit)) { //do stuff } Your update query doesn't say anything about the description, I don't see how it could eb affected. Also, looks like you're using register_globals. Check out this page and the links for

[PHP-DB] how do i install postgresql

Postgresql is running in my pc But i don`t use in php. What am i doing? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] how do i install postgresql

ufuk wrote: Postgresql is running in my pc But i don`t use in php. What am i doing? Depends upon the OS, but you probably just have to uncomment the proper extension line in php.ini and restart your web server. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

[PHP-DB] QUIZ

Dear Friends, This code isn't able to score the php quiz, Through command prompt I am able to write questions to database table, another php script can display questions in the database and ways to edit and delete the same However, when I submit the quiz I dont get score of the quiz. I am

[PHP-DB] [newbie] Form to email *and* insert row to MySQL

Hello guys, I have an HTML form with the action attribute set to the famous FormMail.pl and it works beautifully. However, I also want to insert the data into a MySQL database. Initially, I thought that I would let FormMail validate the data, send the email, and then redirect to a PHP script

[PHP-DB] Deleting older records

I have a tracking database but I only need things in it for about an hour I tried this DELETE * FROM `tblDownloadTrack` WHERE `timestamp` TIME_TO_SEC( NOW( ) ) but it gives me an error anybody help me out on this? MySQL 4.0.16 Dylan Barber

Re: [PHP-DB] Deleting older records

what was the error?? - Original Message - From: Dylan Barber [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 13, 2004 1:08 PM Subject: [PHP-DB] Deleting older records I have a tracking database but I only need things in it for about an hour I tried this DELETE * FROM

RE: [PHP-DB] Deleting older records

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM `tblDownloadTrack` WHERE `timestamp` TIME_TO_SEC( Dylan Barber www.codegalaxy.com - A webservices company DotNetNuke Portal Specialists

RE: [PHP-DB] Deleting older records

Okay I have a timestamp field how do I create a query to delete all entries older than an hour. Timestamp field is set by now() function. I can do this in Oracle but it escapes me in MySQL 4.0.16 Dylan Barber www.codegalaxy.com - A webservices company DotNetNuke Portal Specialists Simple

Re: [PHP-DB] Deleting older records

try DELETE FROM `tblDownloadTrack` WHERE `timestamp` TIME_TO_SEC( NOW( ) ) - Original Message - From: Dylan Barber [EMAIL PROTECTED] To: 'Ng Hwee Hwee' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, August 13, 2004 1:17 PM Subject: RE: [PHP-DB] Deleting older records 1064 - You

RE: [PHP-DB] Deleting older records

Okay closer but the query doesn't seem to return anything Query DELETE FROM `tblDownloadTrack` WHERE TIME_TO_SEC(`timestamp`) TIME_TO_SEC( NOW( ) )-60 Is this even the right track for something like this? Dylan Barber www.codegalaxy.com - A webservices company DotNetNuke Portal

Re: [PHP-DB] Deleting older records

wat about using php mktime() (codes below not tested)?? $time = date(YmdHis, mktime(date(H)-1, date(i), date(s), date(m), date(d), date(Y))); $query = DELETE FROM `tblDownloadTrack` WHERE `timestamp` '$time'; mysql_query($query); - Original Message - From: Dylan Barber [EMAIL