MySQL query using an array [duplicate]

by

The second query should use $thelist not $row, and it should be outside of the while loop. The foreach loop is unnecessary when processing a single row. You can access the name in $row with a simple $row[0]. Something like this (untested):

$query1 = "SELECT name FROM clients WHERE sector="$sectorlink"";
$clientresult = mysql_query($query1, $connection) or trigger_error("SQL", E_USER_ERROR);

while($row = mysql_fetch_array($clientresult)){
    $temp[] = '"'.$row[0].'"';
}

$thelist = implode(",",$temp);
$query = "SELECT count(*) FROM studies WHERE client IN ($thelist) ORDER BY (date) desc";
$result = mysql_query($query, $connection) or trigger_error("SQL", E_USER_ERROR);

Caution: Please be aware that your code is highly vulnerable to SQL injection attacks. It’s fine for testing or internal development but if this code is going to be running the Fort Knox web site you’re going to want to fix it up quite a bit. Just an FYI. 🙂

More Related Contents:

  1. Sign in form always showing "Wrong Credentials"
  2. Prevent creating duplicate entries in PHP
  3. i have stored array in database as a string how can retrieve that array?
  4. Insert array into MySQL database with PHP
  5. Sum values of multidimensional array by key without loop
  6. I have an array of integers, how do I use each one in a mysql query (in php)? [duplicate]
  7. Save PHP array to MySQL?
  8. Notice: Array to string conversion in
  9. mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_object
  10. How get all values in a column using PHP?
  11. mysql select query within a serialized array
  12. PDO fetch one column from table into 1-dimensional array
  13. Get all mysql selected rows into an array
  14. Select from mysql table WHERE field=’$array’?
  15. How to insert json array into mysql database
  16. Why do I get “Resource id #4” when I apply print_r() to an array in PHP? [duplicate]
  17. PHP/SQL Insert Error when using Named Placeholders
  18. Create PHP array from MySQL column
  19. Save array in mysql database
  20. MySQL PHP – SELECT WHERE id = array()? [duplicate]
  21. how to write php code for the key press enter button when fill the form?
  22. PHP multidimensional array search by value
  23. How to sum all column values in multi-dimensional array?
  24. How to enable mysqlnd for php?
  25. Mysql event error using php
  26. How to separate DATE and TIME from DATETIME in MySQL?
  27. mysqli_query() expects at least 2 parameters, 1 given in? [duplicate]
  28. php – get numeric index of associative array
  29. How can I employ “if exists” for creating or dropping an index in MySQL?
  30. Alternate to array_column()

Leave a Comment