[[SOLVED] checkbox pagination]

you can save them on the onClick.

[IMAP check if message has attachment]

I need to find out if a message has an attachment or not without downloading all the data.  Is there an easy way?

 

I found parsing imap_fetchstructure() will give me the correct results but I heard it downloads the whole attachment and not just the message structure.

 

Any help?

[[SOLVED] How to make forms with css]

You should also get rid of the <br> tags.  Assign your <span>'s a "display: block;".  This will force them to line break.

[[SOLVED] Format A Date]

Strike mine...The haystack is supposed to be the first var of the function.

[[SOLVED] Format A Date]

$year = substr(0,4,$date);
$day = substr(4,2,$date);
$month= substr(6,2,$date);

 

I think that should work.

[Interesting Authentication Concept]

Please let me know what you think about this concept idea.  I think it would be more secure than the normal.

 

Store the username in a cookie and the password in a session.

 

Reason this would be more secure:

 

1.) If someone gets a hold of the session ID they are missing the username (so we assume its a hack and delete the session data).

2.) If someone, somehow, hacks the session data they are, again, missing the username.

3.) Someone gets a hold of a cookie (harder since it is located on clients machine) they are missing the password.

4.) If the users session ends but the username is still in the cookie ask to verify password to re-login.

 

Please let me know if this concept is a good idea.  I haven't seen this implemented anywhere else.

 

 

Thanks,

Jeff

[Formatting Data pulled from a Database?]

I prefer to secure the information on insertion but format it when I extract it.  I don't like having HTML code in my database.

 

The nl2br() function is what you want though.  Browsers don't display newlines.  Using this function you convert new lines to break tags which the browser understands.

[[SOLVED] Pre-filling Forms with Database Information]

Also, why do you do:

<?php echo "{$row['_model']}"; ?>

Its better practice to do this instead:

<?php echo $row['_model']; ?>

[[SOLVED] Pre-filling Forms with Database Information]

Grab the value of the drop down from the database the do something like:

 

<select name="_odometer">
<option value=""></option>
<option value="Actual"<?=($row['_odometer'] == "Actual") ? " selected" :NULL;?>>Actual</option>
<option value="Not Actual"<?=($row['_odometer'] == "NotActual") ? " selected" :NULL;?>>Not Actual</option>
<option value="TMU"<?=($row['_odometer'] == "TMU") ? " selected" :NULL;?>>TMU</option>
</select>

[Drop down lists]

<?

$conn = mysql_connect('localhost','username','password');

$db = mysql_select_db('database_name',$conn);

 

$query = "SELECT * FROM months";

$result = mysql_query($query);

 

while($row = mysql_fetch_assoc($result))

{

?>

<select value="<?=$row['id'];?>"><?=$row['month'];?></select>

<?

}

?>

 

With the little information I have, try that.

[validation fails and page submits on error :(]

Try in the actual function above.

 

 

<!--

function testCreditCard () {

  if (checkCreditCard (document.getElementById('payee_cardNum').value,document.getElementById('payee_cardType').value)) {

    alert ("Credit card has a valid format")

  }

  else {

    alert (ccErrors[ccErrorNo]);

    return false;

  };

}

//-->

 

Give that a go.

[validation fails and page submits on error :(]

I believe you need to return false in order to stop the submit.  i think you can also place void(0) in the onclick command, then submit the form in javascript if its validated.

[JOIN Help.]

Alright...After a few weeks I was able to figure out a lot of the query.  I have only one thing left.

 

I will re-explain when I am trying to accomplish:

 

I have 3 tables: forums, topics and users.  I need to select all the forums ordered by ID, I also need a topic count for that forum, and the most recent topic with the user information.

 

Currently I get everything including topic but it isnt the most recent.

 

This is what I have:

 

$query = "SELECT `forums`.{$select}

, COUNT(`topics`.`id`) AS `topic_count`

, `topics`.`id` AS `recent_topic_id`

, `topics`.`title` AS `recent_topic_title`

, `topics`.`date` AS `recent_topic_date`

, `users`.`id` AS `recent_topic_poster_id`

, `users`.`username` AS `recent_topic_poster`

  FROM  `forums`

  LEFT

JOIN `topics`

  ON `topics`.`fid`

  = `forums`.`id`

  LEFT

JOIN `users`

  ON `users`.`id`

  = `topics`.`poster`

  WHERE

  `forums`.`cid`='{$id}'

  GROUP BY

  `forums`.`id`

  ORDER BY

  `forums`.`id`";

[Complex MySQL HELP!]

I am trying to select from 3 different tables: categories, topics, and users.

 

I need to select all the categories whether or not there are topics in them.  If there are topics i need to get the total amount of topics as well as the most recent one defined my `date`.  I also need to get the users information who posted each topic.

 

This is what I have so far.  Currently if there are no topics in the category it will only return one category when there are actually multiple.  I also can't figure out how to select the most recent topic information.

 

SELECT `forums`.{$select}
    , COUNT(`topics`.`id`) AS `topic_count`
    , MAX(`topics`.`date`) AS `recent_topic_date`
FROM   `forums`
LEFT
JOIN `topics`
  ON `topics`.`fid`
   = `forums`.`id`
LEFT
JOIN `users`
  ON `users`.`id`
   = `topics`.`poster`
WHERE
     `forums`.`cid`='{$id}'
GROUP BY
     `topics`.`fid`

[What is question mark in PHP?]

Ha...What are you asking?

[Print code with line number on web page]

Try this:

<?PHP
$enews = file_get_contents("http://my.sony.co.th/newsletter/issue/issue-MySony061aug22/index_en.html");
$enews = htmlspecialchars($enews);
$enews_array = explode(chr(13),$enews);

$line_num = 1;

foreach($enews_array as $line){
echo $line_num . "" . $line;
$line_num++;
}
?>

[quick mysql help.]

i changed the query to this:

 

SELECT `reciever_id` FROM `invites`(LEFT JOIN `users` ON `invites`.`reciever_id`=`users`.`id`) ORDER BY `users`.`sent_invites` DESC

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(LEFT JOIN `users` ON `invites`.`reciever_id`=`users`.`id`) ORDER BY `users`.`se' at line 1

[quick mysql help.]

Ok...So i have two tables.  Invites and Users

 

In the invites table i have the user id which refers to the users table.

 

in the users table i have the users email address and their total invitations.

 

I need to order the invitations by the users total invitations and display their email.

 

Thanks in advance.

[transparency not working right. :-(]

OK...so, i cant seem to get my lists to go transparent in IE.  Works in FF just not IE.

 

http://www.inviteshare.com/site.php?id=1

 

Please let me know if you can help!  Thanks in advance.

[[SOLVED] finding a percentage]

Give this a go.

 

$allPoints = $commCount3 + $commCount1;

$percent = round(($commCount3) / $allPoints * 100);

[Question on distributing.]

If i wanted to distribute a script of mine and wanted to force licenses and such how would i go about doing that?  Should i have their site connect with mine and compare license files with the database?  Any other ideas?

 

I also plan to Zend encrypt my script as well....bad idea?

[Transparancy in IE]

OOps...i forgot the link...ha.

 

www.ekinboard.com

[Transparancy in IE]

No...i am talking about the links on the left.  In IE the transparency doesnt work, but works on the div on the right.

[[SOLVED] border-bottom issuses]

did you try to do:

 

img {border:0px;}

 

after all that CSS code?

[Transparancy in IE]

Well, i have my site looking perfect in Firefox like always but i cant figure out why it isnt working in IE.  Can someone please look at the source and let me know what i am missing.

 

Thanks in advance!

 

Jeff Broderick