Geting array from database

[TheSky]

i wanted to get array from database but im making somthing wrong have been using google and thinking about 2 days what im doing wrong..

help would be more then welcome thanks.

 

<?
include('connectx.php');
$name = htmlspecialchars($_GET['id']);
$sqlll="SELECT * FROM data WHERE user='$name'";
$resultss=mysql_query($sqlll);
if(mysql_num_rows($resultss)>0)
{
while($row=mysql_fetch_array($sqlll))
  {
  $row=unserialize($row['items']);

  foreach($row as $item)
   {
  print $item.'</ br>';
   }
  }
}
else
{
print 'Seems there is no data';
}
?>

[TeNDoLLA]

Have you tried to var_dump, echo or debug the variables in the different stage of your script, do they have expected values or not ? And also do you have error reporting on ?

[TheSky]

yes i have

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/a9953296/public_html/index.php on line 25

 

line 25

while($row=mysql_fetch_array($sqlll))

[TeNDoLLA]

So your SQL query is failing. Echo out this $sqlll variable and see if its correct query you are building there. Also you can add this to the query, so you get some mysql error if one exists:

 

$resultss=mysql_query($sqlll) or die(mysql_error());

 

 

[Andrew777]

i believe your calling the wrong variable in this line...

 while($row=mysql_fetch_array($sqlll))

 

i think it should be.........

 while($row=mysql_fetch_array($resultss))

 

 

 

[TeNDoLLA]

Indeed, thats true. Missed that one.