fetch array

[elementaluk]

hi,

ok i'm using mysql_fetch_array to get 3 NOT NULL fields (all VARCHAR) in a database and 8 NULL (all varchar) fields from a mySQL database BUT it only returns 3 NULL fields.

I'm sure its not a code problem cause why would it get 3 fields, and then i thought that maybe it was the way i'm displaying them, and no problems there.

u proberly wanna know what kind of script it is right? its a addon for turbo seek its in cgi, the script is in php, which doesn't matter cause i'm only pullin stuff from the database.

Thanks
Vince

[Anon]

Do all the fields have unique names? You haven't posted enough information, how about some code (at least the query).

[elementaluk]

the code is:
$db = mysql_connect($host, $user, $password);
mysql_select_db("$database",$db);

$sql="SELECT * FROM searchidx WHERE id=$id";
$result=mysql_query($sql,$db);

$num = mysql_num_rows($result);
$cur = 1;

while ($num >= $cur) {

$row = mysql_fetch_array($result);

$title = $row["inktitle"];

...but i cant see any problems and the fields in the mysql are nothing more than VARCHAR apart from the id ofcourse

[elementaluk]

just noticed that 3 mySQL fields are INDEX