Posted: Sun Jun 20, 2004 9:24 pm
Just trying to find one user once I can get a simple search working all the time than I will start messing around with the flash part I want to get working.
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<?php
$result = @mysql_query("Select player_profiles.playerid, player_profiles.alias
FROM player_profiles WHERE name='$name'");
?>Code: Select all
<?php
$result = @mysql_query("Select player_profiles.playerid, player_profiles.alias
FROM player_profiles WHERE name='$name'") or die(" error: ".mysql_error());
?>what do you mean?it just kicks back the part I have eched and nothing else, like there are no matches
Code: Select all
<HTML>
<HEAD>
<TITLE>Meamebers Search</TITLE>
</HEAD>
<BODY>
<H2>Search Results</H2>
<?php
$id = $_POST["id"];
$db = mysql_connect("localhost", "name", "password");
mysql_select_db("covfiles", $db);
$query = "Select player_profiles.playerid FROM player_profiles WHERE playerid = '".$id."'";
$result = mysql_query($query);
while ($record = mysql_fetch_assoc($result)){
while (list($fieldname, $fieldvalue) = each ($record)) {
echo $fieldname.": <B>".$fieldvalue."</B><BR>";
}
echo "<BR>";
}
?>
<A HREF="seachbyname.html">Click here to go back to the search page.</A>
</BODY>
</HTML>Code: Select all
TAGS.[/color]Code: Select all
$query = mysql_query("select * from player_profiles where playerid = '$id'");
while($row = mysql_fetch_assoc($query))
{
foreach($row as $k => $v)
{
echo "$k = $v<br />\n";
}
echo "<br /><br />\n\n";
}Code: Select all
tags!Code: Select all
<HTML>
<HEAD>
<TITLE>Meamebers Search</TITLE>
</HEAD>
<BODY>
<H2>Search Results</H2>
<?php
$id = $_POSTї"id"];
$db = mysql_connect("localhost", "name", "password");
mysql_select_db("covfiles", $db);
$query = "Select player_profiles.alias, player_profiles.name, player_profiles.profile, player_profiles.age,
player_profiles.weapon, player_profiles.quote FROM player_profiles WHERE playerid = '".$id."'";
$result = mysql_query($query);
while ($record = mysql_fetch_assoc($result)){
while (list($fieldname, $fieldvalue) = each ($record)) {
echo $fieldvalue."<BR>";
}
echo "<BR>";
}
?>
<A HREF="seachbyname.html">Click here to go back to the search page.</A>
</BODY>
</HTML>