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
How to use php and sql to check if values match the ones in a table (for logins)
How would I code it that the script takes two variables that are passed to it (UserID and PIN), and checks the table to see if the PIN matches the one in the table. If it does it should assign the
getting a website's source code as a variable? How?
Hey guys, is there any way for me to get the source code of a website as a variable for me to work with?Ex:$url="http://www.google.com"$sourcecode=magicfunction($url);//so that i could
Batch update record with Pagination
Hoping someone can help me with this issue I'm having, im trying to batch update records from a result set with pagination. The first page results (first 10 records) will update with the batch, but
I need some help with the IF command...
I have a large number of images in one section of my website with the .jpg format. I'm adding a bunch of new images thanks to a new camera, but in using Picasa to bulk export smaller images sizes,
Random Number Generation And Probability
Hello, I am working on a function which has to insert data into a SQL table.we have to supply the function with number of entry needs to be inserted into the database and the work of the function is
DateObject and Nulls
Hi all,I have an array mapped to a value object. One of the items in the array is a PHP DateObject, and I need to format this field appropriately.When looping through the array, I pass this field to a
why isn't this PHP code working ???
it's suppose to find a name on the database. <?php $s = $_POST["lname"]; $x = trim($s); $exists = false; $selectedRow = 0; mysql_connect (localhost,testuser,testuser);
How to ... (FAQs)
... get e-mail notifications
Not sure why this script is not working?
Hi I am new to php programing and I was trying to make up a simple script like a captcha but I cannot get the validation part of it working. I think it should work but it is not. Anyone know what is
PHP - MySQL Fail
My PHP code will only execute the first part of my code... Code: <?php session_start(); ?> <html> <head> <title> Create a
