I am working on a quote system and have been trying to figure out how to
make them system automatically add an entire vendor or category at one
time. I can make the system display all of them and give the sales
folks in my office a chance to change the price, however if I have just
one Add button
!
~~~
I've been writing a book. I've got the page numbers done.
-Steven Wright
~~~
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 2:11 PM
To: Robert Sossomon
:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 2:39 PM
To: Robert Sossomon; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Multiple adds?
From: Robert Sossomon [EMAIL PROTECTED]
An example is: http://www.garlandcnorris.com/quotes/seestore.php
I have a session tracker installed on it already
Where are you getting the PHP variable from, another page, or ???
I use the print function in my scripts, mainly have the script write
everything to one big variable and then printing the variable. By using
this method I can code the pieces in the big variable and they all come
out nice and
Sorry, I was over thinking...
Just modify it by removing the echo and the / and it should code right
out for you.
a href=abc.php/?day=+?echo $start_day;? /a
BECOMES:
a href=abc.php?day=$start_day /a
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Right, sorry I left that part out because it basically depends on what
you are doing..
/*** Test Page ***/
?php
$start_day = date;
$end_day = date2;
$display_block = a href=\abc.php?day=$start_day\ /abr;
$display_block .= a href=\abc.php?day=$end_day\ /abr;
?
htmlbody
? print
I'm looking for a few scripts, since my coding ideas and trying to use
GoLive6 is too cumbersome.
I have seen some shopping carts that are freeware, and I am looking for
ones that will do shopping carts and at the same time do a salesmen's
interface to it as well, something like:
George is a
I've been racking my brain and the web for finding a solution and no
luck so far.
Here's the form:
$display_block .= HRInput item: form method=post
action=\additem.php\nbsp;nbsp;nbsp;nbsp;Item ID:input
type=\text\ name=\sel_item_id\BRQuantity: select
name=\sel_item_qty\;
$display_block .= option
The errors as it prints are:
The query I just ran was: select * from GCN_items where `item_num` =
'%fm-a294%'
The query I just ran was: Resource id #2
0
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 11:04 AM
To: Robert Sossomon
!
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 04, 2003 1:31 PM
To: Robert Sossomon; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Query Error
From: Robert Sossomon [EMAIL PROTECTED]
The errors as it prints are:
The query I
I am seeing some errors with a program I wrote and I need to write
everything to a log file that the program is doing.
The following syntax I KNOW is wrong, but not sure they are important to
put here correctly yet.
//script addtocart
$Addcart (info1, info2)
Mysqlquey($addcart)
I am seeing
a log file
$Addcart() -- is Addcart() a function (in which case you should remove
the dollar sign) or are you specifically trying to do some magic there
by running a function whose name is stored in that variable?
Bogdan
Robert Sossomon wrote:
I am seeing some errors with a program I wrote
I have been modifying the quote system I have been writing like mad and
have hit another brick wall of sorts.
I am trying to do a couple of things...
The search is now up and running on just a DESCRIPTION field. Anything
else at this point is unwieldy. It works perfectly however I am trying
to
I have a form that allows for an item to be entered, the other pieces
have been fixed so far that were bogging me down, but now I am looking
for a way to convert any entry in the form to be UPPER case so that when
the quote is listed, they are alphabetical.
The problem is if someone enters
Explode the kewords list. I have mine explode the keyword and search
the description field. It CAN limit it by category AND/OR by Vendor.
But this will do the trick without the limiters.
$keyword = $_POST[keyword];
$keywords = explode( , $keyword);
// so you can search for each word they enter
Help:
snip
$sql = select id1 from GCN_Salesmen where username = '$PHP_AUTH_USER';
$user_id = mysql_query($sql) or die(mysql_error());
/snip
Produces: You have an error in your SQL syntax near 'id #2' at line 1
snip
$sql = select id1 from GCN_Salesmen where username = $PHP_AUTH_USER;
$user_id =
OK folks,
I've been working on a quote system for a while and now the boss has
added a new twist.
He wants to be able to hook a PDA up to it, push a single button, and
the system transmit and receive data including:
New prices, customers, data, etc...
I figure I am going to have to run some
Here's my dilemma:
2 tables and 2 others that have current data in them.
The 2 tables that have the current data in them I know how to display,
the problem I am having is the 2 tables I need to transfer information
to have to have the same key in one location
Tables:
CREATE TABLE `store_orders`
// This is just 1 query, I have not tested it, but it may work.
$get_Quote = select ph.id, ph.img, cm.id, cm.phid, cm.txt, rt.id,
rt.phid, rt.text from photos as ph left join comments as cm left join
ratings as rt on ph.id = cm.phid = rt.phid where id = '$photo_id' order
by ph.id;
//runs the
I have a form:
http://www.garlandcnorris.com/registration_tradeShow.html
That then goes to this page:
code
$display_block = ;
$date_sub = date(mdY - H:i:s);
$addtocart = insert into show
values('','$_POST[Accnt_name]','$_POST[acc_num]','$_POST[email]','$_POST
How can I write a sort to sort on 2 columns, one ascending, one
descending?
$get_list = select * from access_tracking where user = '$user_id' order
by time,date_accessed desc
But the ordering seems backwards sorted by date first, and then time.
TIA!!
Robert
--
PHP Database Mailing List
Still a newbie and clums at this stuff and am running into a brick wall
with this.
I need to pull an item out of the database, turn it to lowercase, and
then look to see if the file is located in another directory. If it is
then it prints out one thing, if not it prints out another. What I am
]
Sent: Wednesday, April 07, 2004 11:35 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] File there or not?
From: Robert Sossomon [EMAIL PROTECTED]
My question:
How do I pull the item and turn it to lower? Strtolower?
strtolower()
How do I check it against a directory to see
I have this script which SHOULD produce a linked webpage for soon-to-be
created static web pages, however I can't seem to find the error in my
code:
?php
//connect to database
include 'db.php';
$display_block = h1PFS Sales Categories/h1 PSelect a category to
see its items./p;
//Show categories
?
-Original Message-
From: Robert Sossomon [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 08, 2004 3:41 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Where's the error?
I have this script which SHOULD produce a linked webpage for soon-to-be
created static web pages, however I can't seem to find
somewhere.
-Original Message-
From: Robert Sossomon [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 08, 2004 3:56 PM
To: 'Edward Peloke'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Where's the error?
It is not displaying anything at all.
-Original Message-
From: Edward
: Friday, April 09, 2004 3:52 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Where's the error?
does the page actually error or does it not do anything?
-Original Message-
From: Robert Sossomon [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 08, 2004 3:41 PM
! ;)
-Original Message-
From: Robert Sossomon [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 08, 2004 4:05 PM
To: 'Hutchins, Richard'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Where's the error?
Nothing, htmlbody/body/html
I just found this in the error log:
PHP Parse Error: parse
If it is a MySWL database, the following code works great
?
$sql = select choice, description from views;
$result = mysql_query($sql) or die(mysql_error());
$viewing = ;
$viewing .= select name=\view_code\\n;
while ($view_list = mysql_fetch_array($result))
{
$view_code = $view_list[choice];
I am pulling data from a MySQL DB and I need to remove the whitespace on
the variable and turn it to lowercase.
! Code Snippet
$get_items = select * from PFS_items;
$get_items_res = mysql_query($get_items) or die(mysql_error());
while ($items = mysql_fetch_array($get_items_res))
{
$item_id =
I need to add PHP calls to include a file to each page as it is
generated, the only thing is I can't get the includes to come through
correctly:
! Code
$display_block .= ?php include(\nav/top_nav.html\); ?;
$display_block .= ?php include(\nav/side_nav.html\); ?;
! End Code
At the end of
Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 11:33 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP] Adding includes to files
From: Robert Sossomon [EMAIL PROTECTED]
I need to add PHP calls to include a file to each page
the right files. It's on track and working all neat
and tidy now.
Thanks for the help guys! I still feel like a doofus though...
Robert
-Original Message-
From: Richard Harb [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 11:46 AM
To: Robert Sossomon
Cc: [EMAIL PROTECTED
Here's the solution I came up with that works for the site:
code snippet
$display_block .= ?php\n;
$display_block .= \n include(\../nav/top_nav.html\);;
$display_block .= \n;
$display_block .= include(\../nav/side_nav.html\);;
$display_block .= \n?;
end code snippet
I am only
My IF statement should be picking up on the numbers, and if the number
matches not be displaying out the information, however I look at the
outputted page and the information is still there, what have I got wrong
on the code?
CODE SNIPPET
//Show categories first
$get_cats = select id_num,
35 matches
Mail list logo