mysql -> array

[Anon]

I am trying to take this query and load it into a array = $classes

this dont work.
// Load the database and options
require "./dbconf.php";
require "./db/$database.php";

$db = new dbstuff;
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);

$query = $db->query("SELECT Name FROM classes WHERE 1 ORDER BY classid ASC);
$classes = array();
while($row = mysql_fetch_array($dbresult)) {
$classes[] = "$row[Name]";
}
print ($classes[]);
?>

[khaine]

What gets displayed on screen?? is it just Array or do you get an error?? You really need to put a number in the brackets of the print. i.e.

$classes[0];

you dont need a number to load an array but you do need on to display it.

Mark.

[Anon]

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /home/barretts/public_html/test1.php on line 14

[khaine]

I take it that line 14 is the print?? try changing your script to.

<?php

// Load the database and options
require "./dbconf.php";
require "./db/$database.php";

$db = new dbstuff;
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);

$query = $db->query("SELECT Name FROM classes WHERE 1 ORDER BY classid ASC);
$classes = array();
while($row = mysql_fetch_array($dbresult)) {
$classes[] = "$row[Name]";
}

for ( $loop=0; $loop<count($classes); $loop++ )
{
print ($classes[0][name]."<BR>");
}
?>

[Anon]

line 14 is:

$classes[] = "$row[Name]";

I changed what you said but it didnt help.

[khaine]

Looks like Ive been a muppet

unless you misstyped into the browser the line
$query = $db->query("SELECT Name FROM classes WHERE 1 ORDER BY classid ASC);
is missing a close speach mark before the bracket.

Mark.

[Anon]

not sure what a muppet is 🙂

I now have:
<?
// Load the database and options
require "./dbconf.php";
require "./db/$database.php";

$db = new dbstuff;
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);

$query = $db->query("SELECT Name FROM classes WHERE 1 ORDER BY classid ASC");
$classes = array();
while($row = mysql_fetch_array($dbresult)) {
$classes[] = $row[Name];
}

for ( $loop=0; $loop<count($classes); $loop++ )
{
print ($classes[0][name]."<BR>");
}
?>

I still have this error:

Warning: Supplied argument is not a valid MySQL result resource in /home/barretts/public_html/test1.php on line 13

line 13 is this:

while($row = mysql_fetch_array($dbresult)) {

[khaine]

Now we are getting somewhere. The problem now is that $dbresult isent set> From what I understand about your code you should be using $query instead of $dbresult.
Something like.

<?
// Load the database and options
require "./dbconf.php";
require "./db/$database.php";

$db = new dbstuff;
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);

$query = $db->query("SELECT Name FROM classes WHERE 1 ORDER BY classid ASC");
unset($classes);
while($row = mysql_fetch_array($query)) {
$classes[] = $row[Name];
}

for ( $loop=0; $loop<count($classes); $loop++ )
{
print ($classes[0]."<BR>");
}
?>

Mark.

[Anon]

The print part didnt work it always printed [0] value, but that was not important since I just needed the array and was using the print to test it.

But why the reply is I wanted to say -- I love you for helping me I am one happy girl now 🙂

**HUGS**

[khaine]

Always happy to help 😉