Search found 147 matches

by Skeletor
Tue Feb 01, 2005 7:04 am
Forum: PHP coding => General
Topic: Getting others opinions on what program to use...
Replies: 1
Views: 875

I found a solution using LaTeX, so no need to reply on that aspect. I am still curious what format people have letters in that do merges and such similar to what I described.

Thanks
by Skeletor
Tue Feb 01, 2005 5:54 am
Forum: PHP coding => General
Topic: Getting others opinions on what program to use...
Replies: 1
Views: 875

Getting others opinions on what program to use...

Hello. I've posted to this forum before, and I'm not exactly positive this should be asked in this section. It is more of a general programming / mail merge question then strictly php...I just use php for a part of it, so thought I'd get your comments: My situation is this: I used to do mail merges ...
by Skeletor
Thu Sep 30, 2004 4:24 am
Forum: PHP coding => General
Topic: Session security
Replies: 1
Views: 902

Session security

How secure is the data stored in sessions? I'm wondering if it is possible for the user to do something and be able to view the data you store in their session or another users session. Here is why I ask: I am playing with writing an authentication script. It works right now, but to validate someone...
by Skeletor
Fri Jun 04, 2004 3:29 am
Forum: mySQL & php coding
Topic: MS Access and MySQL difference
Replies: 3
Views: 1074

It is ok in my db, I just mistyped it on the forum post: SELECT * FROM (records LEFT JOIN address ON (records.id = address.id And address.cd = 'PM')) LEFT JOIN name ON name.id = student.id WHERE records.importdate = 'some date'; Here is a workaround. It works if you use it within Acc...
by Skeletor
Thu Jun 03, 2004 7:24 am
Forum: mySQL & php coding
Topic: MS Access and MySQL difference
Replies: 3
Views: 1074

MS Access and MySQL difference

Howdy. The setup I am currently working on using is using Microsoft Access as the front end, but having the tables stored in a MySQL database. I'm using this setup because I have vb code along with other things in the access database, but I am trying to get away from having any actual data in the ac...
by Skeletor
Wed May 26, 2004 4:55 pm
Forum: PHP coding => General
Topic: Program Stops after 10 Minutes
Replies: 5
Views: 1518

Depends if your on a personal pc or your server. In either case, you need php installed on the computer, and php in the path. then you go to command line and type something like: C:\> php scriptname.php this would tell the pc to run the script scriptname.php using php. Try that and post back if it d...
by Skeletor
Wed May 26, 2004 4:52 pm
Forum: PHP coding => General
Topic: HTML Editable Form
Replies: 2
Views: 1155

