from a table, select row, display the row and update one field "lastused" using NOW().
error is"No rows returned matching id"
Code:
<?php
$db = new mysqli('localhost', 'root', 'cookie', 'homedb');
if ($db->connect_error) die ('Database connection
12Strings
Last Activity: Jul 18 '14, 02:37 PM
Joined: May 14 '14
Location:
-
trouble w/mysqli update
Hi all, after way too much time, research, criticism and even some suggestions this is my code to create a dropdown
from a table, select row, display the row and update one field "lastused" using NOW().
error is"No rows returned matching id"
... -
This is my code and it prints a separate page for each record satisfying the argument. You guys have helped so much, thanks
...Code:<!DOCTYPE html><html><head> <style> @page { size 8.5in 11in; margin: 2cm } div.page { page-break-after: always } </style> <style> table.center {margin-left:auto; margin-right:auto;} body {text-align:center;} </style> -
php pagebreaks
Hi guys, I need help understanding pagebreaks. My intention is to print another
page each time another row is extracted. the document doesn't fill the page.
The following code will break if a file overfills a page but not needed here.
Also, it shouldn't print "Page 1" or "Page 1". Thanks
=============== =============== =============== =============== ============
...Code:<html><head><title>Invoice</title>
-
Following is the complete code.The report is just what I'm after,I just can't retrieve the values? Note that I stripped
the one line down to basic and still nada.
...Code:<html><head><title>billing</title></head> <?php // define variables and set to empty values $acctno = $pd = $payrec = $orderno = $bname = $bstreet = $bcity = $bstate = $bzip = " "; $sname = $sstreet = $scity
Leave a comment:
-
u & I wish u hadn't said thatLeave a comment:
-
get php values via html
Hi, I'm seeking php values while in html. Can someone tell me why the date is displayed
while the 'acctno isn't? Thanks
Code:<input type=text name="Date" value="<?php echo date('m/d/y');?>"> <input type=text name="acctno" value="Account#:"<?php echo $acctno;?>"><br> -
Guess what? I got one of those AHA moments. The following code
is what I want in that it creates a menu and I can select and
display a table row. I still need to use that selection to update
the "lastused". I really appreciate your help.
...Code:<!DOCTYPE><html><head><title>email menu</title></head> <body><center> <form name="form"Leave a comment:
-
you mean the fetch? thanksLeave a comment:
-
this is my current code. clicking "submit" gets no result?
...Code:<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <html><body> <form name="form" action="" method="post"> Select email to view<SELECTLeave a comment:
-
mysqli dropdown
I'm attempting a mysqli dropdown to select and print one record from table and update one
field, ("lastused" ($currdate))in that record. I get the following errors: Any help?
Notice: Undefined index: lastused in C:\xampp\htdocs \home\emaildrop .php on line 109
Notice: Undefined index: target in C:\xampp\htdocs \home\emaildrop .php on line 110
target Total results: 0
Warning: mysql_fetch_arr ay()... -
how to code for page breaks and numbering
Hi, I'm trying to print this doc with heading at top of each printed page,
page# at bottom of each page, thousands "," at "totdue" and without the
filename on each page. any help? Thanks
...Code:<html><head><style> @page { size 8.5in 11in; margin: 2cm } div.page { page-break-after: always } </style> </head><body><center> -
I need help using js auto insert....
I'm trying to use js function to: upon entering "paidamt" change the "amtdue",
"prevbal",a uto-insert the current date(datepaid), change"pd", and increment
the "checkno". I had this working at one time but memory precludes the use of the
onblur. The following code displays all values for selected record from database
and only updates "paidamt". Any help?
...Last edited by Dormilich; May 14 '14, 07:42 AM. Reason: please use [code] [/code] tags when posting code
No activity results to display
Leave a comment: