mysql queries

[run2web]

Can a query only be run one time or can you have different queries within the same page if they do different things?

[run2web]

The reason I ask is I have 2 queries with this being my 2nd one:

$sql_notary= "SELECT ID, FirstName, LastName FROM $notary WHERE ID = '$NotaryID' ";
$this_notary = @($sql_notary,$connection) or die("Couldn't execute query.");
while ($this_notary = mysql_fetch_array($notary)) {
$ID = $this_notary['ID'];
$LastName = $this_notary['LastName'];
$FirstName = $this_notary['FirstName'];

and it states this when I load the page:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource with the error occuring on the line with the "WHILE" statement.

[Anon]

Something is wrong here. You call mysql_query and assign the resource to $this_notary. Then you call mysql_fetch_array by passing it $notary (an uninitialized variable?) and assign the row to $this_notary (which clobbers the resource you set in the previous line). I suspect you intended to pass $this_notary into the fetch and assign the result to $notary. If so, you should also change the assignments inside the while loop to use $notary instead of $this_notary.

$this_notary = @($sql_notary,$connection) or die("Couldn't execute query.");
while ($this_notary = mysql_fetch_array($notary)) {

[run2web]

Sorry, my bad. $notary refers to the table name. $notary= 'NotaryPublic';

which I called at the beginning of the page.