Boo-urns

Thanks guys! I was hoping there was a faster way around it, but sometimes shortcuts are dangerous! Thanks for the guidance!

So if the user has 2 goals.... I need 2 rows for that user?

Basically what i have is one table of goals (id, goalName, etc...) In the other table for the users I have (id, name, goal_ids) Where there can be multiple goal ids in the column. First question is that a good way to set it up. Second question is I have a form that you can search goals on, so I'm looking for a user with goal ids of 1 and 2. I've tried IN and it works great for searching for 1 id, but when i throw in another it WILL pull it, but it also pulls rows with just 1 of the ids as well. Any suggestions?! Thanks, Corey

From what I understand. You have the ID value as your dropdown value, and you want to pull the data for the (number, day, status) which might not always correlate to the ID? Best bet would be to look into javascript.

I'll give it a shot if i have a chance when i get home this evening.

Thanks for the feedback, What would you suggest as a different color there? Perhaps a silver?

I'm not solid on multidimensional arrays just to throw that out there. <?php $AuthorID[$x][0]= "$row->created_by"; Shouldn't that be the id, or what is created_by? Since you are matching it up here: <?php if ($AuthorID[$x][0] == "$row->id") Last thing I noticed is why is there an $x--; at the end? So if it runs the else statement $x will be the same number as before. I hope that helps you out!

I am finally pretty pleased with my design. I will probably add more ajax to the site at a later time. Mainly for the portfolio section. http://www.burns-animations.com/ What do you guys think?

Alrighty, I didn't rely on it anyway. Thanks for the info!

Thanks a lot Crayon Violent it worked perfectly!

Yea, I think that makes sense. Try something like this: Javascript: // SUBMITTING UPDATE $('#submitConfirm').click(function() { // if you need values from the form var val1 = $('#field1').val(); $.ajax({ type: "POST", url: "/includes/path-to-script", data: val1+"&nextVar="+'sending a string', cache: false, dataType: "json", success: function(data){ // all of the variables are from the json encode alert(data.response); } }); }); // END OF SUBMIT <?php // php script to return the json encoded variables. $val1 = $_POST['val1']; $str = $_POST['nextVar']; // do something $response = 'this is an fake example of your text.'; // return values $arr = array ('response'=>$response, 'error'=>$error, 'errorMsg'=>$errorMsg); // errors for displaying if there is an error echo json_encode($arr);

hmm interesting. So is it best to have magic quotes off? It does look like it is on.

Don't those regexes not replace as well?

Tizag has some good php tutorials http://www.tizag.com/phpT/index.php

I have a phone number setup like this (381) 323-4567 When I set it up to use on a page with a javascript function I need it setup like so 381 323 4567 I have no idea how to setup that regex. I've looked at some tutorials but still have had no luck. Thanks in advance for the help!