I'm trying to input that data entered into a form into a table in my DB.
Here is the code I have.
$db = mysql_connect("localhost","cloft","spring");
mysql_select_db("countryloft",$db);
$sql = "INSERT INTO catalogreq
(BFNAME,BLNAME,ADD1,ADD2,BCITY,BZIPA,BSTATE,BCTRY,BTELO,DATE) VALUES
('$BFN
I'm trying to use PHP and MySQL to query a table and write the contents to a
new file. When run the command to outfile it tells me I don't have
permissions. This is on a Unix machine.
mysql> select * into outfile
"/home/u1/funfun/www.somewebsite.com/catalogreq/
catalog.txt"
mysql> fields terminat
My problem is that I'm trying to run the query via a telnet sessions before
I code through PHP. Is there a solution that anyone knows for this?
"James Kupernik" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I'm trying
I'm trying to create a new file on my server from the data in a table. When
I do the query it returns a permission error. I'm logged into my server
through a telnet sessions and the permissions on the dir allow me to write
to it. Here is the query below.
mysql> select * into outfile "/home/u1/me/
I'm creating this form where the person needs to enter a password to move
on. When they enter the password it just loops back to enter the password
and doesn't move on. But then I remove the requirement for a password the
page moves on and loads the information from the DB. Why is this?
--
PHP
I found the problem in the form and fixed that, but now anytime I want to
submit the form by hitting enter, it acts like it's reloading the page. What
would be the cause of that? When I click on the submit button the
verification and program function correctly, but when I hit enter, they do
not.
\n"
,
$myrow[0],$myrow[1],$myrow[2],$myrow[3],$myrow[4],$myrow[6],$myrow[5],$myrow
[7]);
}
echo "\n";
}
}
if (!$submit || $error) {
echo "$error\n";
?>
Who is this?
Choose your name
James Kupernik
Tammy Kupernik
I run this query $countreq = mysql_query("SELECT COUNT(*) FROM catalogs
WHERE PROCESSED IS NULL"); then try to echo $countreq but end up getting
Resource id #2 instead of the count total. What would cause this?
Thanks for any advise!
James
--
PHP Database Mailing List (http://www.php.net/)
T
Yes another question ... I thank all that have taken to help me learn these
new things.
I want to display 10 records per page and allow the user to move on to the
next page of new records. The code below allows me to move to the second
page of records but not any further. I can't seem to think wh
n mark. Change
> to this & and you should be all set.
>
> Regards,
> James Chin
> Technical Support Consultant
> OpenLink Software http://www.openlinksw.com
> Universal Data Access & Data Integration Technology Providers
>
> On Fri, 18 Jan 2002 14:02:51 -0500, [EM
Is it possible to select 10 records that have a NULL field and update that
field to become Y instead of NULL? If so what would this syntax be?
This is what I have now
$result = mysql_query("SELECT * FROM catalogs WHERE PROCESSED IS NULL LIMIT
$i,10");
I want to add an UPdate to it, but not sure
when I try to do the update with a limit on which records, it gives me a
sytax error on the limit, is there anyway to get around this?
UPDATE catalogs SET PROCESSED = 'Y' LIMIT $i,10
thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For addit
I'm trying to take the contents of a table and write them to a file on my
server. Everything seems to function ok (AKA no errors) but no file gets
written ... I can't figure out why. Can anyone shine some light on this dark
problem?
$db = mysql_connect("localhost","cloft","spring");
Still when I make the changes suggested the file will not be created, yet I
get no form of an error message.
Is there something else I'm missing?
> I'm trying to take the contents of a table and write them to a file on my
> server. Everything seems to function ok (AKA no errors) but no file get
I'm trying to load phpMyAdmin on, and it seems to work fine, but when I
browse a table and run my mouse over the contents of that table I get a
jazascript error. Does anyone know a solution for this problem? I doesn't
happen in the earlier version of phpMyAdmin .. just this later version.
Any hel
Nevermind ... I found the problem!
(slamming head against desk)
"James Kupernik" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I'm trying to load phpMyAdmin on, and it seems to work fine, but when I
> browse a table an
I'm trying to run a mail function .. the program is running, but I'm not
getting the email. Here is the code .. any one have any ideas?
$toaddress = $friendemail;
$subject = "A message from ".$fromname.".";
$mailcontent = "Here's a special message from a friend"
."Your friend, ".
I am retrieve records from my MySQL table and I want to display the results
12 per page along with allow for a sort. I was just send a query to the
table with a limit each time, but it didn't sort all the records, so I need
to load all the results into a table to sort then display. Here is what I
I get this error when I try to start a session (I'm trying to create a
shopping cart).
Warning: Cannot send session cache limiter - headers already sent
Thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
n message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> sent the session_start(); before any output, that should do it...
>
> -----Original Message-
> From: James Kupernik [mailto:[EMAIL PROTECTED]]
> Sent: 23 May 2002 15:38
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB]
'll be a decent one on phpbuilder, or devshed, or
> webmonkey, or phpwizard
> if not, there's plenty of source code for existing shopping cart systems
> around these sites, so you can take them and rewrite it to your liking and
> design!
> the wonders of open source!
>
&
way of solving the basket solution.
>
> -Original Message-
> From: James Kupernik [mailto:[EMAIL PROTECTED]]
> Sent: 23 May 2002 16:15
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] sessions
>
>
> Thanks .. it is the wonders of open source.
>
> Are sessions required for
I'm using this:
if($save)
{
foreach ($cart as $record => $qty)
{
if($$record=="0")
unset($cart[$record]);
else
$cart[$record] = $$record;
}
$totalPrice = calculate_price($cart);
$items = calculate_items($cart);
}
and I'm getting this:
Warning: Invalid argument sup
yes because I'm using it in another foreach, but this one doesn't want to
work.
"Pierre-Alain Joye" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> On Mon, 3 Jun 2002 12:48:47 -0400
> "James Kupernik" <[EM
found my problem .. thank you for your help! You guy put me in the right
direction to solve this problem.
Thanks!!
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> On Tuesday 04 June 2002 00:52, James Kupernik wrote:
&
I have a file, it's a shopping cart. Currently is contains all the fuctions
required in the cart, including the shipping and billing form. It won't take
the values from the shipping form and use them in the functions that
calculate the tax and S & H. Why would this be? I've gotten other variables
I want to test a value that was typed into a form, but I don't want the case
to be a problem, how can I get around this??
This is what I have now:
function calculate_tax($OrderedByState,$ShipState)
{
global $totalPrice;
//tax calculation
$taxRate = "0.05";
if ($OrderedByState=="MA" && $ShipS
PLEASE IGNORE!
Thanks!
"James Kupernik" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I want to test a value that was typed into a form, but I don't want the
case
> to be a problem, how can I get around this??
>
&
28 matches
Mail list logo