[PHP-DB] -14 Days Ago

I am trying to see whether a data in an array pulled from a MySQL DB (YEARMONTHDATE) is older than 14 days ago. I am trying to do this in PHP. My code looks like: if($array['due'] = $today - 14) { echo h5Assignment In Void:/h5brh4Assignments in the void are read-only; require('footer.php');

Re: [PHP-DB] -14 Days Ago

I needto do it in PHP, though. Cole Wendell Frohwein wrote: You can trying using the MySQL DATE_ADD() , DATE_SUB , and NOW() functions. -wendell frohwein -Original Message- From: Cole S. Ashcraft [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 11:36 AM To: [EMAIL PROTECTED

Re: [PHP-DB] -14 Days Ago

- From: Cole S. Ashcraft [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 2:36 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] -14 Days Ago I am trying to see whether a data in an array pulled from a MySQL DB (YEARMONTHDATE) is older than 14 days ago. I am trying to do this in PHP. My code

Re: [PHP-DB] Error with addition of second

It doesn't like the }; On Sat, 2004-09-18 at 19:04, Mark wrote: --- [EMAIL PROTECTED] wrote: Dear friends, With 4 radio buttons and php snippet, it gives desired output, however when I add second question in the html form and variable for the same like $variable =$_POST['q'] in

[PHP-DB] select query across multiple tables

I'm trying to pull all the records from the table class where classID is not equal to the value of classID in the table assignment. Currently, I have 'select class.classID, class.classDesc from class, assignment where assignment.classID = class.classID and assignment.assignmentID=$assidn'.

Re: [PHP-DB] select query across multiple tables

Thanks! It works Cole On Thu, 2004-08-26 at 16:45, [EMAIL PROTECTED] wrote: I'm trying to pull all the records from the table class where classID is not equal to the value of classID in the table assignment. Currently, I have 'select class.classID, class.classDesc from class,

[PHP-DB] Bogus List Messages

Are the messages with the subject line IMPORTANT: Please Verify Your Message bogus? They do not come from the ezmlm mailer at lists.php.net. They do not have the [PHP-DB] prefix. Have the owners of the list requested this? Cole -- This message has been scanned for viruses and dangerous content

[PHP-DB] Not Like

I am trying to figure out how to display something where the condition is not like im a MySQL query. The query is select * from class where classID like '_00'order by classID; How would I make the like into a not like (aka negating it. The ! does not work)? I couldn't find anything in the MySQL

Re: [PHP-DB] Mysql 5.0 Redhat

You need to compile PHP with MySQL support. There is a php-mysql.rpm package, but I'm not sure if it will work with MySQL 5. You might just have to recompile PHP (but probably not). Cole Iain Wiseman wrote: Cole S. Ashcraft wrote: They are at http://dev.mysql.com/downloads/mysql/5.0.html. Iain

Re: [PHP-DB] How to take Backup ?

Try the mysqldump command zareef ahmed wrote: Hi, If you have phpmyadmin on your system you can export all your data in sql format which can be restore again by running that sql script. make sure to check complete insert checkbox at time of export operations. Revert Back with any comment or

Re: [PHP-DB] Call to undefined function mysql_connect()

Rinku's Response: I may be missing something, but hows that related? The phpinfo() function generates a page that shows what is installed. See if the configure string has --with-mysql or something like it. There also should be a section called mysql. Take a look at

Re: [PHP-DB] Call to undefined function mysql_connect()

Create a page called phpinfo.php. In it put ?php phpinfo() ?. Search for MySQL. You probably don't have MySQL support in your installation. Cole Leandro de Oliveira wrote: Hi! I want test MySQL with PHP, for that I wrote this: html headtitleTest MySQL/title/head body ?php $con =

Re: [PHP-DB] SSL with MySQL 4.0

Is there such thing as SSL connections to MySQL? Edgar Hassler wrote: Does PHP support SSL connections to MySQL? If no, does anyone have an idea how to make an SSL conncetion to MySQL using PHP? Thanks, Edgar Hassler -- This message has been scanned for viruses and dangerous content by

Re: [PHP-DB] Re: problem....

Kim, Won't redefining the variable destroy the MySQL Resource, resulting in a resource invalid error, like he has? $pic = mysql_query($sql,$connection); //Defines variable $pic //Redefining variable, dumps old contents = //calling on an invalid MySQL Resource, because it doesn't exist

Re: [PHP-DB] problem....

Just from looking at it, it seems to be because you are redefining a variable, which destroys it, then calling for a mysql resource that has been destroyed. What is the error? I can't gaurantee that that is what is happening. Cole why doesn't this work: $pic=mysql_query('SELECT Rune,

Re: [PHP-DB] problem....

The error he is getting means that his MySQL resource (in this case the results of the query) does not exist. Try $pic1=mysql_fetch_array($pic); Also, can you give the exact text of the error (line number and all) and line numbers for the entire passage? Cole Shahmat Bin Dahlan wrote: Your SQL

Re: [PHP-DB] problem....

I need the exact error message. Copy Paste it from the browser. I also need line numbers. Cole water_foul wrote: i fixed those things and it didn't fix it :( :( :( :( :( :( :( :( :( is there a icq chatroom for php?) Shahmat Bin Dahlan [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]

Re: [PHP-DB] content managment systems

I really like Mambo Open Source- mamboserver.com or mosforge.net. They are about (hopefully ;)) going to release version 4.6 real soon. 4.5 is great too, but 4.6 promises to be way better, Cole Kim Steinhaug wrote: I love that site, really the best way to get familiar with the common systems