I'm getting an error with eth fecthj_array statement... anyhelp... this is a search database script that recieves data from a form
$host = "localhost";
$user = "****";
$password = "****";
$dbname = "****";
$tablename = "****";
if ($set != "") { $statement .= "number like %$set%,"; }
if ($number != "") { $statement .= "number like %$number%,"; }
if ($attack != "") { $statement .= "attack $attackcomp $attack,"; }
if ($defense != "") { $statement .= "defense $defensecomp $defense,"; }
if ($icon != "") { $statement .= "icon = \"$icon\","; }
if ($attribute != "") { $statement .= "attribute = $attribute,"; }
if ($level != "") { $statement .= "level = $level,"; }
if ($rarity != "") { $statement .= "rarity like %$rarity%,"; }
$link = mysql_connect($host, $user, $password);
$query = "select * from $tablename where $statement order by id";
echo $query;
$result = mysql_db_query($dbname, $query, $link);
// formatting below
$count = 1;
$column = 1;
print("<table width=\"400\">");
//loop statement
while($row = mysql_fetch_array($result))
{
print("");
PHP MYSQL SEARCH ENGINE
Moderator: General Moderators
Another question
OKay this is what i have now.. and it works.. i just don't know HOW
$link = mysql_connect($host, $user, $password);
$query = "select cotd.number, cotd.id, cards.number, cards.name, cards.description, cards.type, cards.rarity from cotd, cards where cotd.number = cards.number order by cotd.id ASC limit 0, 1";
$result = mysql_db_query($dbname, $query, $link);
while($row = mysql_fetch_array($result))
{
if(!$row[rarity]) { $row[rarity] = "Common"; }
// this is the column 1
print('
<table width="160" border="0" cellspacing="0" cellpadding="0" align="center">
<tr valign="top" align="left">
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Name:</font></td>
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
'."$row[name]".'
</font></td>
</tr>
<tr valign="top" align="left">
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Number:</font></td>
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
'."$row[number]".'
</font></td>
</tr>
<tr valign="top" align="left">
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Type:</font></td>
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
'."$row[type]".'
</font></td>
</tr>
<tr valign="top" align="left">
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Rarity:</font></td>
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
'."$row[rarity]".'
</font></td>
</tr>
<tr valign="top" align="left">
<td height="20"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Description:
</font></td>
<td height="20"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
'."$row[description]".'
</font></td>
</tr>
<tr valign="top" align="left">
<td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><a href="cotd.phtml">Worth
your time?</a></font></td>
</tr>
</table>
');
}
HOW THE HECK DOES THE SCRIPT KNOW WHAT DATABASE FIELD IT"S GOING TO ECHO IF 2 TABLES WITH THE SAME FIELD NAMES ARE QUERIED?
$link = mysql_connect($host, $user, $password);
$query = "select cotd.number, cotd.id, cards.number, cards.name, cards.description, cards.type, cards.rarity from cotd, cards where cotd.number = cards.number order by cotd.id ASC limit 0, 1";
$result = mysql_db_query($dbname, $query, $link);
while($row = mysql_fetch_array($result))
{
if(!$row[rarity]) { $row[rarity] = "Common"; }
// this is the column 1
print('
<table width="160" border="0" cellspacing="0" cellpadding="0" align="center">
<tr valign="top" align="left">
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Name:</font></td>
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
'."$row[name]".'
</font></td>
</tr>
<tr valign="top" align="left">
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Number:</font></td>
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
'."$row[number]".'
</font></td>
</tr>
<tr valign="top" align="left">
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Type:</font></td>
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
'."$row[type]".'
</font></td>
</tr>
<tr valign="top" align="left">
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Rarity:</font></td>
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
'."$row[rarity]".'
</font></td>
</tr>
<tr valign="top" align="left">
<td height="20"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Description:
</font></td>
<td height="20"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
'."$row[description]".'
</font></td>
</tr>
<tr valign="top" align="left">
<td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><a href="cotd.phtml">Worth
your time?</a></font></td>
</tr>
</table>
');
}
HOW THE HECK DOES THE SCRIPT KNOW WHAT DATABASE FIELD IT"S GOING TO ECHO IF 2 TABLES WITH THE SAME FIELD NAMES ARE QUERIED?
If you are quering for columns withe the same name in two tables you get an ambigous error unless you alias the column name...
SELECT familyname, husband.name AS hubby, wife.name AS wife
FROM family
LEFT JOIN husband ON husband.family_id = family.family_id
LEFT JOIN wife ON wife.family_id = family.family_id
WHERE familyname = 'Gates'
SELECT familyname, husband.name AS hubby, wife.name AS wife
FROM family
LEFT JOIN husband ON husband.family_id = family.family_id
LEFT JOIN wife ON wife.family_id = family.family_id
WHERE familyname = 'Gates'
still a little lost
I have this also
$link = mysql_connect($host, $user, $password);
$query = "select cotd.number, cotd.id, cards.number, cards.name from cotd, cards where cotd.number = cards.number order by cotd.id DESC";
$result = mysql_db_query($dbname, $query, $link);
print('<table width="160" border="0" cellspacing="0" cellpadding="0" align="center">');
while($row = mysql_fetch_array($result))
{
print('
<tr valign="top" align="left">
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
'."$row[name]".'
</font></td>
</tr>
<tr valign="top" align="left">
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
'."$row[number]".'
</font></td>
</tr>
');
}
print('</table>');
problem is I only want to see each instance of a cards.name with it's corresponding cards.number once in the table i'm producing (right now thier are multiple instances of cotd.number) ...
Anyclue?
All help is appreciated!!!
$link = mysql_connect($host, $user, $password);
$query = "select cotd.number, cotd.id, cards.number, cards.name from cotd, cards where cotd.number = cards.number order by cotd.id DESC";
$result = mysql_db_query($dbname, $query, $link);
print('<table width="160" border="0" cellspacing="0" cellpadding="0" align="center">');
while($row = mysql_fetch_array($result))
{
print('
<tr valign="top" align="left">
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
'."$row[name]".'
</font></td>
</tr>
<tr valign="top" align="left">
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
'."$row[number]".'
</font></td>
</tr>
');
}
print('</table>');
problem is I only want to see each instance of a cards.name with it's corresponding cards.number once in the table i'm producing (right now thier are multiple instances of cotd.number) ...
Anyclue?
All help is appreciated!!!