[PHP-DB] Input to DB from form

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

[PHP-DB] permissions for writing file

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 terminated

[PHP-DB] Re: permissions for writing file

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 to use PHP and MySQL to query

[PHP-DB] outfile permission error

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

[PHP-DB] password problem

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-DB] enter key?

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.

Re: [PHP-DB] enter key?

tdPassword:/tdtdinput type=password name=magicword size=10/td /tr /table pinput type=Submit name=submit value=Get Catalog Requests/p /form ?php } //endif ? Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... On Friday 18 January 2002 00:25, James Kupernik wrote

[PHP-DB] Resource id #2 ?

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/) To

[PHP-DB] select and update together

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

[PHP-DB] limit sytax error

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

[PHP-DB] fwrite()

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);

Re: [PHP-DB] fwrite()

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 gets

[PHP-DB] phpMyAdmin

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

[PHP-DB] Re: phpMyAdmin

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 and run my mouse over the

[PHP-DB] mail()

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,

[PHP-DB] results on multiple pages

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

Re: [PHP-DB] sessions

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! -Original Message- From: James Kupernik [mailto:[EMAIL PROTECTED

[PHP-DB] foreach

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

Re: [PHP-DB] foreach

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 [EMAIL PROTECTED] wrote: and I'm getting this:

Re: [PHP-DB] foreach

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: yes because I

[PHP-DB] values across functions

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

[PHP-DB] case

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

[PHP-DB] Re: case

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?? This is what I have now: function calcu