timjpriebe — Tue, 21 Dec 2004 13:16:08 +0000

Good point, CptAwesome. You might have to do this:

SELECT field1, field2, field3 FROM tablename WHERE datefield LIKE 'XX-XX-XXXX %'

airoid3000 — Tue, 21 Dec 2004 03:39:50 +0000

Thanks, sorry that was a stupid question.

CptAwesome — Mon, 20 Dec 2004 18:42:15 +0000

if the date field is mixed date/time that won't work, but you could query and pull all results (depending on the size, this could be a bad idea) and then use an ereg function, or some other comparison method to analyze the info.

timjpriebe — Mon, 20 Dec 2004 12:46:38 +0000

SELECT field1, field2, field3 FROM tablename WHERE datefield = 'XX-XX-XXXX'

Then, of course, you'll want to use a while loop to go through the results for that date, unless your DB is set up so that there's only one entry per date.

airoid3000 — Sun, 19 Dec 2004 00:47:23 +0000

Thanks for the help, I was able to get it in the database.

Here is my new problem. I am trying to load the form with all the values for that certain date. (I have a date field in the database table). How can I tell the page that I want it to load the values only for a selected date?

Busy — Sat, 18 Dec 2004 21:43:58 +0000

CptAwesome wrote: echoing $sql will just get you the query obviously.

Isn't a bad idea to go right back to basics, finding out if the variables actually have values can be the answer. Easier than echoing all variables, especially if you have more than a couple.

Again the mysql_query() is helpful for fault finding. there are other ways of doing it, sure, but the end of the day you need to find the problem whether it be a missing quote, comma, brace, value or whatever.

timjpriebe — Sat, 18 Dec 2004 14:31:15 +0000

I have to agree with what Busy said. The WHERE clause does not work with INSERT. It sounds like you're wanting to use UPDATE, not INSERT.

CptAwesome — Sat, 18 Dec 2004 10:10:09 +0000

echoing $sql will just get you the query obviously.

and you don't need to do a $something = for the mysql_query($sql); but you can then do:

if($something)
{
echo "YAY IT WORKED!";
}
else
{
echo "bunk, still didn't work";
}

Busy — Sat, 18 Dec 2004 09:47:00 +0000

You using the right one, INSERT vs UPDATE ?

do you get a value if you echo $sql ?

and do you have a $something = mysql_query($sql); ?

CptAwesome — Sat, 18 Dec 2004 09:40:50 +0000

$sql = "INSERT INTO `table_name` (`column1`,`column2`) VALUES ('$data1','$data2');

for a new entry, and you can't 'insert into' a row that exists in that case it's

$sql = "UPDATE `table_name` SET `column_name` = 'value' WHERE `id` = '$id';

just remember, fields, and tables need `` (below the tilde~) around them, and strings need ' ' around them.

I suggest getting MySQLadmin, and just look at some of the queries it runs when updating information.