[PHP] Getting Record Counts
I am trying to get a record count from a MySql database using the following: $reccount = @mysql_query(select count(*) from mytable where user = 'testuser'); I try this from mysql and get the correct response ( 1 ). However, when I put this in an php script, $reccount returns a value of 'Resource id #5'. What am I doing wrong? Thanks. Mark Roberts, Roberts Computing Systems Webmaster Services $29.50/mo mailto:[EMAIL PROTECTED]
[PHP] RE: Record Counts
I did RTFM...I always RTFM first. That was the example in the F Book!. Mark Roberts, Roberts Computing Systems Webmaster Services $29.50/mo mailto:[EMAIL PROTECTED]
[PHP] XML Strategdy
I am about to embark on a project that requires me to access several mysql files (customer order entry), gather the information and output an XML formatted file that will be used as an input file to another accounting application. Question is this. As a seasoned developer, my natural instinct is to just write a script(s) to access all the information that I need and write the appropriate information out to the file. Is there a better way to do this? Is there some type of application that has been developed that will take a select statement as input and automatically generate XML output? Just courious...any suggestions, thoughts, comments? Thanks. Mark Roberts, Roberts Computing Systems Webmaster Services $29.50/mo mailto:[EMAIL PROTECTED]
[PHP] Headers Sent Message
Could someone help me out with this. I had this problem about a year ago with another site and I can't for the life of me remember what I had to do to fix it. I am in a oscommerce application, however I think it is really a php problem. I get this message when ever I try to update the admin portion of the site: Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/admin3/includes/application_top.php:267 ) in /home/virtual/site1/fst/var/www/html/admin3/includes/functions/general.php on line 18 Assistance would be appreciated. Thanks. Mark Roberts, Roberts Computing Systems Webmaster Services $29.50/mo mailto:[EMAIL PROTECTED]
[PHP] Importing data into MySql via PHP
I haven't tried this before, but I need to now and wanted to get a couple of pointers. I have a client that maintains a MySql database on a webserver. They want to import data into the database by uploading a Excel spreadsheet (most likely saved in a .csv format). I want to import the data directly into the data table via a php script. It appears that I should be using a LOAD DATA INFILE command or a MYSQLIMPORT command. From reading documentation, it would appear the the LOAD DATA INFILE is the way I would have to go as MYSQLIMPORT appears to be a command line only command. I could use some pointers from someone who has used this beforesuch as... 1. What is the default file format expected? (.csv?) 2. Any quarks I would need to know about? 3. Etc... Thanks. Mark Roberts, Roberts Computing Systems Webmaster Services $29.50/mo mailto:[EMAIL PROTECTED]
RE: [PHP] AOL Email client
Here is what my header look like: $headers .= MIME-Version: 1.0\r\n; $headers .= Content-type: text/plain; charset=us-ascii\r\n; $headers .= From: .$name. .$email.\r\n; $headers .= To: .$myname. .$toAddress.\r\n; $headers .= Reply-To: .$name. .$email.\r\n; $headers .= X-Priority: 1\r\n; $headers .= X-MSMail-Priority: High\r\n; $headers .= X-Mailer: Just My Server; Mark Roberts, Roberts Computing Systems eCommerce, yeah, we do that! Graphics, Scripting, Databases, shopping carts mailto:[EMAIL PROTECTED] -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 8:14 PM To: php list; [EMAIL PROTECTED] Subject: RE: [PHP] AOL Email client I am using php mail and setting all my $headers info to show From:, To:, What does your call to mail() look like? How are you formatting you headers? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] AOL Email client
It is being sent from a linux box and php 4.3.1 I do not know the aol version, I will have to check with my customer. Don't know why it is in the headers...I just picked up the code today and trying to make it work for him. Mark Roberts, Roberts Computing Systems eCommerce, yeah, we do that! Graphics, Scripting, Databases, shopping carts mailto:[EMAIL PROTECTED] -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 8:49 PM To: Mark Roberts; [EMAIL PROTECTED] Subject: RE: [PHP] AOL Email client Here is what my header look like: $headers .= MIME-Version: 1.0\r\n; $headers .= Content-type: text/plain; charset=us-ascii\r\n; $headers .= From: .$name. .$email.\r\n; $headers .= To: .$myname. .$toAddress.\r\n; $headers .= Reply-To: .$name. .$email.\r\n; $headers .= X-Priority: 1\r\n; $headers .= X-MSMail-Priority: High\r\n; $headers .= X-Mailer: Just My Server; It appears to work fine in AOL 6.0 when I send from unix box using PHP 4.2.3 and sendmail, what version of AOL are you having problems with, what server platform and PHP version are you using to send? If you are using the php mail function you must be passing To as the first parameter since it is not optional, so why are putting it in your headers as well? If I remember correctly, RFC2822 states there should only be 1 to header. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
