All the info you want should be in $result after the query. But to get it
out of $result you need to access one row at a time with
mysql_fetch_array($result), which returns a numerically keyed array (if I
remember correctly), or mysql_fetch_assoc($result), which returns a string
keyed array or hash. So, like this (more or less)...
if ($TechContact == ""){
$TechContact = '%';
}
$result = mysql_query ("SELECT * FROM enet
WHERE TechContact LIKE '$TechContact%'");
// this part added...
while($row = mysql_fetch_assoc($result)){
print $row["TechContact"];
print $row["SomeOtherColumnName"];
print $row["YetAnotherColumnName"];
print "<br>\n";
}
On 2001.09.06 19:41:55 -0500 Devon wrote:
> Below is an example of my code which searches a table and prints the
> result,
> the problem is that it only displays the TechContact where I want it to
> display all the fields that associated with it in that row off the colum
> eg.
> Mobile, AdminContact etc etc Any suggestions?
>
> if ($TechContact == "")
> {$TechContact = '%';}
> $result = mysql_query ("SELECT * FROM enet
> WHERE TechContact LIKE '$TechContact%'");
> print $row["TechContact"];
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]