For your select, you have to test the value from the database with the value from the <option>, and if they are the same, have it append ' selected' to it. (I think it's selected, either that or just select). ie.. if your value from the database is stored in variable $hold. <td width="137" align="le...
by Skeletor
Wed May 26, 2004 4:46 pm
Forum: mySQL & php coding
Topic: how to make a result an email link??
Replies: 1
Views: 898

Try using a double quote before your email. The problem is coming from you using single quotes to enclose your email address, which php thinks you are exiting out the string.

echo('<td>' . <a href="mailto:'.$email.'">$email</a> . '</td>');
by Skeletor
Thu May 20, 2004 8:31 am
Forum: PHP coding => General
Topic: cannot get date in ascending
Replies: 11
Views: 2700

After you put the order by date ASC in your sql statement and changed the format date is stored in the database, is your date now in order? If not, try running a sort on the date array like you do the others and see if it now works with date being in a different format. I think you will want to use ...
by Skeletor
Thu May 20, 2004 4:26 am
Forum: PHP coding => General
Topic: cannot get date in ascending
Replies: 11
Views: 2700

I would put the date in YYYY-mm-dd H:i:s like ruturajv suggested. The date will then be stored in the database in that format, which will allow for easier sorting. When you display the date to the user, you can use a function like: date() to display it an another format. ie. date('m/d/Y',$row['date'...
by Skeletor
Wed May 19, 2004 4:43 pm
Forum: PHP coding => General
Topic: cannot get date in ascending
Replies: 11
Views: 2700

one quick way would be to sort your query (sql) by date asc and when it is returned, it would already be sorted. SELECT date, agency, city FROM agencies ORDER BY date ASC; I think you could also use a function like usort(), but that would require you to write a little compare function to use with us...
by Skeletor
Wed May 19, 2004 4:20 pm
Forum: mySQL & php coding
Topic: i can insert into the table but.........
Replies: 2
Views: 1128

Post subject: i can insert into the table but......... Hello. Are you wanting to know how to limit your insert based on the results for a form? If your form was either post or get, you can use the following to append to your where statement to further limit the insert: I think depending if your id f...
by Skeletor
Wed May 19, 2004 4:03 pm
Forum: mySQL & php coding
Topic: Mysql Help!!
Replies: 0
Views: 857

From what I gather, you are trying to get totals from a table, correct? You might want to look into SQL and look into the count() function. I'm not positive this is 100% correct, but your statement would look something like: SELECT COUNT(id) FROM users WHERE onlineflag='Y'; you can then do group by,...
by Skeletor
Thu May 13, 2004 9:05 am
Forum: PHP General
Topic: Read dir and display ONLY 10 newest files as a link
Replies: 3
Views: 1585

I never did it before, but you might start by looking into: scandir() filectime() Maybe use scandir() to get an array of filenames in a directory and then you could probably cycle through the array of files and use a function like filectime() to see what the date on the file is. There may be an easi...
by Skeletor
Thu May 13, 2004 7:27 am
Forum: mySQL & php coding
Topic: Problem with mysql_num_rows() & mysql_fetch_array()
Replies: 1
Views: 1088

Use this php function to get the auto increment id from the last insert statement:

mysql_insert_id();

http://us3.php.net/manual/en/function.m ... ert-id.php

Good Luck
by Skeletor
Thu May 13, 2004 4:48 am
Forum: mySQL & php coding
Topic: Problem with mysql_num_rows() & mysql_fetch_array()
Replies: 1
Views: 1088

Try replacing your insert with a SELECT statement and see if you get the same errors. From the looks of it, you are trying to num_rows and fetch_array on an INSERT query, which I'm thinking doesn't make a lot of sense. Are you trying to retrieve the record you just inserted?
by Skeletor
Fri May 07, 2004 9:21 am
Forum: Free time
Topic: Online games - City of Heroes
Replies: 6
Views: 5629

Online games - City of Heroes

Howdy. I was just wondering if anyone has played City of Heroes yet? I used to enjoy online games like Ultima Online, but that was when I had tons of free time. I had been debating playing another online game, but I'm trying to debate if the small amount of time I have to play such games would justi...
by Skeletor
Fri May 07, 2004 5:16 am
Forum: PHP General
Topic: PHP vs. ASP?????????
Replies: 8
Views: 3721

m One thing you might want to do, if you’re thinking about switching if you find that PHP is right for you is make a list of the good and the bad of ASP from your personal experience. Then see out how PHP works in those situations and then weigh the two. You may find that PHP handles the bad situati...
by Skeletor
Fri May 07, 2004 5:14 am
Forum: PHP General
Topic: PHP vs. ASP?????????
Replies: 8
Views: 3721

*** Ooops, wrote this before you posted you already had IIS/Asp *** Naaa, that’s not the only advantage. Depending who you talk to, I’m sure they will give you a different answer. Depending which a person likes best, I’m sure they will be a little biased when referring to one over the other. Your be...
by Skeletor
Fri May 07, 2004 3:44 am
Forum: PHP coding => General
Topic: Help a trainee programmer
Replies: 1
Views: 807

You just need to post your questions once. Cross posting is not needed.
by Skeletor
Fri May 07, 2004 3:40 am
Forum: PHP General
Topic: PHP vs. ASP?????????
Replies: 8
Views: 3721

PHP = free
Free = goooood
by Skeletor
Fri May 07, 2004 3:20 am
Forum: mySQL & php coding
Topic: help a trainee programmer
Replies: 1
Views: 798

http://dev.mysql.com/doc/mysql/en/INSERT.html

that site should answer a lot of your sql questions when using mysql.
by Skeletor
Thu Apr 29, 2004 6:25 am
Forum: PHP coding => General
Topic: Delete command of Mysql
Replies: 2
Views: 1051

Not sure about the join in delete. I could not get it to work. I did delete form multiple tables using the following syntax. test1 and test2 are my tables. common field was id and I deleted where id = something. DELETE test1,test2 FROM test1,test2 WHERE test1.id=test2.id And test1.id='something';
by Skeletor
Thu Apr 29, 2004 6:09 am
Forum: mySQL & php coding
Topic: Why INSERT doesn't work??
Replies: 0
Views: 838

One reason might be because your text/string values need to be enclosed in single quotes. (i think they do anyway)

VALUES ('".$_POST["name"]."', '".$_POST["email"]."', '".$_POST["impression"]."', NOW(), '".$_POST["comments"]."')";

try that out and see if it works.
by Skeletor
Thu Apr 29, 2004 6:04 am
Forum: mySQL & php coding
Topic: PHP-MySQL coding
Replies: 1
Views: 926

I am unfamiliar with this <<<EOQ syntax. Are you wanting to put everything after the $output= into the output string? $output = <<<EOQ <p> <form method="post"> $warning <input type="hidden" name="confirm" value="Confirm Delete"> <input type="submit" name="submit" value="$label"> </form> </p> EOQ;