How do you select an "empty" date field? I've tried the few ways I can think.
SQL> select prclid from parcel
2 where expdate = '';
no rows selected
SQL> select prclid from parcel
2 where expdate = null;
no rows selected
There are are "empty" date fields in the table as seen here.
SQL> select expdate from parcel
2 where prclid ='20131570070000';
EXPDATE
Last Weeks sDate and eDate.
sDate - Start DateeDate - End DateI need to pull two dates for "Last Week" which goes from Sunday to Saturday.So today... Last week would be 10/11/09 as sDate and 10/17/09 as
Parse multirow HTML table
Hello all, I have a site I am working on. Its a sports site and I am trying to add stats to a DB. I have a table that will have varying amounts of rows depending on how many kids are on the team. I
Problem!
I have another problem, when i run this code i get this error "Parse error: syntax error, unexpected T_ELSE in /home/a1408362/public_html/admin.php on line 41". I can't see why in the code
Having problemswith multithreading and prime numbers
I have an assignment when I'm suppose to do the following:
Cant display mysql data
Hey all,I am learning php and my first goal is to create a simple CMS. At the moment I am stuck on not being able to pull page names and their id`s from my DB and combine them into a list of links
"SEO" URLs
Hey, I'm wondering how to go about creating and using these types of URLs. I'm presuming it's PHP that does this? I see them on Wordpress and Joomla and such but I've been trying to learn exactly how
uploading video files into mysql in php
hi,I have the video files which i have to upload into mysql db. along with creating thumbnails from the video.can any one help me in this which will be greatful to methank u
Two fgetcsv related questions ;D
First of im trying to get a file from a merchants server but the directory is protected, I know the user and pass obviously but im wondering how i can pass the login details through to the script
Need help with basic sql
Hi,
cyrillic string conversion question
Hello,
