PHP - Insert Time Minus One Hour

I am echo information from the database now I would like to insert these to different table. I am using checkbox to echo and when the user click on the one of these the result should be saved to a new table.

So far I have<?php
include 'Database/connection.php';

include 'Database/question_sql.php';

 while($info = mysql_fetch_array( $sql ))
 {
echo "{$info['Que_Question']} <br />\n";
echo "<input type=\"checkbox\" name=\"choice1[]\" value=\"{$info['Que_Choice1']}\" /> ";
echo "{$info['Que_Choice1']} <br />\n";
echo "<input type=\"checkbox\" name=\"choice2[]\" value=\"{$info['Que_Choice2']}\" /> ";
echo "{$info['Que_Choice2']} <br />\n";
echo "<input type=\"checkbox\" name=\"choice3[]\" value=\"{$info['Que_Choice3']}\" /> ";
echo "{$info['Que_Choice3']} <br />\n";
echo "<input type=\"checkbox\" name=\"choice4[]\" value=\"{$info['Que_Choice4']}\" /> ";
echo "{$info['Que_Choice4']} <br />\n";


 }


 ?>

Hi i need to count the number items in an album now on the album i have create a field called count which counts the number items in that album

but now i dnt knw how to update those as soon insert a item in the table item

so i thought woul be possible to create a script that when insert data into item tables also update album table row count by adding one like update count with A now A equal row count ++1  any help on start of it if possible???/

I have a form right now that Updates a table on my database.

I was wondering if I could possibly still have that working but also Insert the same information into another table on the database when the submit button is pressed?

What needs to be changed to make this work...
Code: [Select]
// Build query.
$q2 = "UPDATE member
SET logged_in=?,
last_activity=time(),
updated_on=NOW()
WHERE id=?
LIMIT 1";

Apparently PHP doesn't like time()   


Debbie

Code: [Select]
$date = date('m-d-y');
$ip = $_SERVER['REMOTE_ADDR'];

mysql_query("INSERT INTO users VALUES ($username, $password, 0, $ip, $date)") or die(mysql_error());

Error:

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 '.60.116, 03-06-11)' at line 1


I'm not sure why I get this error. :/

I'm not looking for code, mostly just some direction, but I'm sure I'll be back as I try to shape the code.  Also, I know very little about coding jQuery, Ajax, etc.  Here is what I'm looking for:

Basketball coach enters a Page that only he (or admin) can see.  (I have that part figured out.)
Once there, he has a form to fill out with a player's name and other information.

I'd rather there not be 12 rows of empty cells.  (Coaches will view that as work)
I'd rather not have the Page reload on each "Add", but that would be the lesser of two evils.

Is there a way to keep a persistent connection so when a coach hits Add, the player gets added to the database, a new empty form shows up, and the player's information shows up below on a roster?

Hi

Can someone point me in the right direction.

I can force php to put a Plus(+) sign in front of positive numbers with printf('%0+4.2f',$x)

But

I cant get this to work inside <option>printf('%0+4.2f',$x)</option> tags

Any help is greatly appreciated.

Hi

I'm using SimpleXMLElement to work with a supplied XML file, problem is with the way the XML document is formatted. The document uses '-' (minus) in the element names instead of _ so when I go to read the values, nothing is returned:
Code: [Select]
$developer->developer-region; //returns nothing
However if I change the sample XML document that I've been supplied to <developer_region></developer_region> and do
Code: [Select]
$developer->developer_region; //returns child elements
This is not practical to manually change the document, is there a way to use '-' in the xml document?

Thanks in advance
Ste

hi , i want  to select qty from master where id=$id , then i want to minus the qty = qty -1  and update in the query .
here is my code . can tell me what went wrong ?

Code: [Select]
$query= "SELECT qty FROM master where id=$id";
$result = mysql_query($query,$dblink);
  while($myrow = mysql_fetch_row($result))
  {
 qty -= 1;
 
  $query = "UPDATE master SET qty='$qty' WHERE id= $id";
$result = mysql_query($query,$dblink);

  }


thanks

Hi all

