Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sophielois1

    query array

    MANY THANKS FEHERKE
  2. sophielois1

    query array

    Hi, Looking for some help with the following. $location =='somewhere'; I want to query the following array. If $location = any of the keys within the following array, then do someting, if not do something else. I know I can use if / else statemnet just not sure how to check all the contents...
  3. sophielois1

    unserialize multiple rows and pull arrays

    Hi jpadie, i'm going to go away and do some reading. thank you for your time and help Soph
  4. sophielois1

    unserialize multiple rows and pull arrays

    thanks again jpadie... I'm learning thank you. Im slightly confused...How would i queery the following to find out what values it holds [1] => Array ( [0] => A [1] => D ) something like if { ([1] => Array [0] == 'A'){ echo"It is A"; } Soph
  5. sophielois1

    unserialize multiple rows and pull arrays

    mmmm, that now returns no data. This is the problem i have been having. For some reason when they are given unique identifiers it just won't have it. This is the original problem that i was finding until i scrapped everything and asked you guys. It dont figure? This code you gave me works...
  6. sophielois1

    unserialize multiple rows and pull arrays

    Thank you jpadie. Is it possible to define each array with a unique identifier e.g arrayname1 arrayname2 arrayname3 arrayname4 arrayname5 etc so i coud then queery the content of each array. Soph?
  7. sophielois1

    unserialize multiple rows and pull arrays

    Hi, i have got it working, but at the moment only for a single row. I need to get the values for $row['knowledge_3'] $row['knowledge_4'] $row['knowledge_5'] $row['knowledge_6'] $row['knowledge_7'] $row['knowledge_8'] up to 19 <?php $sql = "SELECT * FROM HS31 WHERE userid = $userid...
  8. sophielois1

    unserialize multiple rows and pull arrays

    Hi, I hope somebody can help. Im trying to pull the serialized arrays i have stored in my table, and get the values for each array and assign them to say something like $array1 = unserialize($row['knowledge_1']); $array2 = unserialize($row['knowledge_2']); $array3 =...
  9. sophielois1

    unserialize() arrays stored in mysql, help!!!

    Hi, I've taken out all unessacery code and am left with this: <? session_start(); header("Cache-control: private"); include '../../admin/inc/xz73rlnf5ef.php'; include '../../admin/inc/s_check.inc'; if ($_SESSION['authorized']!== $sec_check){// security header ("Location...
  10. sophielois1

    checking multiple sets of checkboxes

    hi niteowl, thanks for the post. i need to keep the name="knowledge1[] as im storing them as arrays. I cant get your code to work at the mo. This is waht i have <script type="text/javascript"> function chkboxes() { for (var x=1; x=2; x++) { var chkbox =...
  11. sophielois1

    checking multiple sets of checkboxes

    Hi, Im trying to find out how to check a number of different sets of check boxes: <form action="submit.php" method="post" onsubmit="return check(this)"> <input type="checkbox" name="knowledge1[]" value="A" /> <input type="checkbox" name="knowledge1[]" value="B" /> <input type="checkbox"...
  12. sophielois1

    unserialize() arrays stored in mysql, help!!!

    sorry about that sleipnir, i should read the post more carefully. There is a large chunk of code before 338 so ive included the lot <?php $result = mysql_query("SELECT * FROM HS21 WHERE userid = '$userid'"); while($row = mysql_fetch_object($result)) { echo "<table class='main'...
  13. sophielois1

    unserialize() arrays stored in mysql, help!!!

    <? $result = mysql_query("SELECT * FROM HS21 WHERE userid = '$userid'"); while($row = mysql_fetch_array($result)) { LINE 338 ------->>>>>>>>> $pc=unserialize($pc1['knowledge_1']); $pc=unserialize($pc2['knowledge_2']); foreach($pc as $result) {...
  14. sophielois1

    unserialize() arrays stored in mysql, help!!!

    wow, ok, ive managed to get hold of the origanal files and i stiil cant get it to work. form.php <form action="insert.php" method="post"> <input type="checkbox" name="knowledge1[]" value="A" /> <input type="checkbox" name="knowledge1[]" value="B" /> <input type="checkbox" name="knowledge1[]"...
  15. sophielois1

    unserialize() arrays stored in mysql, help!!!

    Hi sleipnir214, thanks for the reply; the $_POST['knowledge1'] came from a form <input type="checkbox" name="knowledge1[]" value="A" /> <input type="checkbox" name="knowledge1[]" value="B" /> <input type="checkbox" name="knowledge1[]" value="C" /> <input type="checkbox"...
  16. sophielois1

    unserialize() arrays stored in mysql, help!!!

    Hi been handed a database that has a number of arrays which have been stored using the serialize() function. As i have never stored arrays in databases before, i am having a bit of problem pulling the info and displaying it. Would somebody be kind enough to help me. This is what i have...

Part and Inventory Search

Back
Top