AjBaz100

** Gets specific date from MySQL row *** How is this specific date determined. Basically you could create a SQL file with the query, then put this in your cron * 5 * * * user mysql -u xx -p xx -h somehost.com database < query.sql query would look like this delete from table where fieldname >= curdate() and fieldname <= curdate()

Sounds like simpleXML is your answer. Have a look at: http://au2.php.net/simplexml

$val = $row['phone']; echo '<phone>'.substr($val, 0, 4 ).'</phone>'; echo '<phone>'.substr($val, 4, strlen($val) ).'</phone>';

you are also spot on in that the session id isn't being retained. This is the output from session_id(); 937a57f8dcd4935a29fe54f534fa6307 - request 1 5843c3c6bb8d36fb8ebbd2ddf23a0329 - request 2. I've checked the disk usage on the box, file system looks ok, no I/O errors and php.ini file settings look ok.

Yes, I've tried using firefox 3 and IE 7, and I've also tried it from a couple of different computers. I've put the exact same code on a different server and it worked fine. So this lead me to think that something had gone wrong with the php.ini file, So i copied the php.ini file from the server that worked on the the one that doesn't, restarted apache and still same problem.

I have the strangest problem with sessions. On Friday when I left work, everything was working fine, but this morning when I came in I noticed that none of my sessions are working. I'm using Ajax to call a php script and return a value that is based on a session state. I've broken down the script to a very simple session and still no luck. Here is an example. Javascript var myRequest = new ajaxObject( '/displays/eb/overlayContent.php' ); myRequest.update( params, 'GET' ); myRequest.callback = function(responseText) { if( responseText.length ) { alert( responseText ); } } PHP <?php session_start(); echo " --".$_SESSION['Test']."-- "; $_SESSION['Test'] = "Hello"; ?> On the first call, ---- is returned, which is correct, but I would have thought that on the second call to this page --Hello-- should be returned. I've checked the /var/lib/php5 directory and session files are being written, but it seams to write a file for every page request. So it's like it's creating a new session for every request. I've also skipped the ajax call and gone directly to the URL, still a new session file is being created for each page request, and the session isn't holding the value. What is strange though is that this was working fine on Friday. I've never had this kind of problem with PHP before, and I'm a little stumped on a solution.

I'm looking for a good php price comparison script, anyone know of one??

can you post a snippet of code you are using to insert the records.?? Hard to tell without seeing that.

Cool

You should probably try wrapping the code in a If strlen() function.. I don't think trim can handle a null character. $name = htmlentities($_POST['dbhost']); if( $name ) { $name = trim($name); if(strlen($name) == 0) { echo alert("Enter your host address."); } }

on the end of your connection string you could try putting the path to the socket.

you could use a for loop as in the php snippet above.

Sounds like you want to to a JOIN of some sort, that's normally the way you join rows. Search google for SQL JOIN syntax.

maybe this would work. RewriteCond %{HTTP_HOST} ^mywebsite.com [OR] RewriteCond %{HTTP_HOST} ^www.mywebsite.com RewriteCond %{REQUEST_URI} ^/([A-Za-z0-9-]+).com$ RewriteRule ^(.*)$ /mypage.php?d=%1 [L]

Yes, you could use php to write the file, although I don't know why you would want to. The second I don't really understand what your asking.