Hey Okay so i have a page that lists a bunch of clients... then another
page that would limit it to a specific chosen client.... the one that
lists all the clients is working just fine, however when i limit the
mysql query with "WHERE 1 AND last_name LIKE Harder" it gives me these
errors
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in
/home/content/s/i/t/siteadmin/html/clientmanager/searchClients.php on
line 61
Warning: mysql_free_result(): supplied argument is not a valid MySQL
result resource in
/home/content/s/i/t/siteadmin/html/clientmanager/searchClients.php on
line 70
Here is the code in case you see anything you see that neeeds to be
changed.
<?php
require_once ('#############.php');
$result = mysql_query("SELECT last_name, first_name, email, client_id,
company FROM client_info WHERE 1 AND last_name LIKE Harder ");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
printf("
<tr>
<td class='cd_data'>%s, %s</td>
<td class='cd_data'><a href='mailto:%s' class='cd_link'>%s</a></td>
<td class='cd_data'><form action='viewClientMain.php'
method='post'><input type='hidden' name='client_id' value='%s'><input
type='image' border='0' name='submitgif' src='images/view_client.gif'
onclick='submitform()'></form></td>
</tr>", $row["last_name"], $row["first_name"], $row["email"],
$row["email"], $row["client_id"]);
}
mysql_free_result($result);
?>