[RESOLVED] how to put (this) query in function ??

spire_bt

The query works perfectly without a function. But when I try to put it in a function(), I get error (supplied argument is not a valid MySQL result resource) on 4 or 5 lines 🙂. Here is the query

<?php
include 'conetcion.php';

function select_sub_name(){
$Prof_Id = 8;

$query = "SELECT Sub_Name FROM subject WHERE Prof_Id = $Prof_Id";
//execute the SQL query and return records
$result=mysql_query($query);

$row = mysql_fetch_array ($result);
echo "<TABLE border=0>\n";
echo "<TR>\n";
foreach ($row as $heading=>$column) {
echo "<TD><b>";

echo "</b></TD>\n";
}
echo "</TR>\n";
mysql_data_seek ($result, 0);
while ($row = mysql_fetch_assoc ($result)) {
echo "<TR>\n";
foreach ($row as $column) {
//printing the results
echo "<TD>$column</TD>\n";
}
echo "</TR>\n";
}
echo "</TABLE>\n";

mysql_free_result($result);
}
select_sub_name();

could it be because of the table or something else, if can pls write me the right way to do this.

FijiSmithy

This is a problem with Scope.

In your main body you have included a connection.php page which we can assume is your mysql_connection functions and database selection functions.

When you put a query in the same scope the mysql commands are allowed to utilize yoru connection functions.

When you place your query inside your own funciton they are no longer in the same scope as your connection functions.

This is why it doesn't work... You can try creating a function that takes connection variables as arguments....

EXAMPLE
$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("somedb", $link);
...
...
..

function foo($MySQL_Link){
...
...

$result = mysql_query("SELECT * FROM sometable", $MySQL_Link) or die(mysql_error($MySQL_Link));
...
..

}

spire_bt

u don't understand it's not the scope, the query works perfectly when is not in function, the include connects the query with DB successfully. There is problem with the table that the data is stored in doesn't mater I'll put the data without a table
Thx anyway 😉