Re: Newibie: fetch Obj question - data not showing.

On Sun, Apr 5, 2009 at 10:08 PM, MEM <talofo@gmail.com> wrote: > Hello, > > 1) > Ok, with mysqli, to fetch data from a database to a select drop down list, > we would do something like this right? : > <?php > $result = $mysqli->query("SELECT id_cliente, nome_cliente FROM cliente"); > echo "<select id='listacliente' name='listacliente'>"; > > while($row = mysqli_fetch_assoc($result)) { > echo "<option > > value=".$row['id_cliente'].">".$row['nome_cliente']."</option>"; > } > > echo "</select>"; > ?> > > 2) > What I’m trying to achieve? > The same thing, but using PDO, the prepare/execute methods, and FETCH_OBJ > method to fetch data. > > 3) > Here is what I have done so far: > For simplifying I’m just trying to echo: > > $queryh=$conn->prepare('SELECT id_cliente, nome_cliente FROM cliente'); > $queryh->execute(); > > /*trys to access the method fetchObject of the PDOStatement generated by > the execute() PDO method, and save it on $row variable:*/ > $row=$queryh->fetchObject(); > > /*now I'm trying to echo the results. The 'id_cliente' and > 'nome_cliente' > are the column names of my database and, if I get it right, the > fectchObject() method should allow me to access those names as anonymous > properties. So: */ > echo "Id: ".$row->id_cliente." - Nome: > ".$row->nome_cliente."</ br>"; > > > 4) > Here is the issue that I’m getting: > I’m getting no values from the database upon echo request. > > > 5) > Question: > What is wrong with this code? :( > There is something definitely wrong with your code. But why did you forget to use the debugging functions : print_r() and var_dump() for the results? So, you'll get some idea beforehand of posting the problem here. I am looking at the code in a hurry so I cant help you much right away. Lenin www.twitter.com/nine_L