I have a string called $voucher_code which is a value used to deduct or add value to a shopping cart. If the value is a minus I need it to show the minus sign, or if it's a plus value, it needs to show a plus sign.

Here's my code:

<strong>&pound;&nbsp;-".number_format(($voucher_code),2)."</strong>

How do I modify the above code to show + instead of -- which it does at the moment?

Many thanks for your help

Pete

Hey guys,

Was wondering if someone could point me on the right path here. I am able to get the page URL using:

$url = (!empty($_SERVER['HTTPS'])) ? "https://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'] : "http://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'];

But was wondering if there was a way to drop the PHP variables attached to the URL.

e.g.

mysite.com/catalogue/?item=23

becomes

mysite.com/catalogue/

Can anyone help me out?

Thanks!

Hi all

I'm building a script which reads a XML document, and so far so good... until now!

the document uses '-' extensively all the way through it (not something that I would have chosen) so to combat this I've used {}.

The part of the document I am working on now, this simply does not work, and I really cannot see why...

XML
Code: [Select]
        <plot>
          <name-number>87</name-number>
          <price>183000</price>
          <bedrooms>4</bedrooms>
          <status>available</status>
          <summary>With three double bedrooms, including one en suite and a further bedroom plus family bathroom to the first floor,&amp;nbsp;separate lounge and&amp;nbsp;dining room with kitchen&amp;nbsp;and utility to the ground floor, the Otter is a modern home with a great deal to offer growing families.</summary>
          <feature>Separate lounge and dining room</feature>
          <feature>Kitchen with utility room</feature>
          <feature>Integral garage</feature>
          <feature>En suite to master bedroom</feature>
          <property-type>detached-house</property-type>
          <media>
            <caption>
            </caption>
            <type>image</type>
            <filename>1855_Otter-WhitehirstGrange.jpg</filename>
            <indexno>1</indexno>
          </media>
          <media>
            <caption>
            </caption>
            <type>floorplan</type>
            <filename>1386_Otter-WhitehirstGrange.pdf</filename>
            <indexno>2</indexno>
          </media>
          <media>
            <caption>
            </caption>
            <type>brochure</type>
            <filename>284_brochure.pdf</filename>
            <indexno>3</indexno>
          </media>
          <style-name>Otter</style-name>
        </plot>

PHP
Code: [Select]
echo $plot->{name-number}; // echoes nothing, should echo 87
echo $plot->price; // echoes 183000
echo $plot->bedrooms // echoes 4
echo $plot->{style-name} // echoes nothing, should echo Otter

This is frustrating the hell out of me, and I cannot see why this would work everywhere else in the XML document but not here.

Any ideas or help would be received with gratitude!

Hi, I'm having trouble with this:

Code: [Select]
$date = date('d/m/y') ;
echo $date;
echo "<br/>";
$date1 = strtotime('date -1 month');
echo date('Y-m-d', $date1);
My result looks like this:
Current Date:  19/05/11
Date minus 1 month:  1970-01-01

I want it to look like this:
Current Date:  19/05/11
Date minus 1 month:  2011-04-19

Hello,
I've been struggling for days on this problem now. And I'm getting frustrated!  I know that the answer is simple, and I've done it before but I cannot figure out what I'm doing wrong.
What do I want?
Well, I get a date from the database in this format: YYYY-MM-DD. I first want to distract one month from that and then set in into this form: YYYY, MM, DD. I've got this but it's not working (I've tried a lot different values).

$transformdate = date("Y-m-d", strtotime("-1 month", $d_datevalue)); 
$startpoint = str_replace("-", ", ", $transformdate);


Thanks,
NLCJ

Hello

$row[longdescription] contains a description of a product (complete with HTML mark-up).

I would like to display the first 250 characters in the results of a search. I would also like to remove any images that may crop up.

This is what I have so far...
Code: [Select]
echo strip_tags(html_entity_decode(substr(preg_replace('/<img[^>]*>/Ui', '', $row[longdescription]), 0, 250)));
The thing is (as you guys can probably already see), it also counts the HTML mark-up as characters and I get very different outputs (especially if an image occurs).

I'd appreciate if you could advise me as to the correct way of doing this.

Thank you