create array from mysql query php

Question

I have a little problem that I don t understand  I have a db that has an owner and type  and more off course   I want to get a list of all the type values that has owner equal to the current user  but I get only two result    sql    SELECT type FROM cars WHERE owner    mysql real escape string   SESSION  username       AND selling  0  ORDER BY id DESC        result   mysql query  sql  con      print r mysql fetch array  result      prints out   Array    0    gt  18  type    gt  18     and   sql    SELECT type FROM cars WHERE owner    mysql real escape string   SESSION  username       AND selling  0        prints out   Array    0    gt  16  type    gt  16      And the result should be something like 19  19  18  17  16 in an array  Thats all the types that has me as set as owner     I have got this working now    for   x   0   x  lt  mysql num rows  result    x       row   mysql fetch assoc  result      echo  row  type         Here I print out all the values correctly  but I need to create an array with all the values  I though I could use array push  but there most be a better way of doing it  I thought I would get all the type values with a simple mysql query

User · Answer

while  row   mysql fetch assoc  result       echo  row  type

User · Answer

You do need to iterate through      typeArray   array     query    select   from whatever    result   mysql query  query    if   result        while   record   mysql fetch array  results    typeArray      record  type

User · Answer

THE CORRECT WAY                          THE CORRECT WAY  while  rows     mysqli fetch assoc  result    array pop  rows       pop the last row off  which is an empty row

User · Answer

type array   array        while  row   mysql fetch assoc  result          type array      row  type

User · Answer

Very often this is done in a while loop    types   array     while   row    mysql fetch assoc  result           types      row  type        Have a look at the examples in the documentation    The mysql fetch   methods will always get the next element of the result set       Returns an array of strings that corresponds to the fetched row  or FALSE  if there are no more rows    That is why the while loops works  If there aren t any rows anymore  row will be false and the while loop exists   It only seems that mysql fetch array gets more than one row  because by default it gets the result as normal and as associative value      By using MYSQL BOTH  default   you ll get an array with both associative and number indices    Your example shows it best  you get the same value 18 and you can access it via  v 0  or  v  type

User · Answer

You could also make life easier using a wrapper  e g  with ADODb    myarray  db- gt GetCol  SELECT type FROM cars         WHERE owner   and selling 0        array   SESSION  username        A good wrapper will do all your escaping for you too  making things easier to read

User · Answer

You may want to go look at the SQL Injection article on Wikipedia   Look under the  Hexadecimal Conversion  part to find a small function to do your SQL commands and return an array with the information in it   https   en wikipedia org wiki SQL injection  I wrote the dosql   function because I got tired of having my SQL commands executing all over the place  forgetting to check for errors  and being able to log all of my commands to a log file for later viewing if need be   The routine is free for whoever wants to use it for whatever purpose   I actually have expanded on the function a bit because I wanted it to do more but this basic function is a good starting point for getting the output back from an SQL call

[php] create array from mysql query php

Examples related to php

Examples related to arrays

Examples related to mysql