Re: [PHP-DB] "Last monday" query question

On Friday 06 August 2004 05:33, Adrian Madrid wrote: > How do you select all articles from last monday on (and that I can use > that query today and always too)? I've been trying to figure out how to > do this query but so far all I can do is create a /very /long query and > it doesn't seem to work

RE: [PHP-DB] Php if statement in a form (solved)

Not to worry - manage to solve the problem using the line below $date=date('H:i'); echo ""; Thanks for all the input -Original Message- From: Baiocchi, Justin (CSIRO IT, Armidale) Sent: Friday, 6 August 2004 12:50 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Php if statement in a fo

Re: [PHP-DB] Php if statement in a form

try this?? if($row['timeout']=="") { echo ""; }else{ print $row["timeout"]; } - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 06, 2004 10:50 AM Subject: RE: [PHP-DB] Php if statement in a form > Well, this works: so you were a

RE: [PHP-DB] Php if statement in a form

Well, this works: so you were all on the right track if($row['timeout']=="") { print ""; }else{ print $row["timeout"]; } But now I get a parse error on the line -Original Message- From: Ng Hwee Hwee [mailto:[EMAIL PROTECTED] Sent: Friday, 6 August 2004 12:30 PM To:

Re: [PHP-DB] Php if statement in a form

what about this? if(empty($row["timeout"])) - Original Message - From: "Doug Thompson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, August 06, 2004 10:18 AM Subject: Re: [PHP-DB] Php if statement in a form > if (is_null($row["timeout"]).) > >

RE: [PHP-DB] Php if statement in a form

On Fri, 6 Aug 2004 11:04, Justin Baiocchi wrote: > Still no joy. The parse error actually refers to the -- if > ($row["timeout"] IS NULL); --- line. Please trim your replies. IS NULL is for mysl - try if ($row["timeout"]=== NULL) -- David Robley Heads I win, tails you lose. -- PHP Database

Re: [PHP-DB] Php if statement in a form

if (is_null($row["timeout"]).) [EMAIL PROTECTED] wrote: Still no joy. The parse error actually refers to the -- if ($row["timeout"] IS NULL); --- line. -Original Message- From: Eric Schwartz [mailto:[EMAIL PROTECTED] Sent: Friday, 6 August 2004 11:32 AM To: [EMAIL PROTECTED] Subject:

Re: [PHP-DB] bags o beans - filtering rows/array by value of an aggregated attribute

Grant Listhandle wrote: In the database "beans" i have a table "bags_o_beans" where each row represents a single bag, and columns named "bean_type" and "number_o_beans" My teenage son is having several thousand hungry friends over in half an hour, and I'm stuck making the bean dip... I'm going to

Re: [PHP-DB] MSSQL INSERT query problem

Chris wrote: Here is the code I use: [snip] $sql =& $db->prepare("INSERT INTO ExitSurveyAnswers (session_id, Question_id, answer) VALUES ?,?,?"); [snip] When I execute it I keep recieving and error message stating: DB Error: syntax error Not a MSSQL expert, but shouldn't the ?,?,? in your query hav

RE: [PHP-DB] Php if statement in a form

Still no joy. The parse error actually refers to the -- if ($row["timeout"] IS NULL); --- line. -Original Message- From: Eric Schwartz [mailto:[EMAIL PROTECTED] Sent: Friday, 6 August 2004 11:32 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Php if statement in a form Sorry. Forgot t

Re: [PHP-DB] Php if statement in a form

Sorry. Forgot to remove the word echo from that line. On Thu, 5 Aug 2004 21:29:01 -0400, Eric Schwartz <[EMAIL PROTECTED]> wrote: > On Fri, 6 Aug 2004 10:21:19 +1000, [EMAIL PROTECTED] > <[EMAIL PROTECTED]> wrote: > > Thanks Eric, > > > > I have changed it somewhat but am just getting a parse err

Re: [PHP-DB] Php if statement in a form

On Fri, 6 Aug 2004 10:21:19 +1000, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Thanks Eric, > > I have changed it somewhat but am just getting a parse error, > unexpected T_STRING on that line. > > My revised code is below: > > > print "Current Staff Working Alone"; > print ""; > print "\n";

RE: [PHP-DB] Php if statement in a form

Thanks Eric, I have changed it somewhat but am just getting a parse error, unexpected T_STRING on that line. My revised code is below: print "Current Staff Working Alone"; print ""; print "\n"; print "\n"; print "NameLocationTime inTime Out/tr>"; while ($row = mysql_fetch_array($result, MYSQL_B

Re: [PHP-DB] Php if statement in a form

On Fri, 6 Aug 2004 08:53:53 +1000, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hello, I wonder if someone could point me in the right direction here. > > I have a table that is displayed that is also a form, and allowed a > person to select a record to update using a radio button. With one of >

Re: [PHP-DB] [email protected] is currently protecting themselves from receiving junk mail using Spamcease Just this once, click the link below so I can receive your emails.

I'm going to revise this, because I just got the confirmation email. People should not click on the link. The link that it wants me to click on is http://www.tgpwizards.com/spamcease2/verify.php?id=[xxx] A quick check of the domai

Re: [PHP-DB] bags o beans - filtering rows/array by value of an aggregated attribute

On Thu, 5 Aug 2004 17:26:05 -0500, Grant Listhandle <[EMAIL PROTECTED]> wrote: > In the database "beans" i have a table "bags_o_beans" where each row > represents a single bag, and columns named "bean_type" and "number_o_beans" > > My teenage son is having several thousand hungry friends over in h

[PHP-DB] Php if statement in a form

Hello, I wonder if someone could point me in the right direction here. I have a table that is displayed that is also a form, and allowed a person to select a record to update using a radio button. With one of the fields of the form/table however, I would like it to display the value in the db (if

[PHP-DB] bags o beans - filtering rows/array by value of an aggregated attribute

In the database "beans" i have a table "bags_o_beans" where each row represents a single bag, and columns named "bean_type" and "number_o_beans" My teenage son is having several thousand hungry friends over in half an hour, and I'm stuck making the bean dip... I'm going to need 1 million beans of

[PHP-DB] MSSQL INSERT query problem

Here is the code I use: $dsn = "mssql://username:[EMAIL PROTECTED]/database"; $options = array( 'debug' => 2, 'portability' => DB_PORTABILITY_ALL, ); $db =& DB::connect($dsn, $options); if (DB::isError($db)) { $db->getDebugInfo(); die($db->getMessage()); } $sql =& $db->prepare("

[PHP-DB] "Last monday" query question

How do you select all articles from last monday on (and that I can use that query today and always too)? I've been trying to figure out how to do this query but so far all I can do is create a very long query and it doesn't seem to work all the time. Any ideas? Thanks in advance, -- Adrian

Re: [PHP-DB] [email protected] is currently protecting themselves from receiving junk mail using Spamcease Just this once, click the link below so I can receive your emails.

Spamcease is whitelist software for controlling Spam. It maintains a list of people from whom the recipient wishes to receive email. If you're not on the list, your email won't get through. It's called a "challenge/response" system. For each email sent to someone running spamcease, the server

Re: [PHP-DB] [email protected] is currently protecting themselves from receiving junk mail using Spamcease Just this once, click the link below so I can receive your emails.

It is bogus. If you notice, your emails still go to the list. Someone did this to php-general a bit ago. You can ignore it. There was speculation that it was an email harvester, checking to verify that return addresses are valid. --- Colin Kettenacker <[EMAIL PROTECTED]> wrote: > I got this for

Re: [PHP-DB] Apache / PHP Page built from a MySQL Database Diplay Problems

Hello Mitch, 1) Have you tried doing "SHOW SOURCE" in your browser? 2) Take a look at: http://www.php.net/manual/en/function.error-reporting.php Good luck! M> Here is the basic scenario: M> - Configuration data is gathered from Oracle servers then ftp'd to my M> apache / mysql serve

[PHP-DB] Apache / PHP Page built from a MySQL Database Diplay Problems

Here is the basic scenario: - Configuration data is gathered from Oracle servers then ftp'd to my apache / mysql server. - The apache / mysql server receives the datafile from the Oracle clients and loads the data into a MySQL database. - The webpages are coded using PHP, SQL, and some JavaScrip

RE: [PHP-DB] SQL Insert problem

1. echo your $sql to make certain it's as sound as you think. 2. i don't see execution of the query: mysql_query( $sql) - you'll have to put the die() & error after this function. Hth - mthompson At 12:05 PM 8/5/2004, Vincent Jordan wrote: I have inserted '$address2', correctly in the row however

[PHP-DB] RE: SQL Insert problem

All you have done here is just assigned the query string to a variable. This alone does absolutely nothing as far as the db is concerned. You need to execute the query against the db for it to have an effect. The mysql_query() function is used for all queries, not just selects. $sql = "INSERT

RE: [PHP-DB] SQL Insert problem

Try echoing out your query to the browser window before you send it to the database. A simple echo $sql should suffice. Then you can see what's actually being sent in the query string to the database. Thar may show you exactly what's going wrong. If your query string looks right, then the error lie

Re: [PHP-DB] SQL Insert problem

From: "Vincent Jordan" <[EMAIL PROTECTED]> > > > $sql = "INSERT INTO rmarequest (firstname, lastname, address, > > > address2, > > > city, state, zip, phone, email, serial, product, reason, > > > rmanumber)VALUES > > > ('$firstname', '$lastname', '$address', '$city', '$state', > > > '$zip', '$phon

Re: [PHP-DB] SQL Insert problem

"John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > From: "Vincent Jordan" <[EMAIL PROTECTED]> > > > Im having a problem inserting data. Ive looked over this again and again > and > > can not find what ive missed. Everything else works besides the db insert. > > It would

RE: [PHP-DB] SQL Insert problem

I have inserted '$address2', correctly in the row however it is still not putting the data in the table. I am not getting an error but I do believe I have correct syntax set to display problems. > -Original Message- > From: Hutchins, Richard [mailto:[EMAIL PROTECTED] > Sent: Thursday, Au

[PHP-DB] SQL Insert problem

Im having a problem inserting data. Ive looked over this again and again and can not find what ive missed. Everything else works besides the db insert. http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> "; $message = "$firstname $lastname $address $address2 $city $state $zip $ph

RE: [PHP-DB] SQL Insert problem

You're missing address2 in your list of values. This means that you have an unmatching number of column names and values in your query and that'll make the query bomb. Rich > -Original Message- > From: Vincent Jordan [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 05, 2004 10:25 AM >