Hi guys,
I'm having a bit of an issue getting the desired results from a round of mysql_fetch_array.
I have a parameter table with these fields:
id
name
param
- and I'm trying to get two specific values from "param" by focusing on the names of the parameters in "name"
$adminquery = mysql_query("SELECT param FROM parameter WHERE name='siteuser' OR name='siteuserpasswd'");
if (!$adminquery) {
die('<h3 class="warning">fetching admin credentials failed.</3> '. mysql_error());
}
while ($row = mysql_fetch_array($adminquery)) {
echo $row['siteuser'];
echo $row['siteuserpasswd'];
}
The above gives me four instances of notice: undefined index: two for each field.
What do I need to do to make $row['siteuser'] and $row['siteuserpasswd']
Assume their proper values?