PHP Forum

For example, $query = "SELECT ...'"; $res = mysql_query($query); while($row = mysql_fetch_assoc($res)) { // Do sth } If the query return say over 1M row, is it limited by the MySQL server

I am updating a xml parser developed by a third party. The xml below is parsed by the system using the code that follows: <Company> - <section id="officers"> - <section id="secretary"> <section id="stakeholder id">15728499</section> <section id="name">FRED BLOGGS</section> </section> - <section id="director" type="current">

visitame www.lucasares.com.ar

Hi people, I'm working on a project where I have a MYSQL database containing a database table which has opening hours of a load of businesses in it. Each business has 4 TIME fields for each day in the format 00:00:00 which are named to indicate the weekday i.e MONOPEN1, MONCLOSE1, MONOPEN2, MONCLOSE2, TUEOPEN1......... My original idea...

Hello All, Thanks for any help you can give in advance. This is what I'm trying to do...I have entries going into a database. The entries can be UP to 1500 words. I want the query results from the database to be formatted for publishing in a book. For instance, every 5-8 sentences is a paragraph, at every new paragraph you indent, if one entry...

The subject line is a little too general. I would like you to tell me about scripts that can receive email messages and call other scripts depending on the content of these messages. Thanks!

When I run a small test script I get the following error. ___________________________ PHP Fatal error: Call to a member function prepare() on a non-object in /usr/local/lib/php5/pg_connect.php on line 73 <snippet_____________________> public static function db_update($sql) { $str_check = explode(" ", $sql); if($str_check == "INSERT") {...

I may have more of a design problem, but here goes. I have a class that has 3 methods. One method simply calls the other two. I wanted to make the class static, and to do this in php, you just have to make the function static. So I did that for all three functions. But now I cannot call the other two functions from the first function. ...

Hi, I'm not sure if this can be done as I've searched the web and this forum. I am using an online merchant provider and I must post certain variables to their webforms through a form on my website. The issue is that I need to gauge whether a user has any items in their basket to decide which page I redirect them too. I could

What's wrong with this script? I got error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET NEW.TSHP = 0' at line 5 CREATE TRIGGER shipumw01 BEFORE INSERT ON umw_ship_sol FOR EACH ROW BEGIN IF NEW.L0 <0 THEN

I have what may be a bug, or may be a misunderstanding on how pass by reference and class inheritance works in PHP. Since I'm relatively new to PHP, I'm hoping for a little outside help to shed some light on this! (code abbreviated for clarity) I have a parent class, DetailCollection, with a child class KeycodeTracker:

Hi, I need to get previous day from an existing date stored in a varaible $date which will not include any weekend (saturday and sunday) if it is on monday date should be for friday How can I do this?? Thanks, Jas

HI again, OK, now I have a page pictures.php and I am using following code : printf("<a href=\"pictures.php?name=%s\">",urlencode($val)); print ("<img src=\"$val\" width=100%)/></a>"); the problem is no value is stored in $name in pictures.php I don't get anything when i print $name.

Link: http://korndragon.com/resources/register.php?refer=1 Code: if(isset($_GET)){ echo "Referrer: " . $_GET; } Problem: I can't get the get variable to save to the database. I'd rather not

Tring to get help with a couple things. First thing is a good Search Engine (not like yahoo, google etc.) that searches my database somehow. A search engine that could search by 1 or more categories from within my domain. Last thing I need: After the required fields (info) are filled out and the form is submitted. The info recieved...

I am trying to develop a PHP site so that I may record my poker winnings and display the results on my blog. I haven't used php in a long time so I need to beginner type help. I know I am going to have to write a login page that communicates with a MYSQL sever so that shouldn't be an issue either. My issue is I am not sure if I should...

Hello i wanted to draw graph. On X scale i have time (in seconds). I have measure points for everyday from 8 AM to 4 PM. On Y scale i have values. For one day everything looks fine. But i wanted to see a graph for two days. The problem is that bars from the first day are narrowed on the left,

hi all, while im computing large values the variable value gets rounded off to the next higher value .How do we stop or prevent this happening.

Does sleep hand temporary control back to the Operating System or does it still demand the same resources as when the script is running? Does it work the same way as VB doEvents(). I am updating data from mssql database to MySql on an overnight scheduled task. I would like to wait a few secs to ensure the data has gone in, then run a...

Dear all, I'm sure that im doing something wrong, but I can't imagine what! My problem is the following: I create an image using imagecreatetruecolor, and, after some painting, I push the resulting image to the client in 256 colors: imagetruecolortopalette($this->m_oIMG, false, 256); header("Content-type: image/png");...

In case anyone is interested: http://lyricsfly.com/api/

Hi guys, When I try to host this PHP site I get the following errror: Warning: require_once(D:/FTP/99102574/www.test.com.pa/includes/version.php) : failed to open stream: No such file or directory in E:\www.test.com.pa\2007\includes\joomla.php on line 72 Fatal error: require_once() : Failed opening required...

Hello, I am using Fedora 7 Moonshine Linux with Apache installed. I have installed PHP5 using command: yum install php. Then I configured httpd adding module mod_php.so to httpd.conf (and other necessary operations). The problem is that when I am trying to start Apache using command: httpd -k start, I receive error of missing mod_php.so. To...

Hello, I'am new PHP student and ( programmer ? ). I want to sell my software online but how can I create to PHP read from file on server with cd-keys on my server and send them to user e-mail. And delete sent cd-key ( first line ) after sent delete? Regards, Vedran

Guys, the line below just returned "Dec 07" as the date for one month back from today. Hardly life-threatening, but any thoughts? <?php print date("M `y", mktime(0, 0, 0, date("m")-1, date("d"), date("Y")));?> AS