functions

[Smifffy]

no. 1: is this how you define a function

function shownews (??what goes here??) {
code to be displayed
}

no. 2: if it is what goes in where the ??what goes here?? bit

no. 3: how do i insert the function in to where it is going to be used

if iam totaly wrong pls tell me how to do it

thanks

[jeroom]

function id2user($id)
{
	$string = "SELECT user FROM users WHERE id_user = '$id'";
	$result = runquery($string);
	while($regel = mysql_fetch_array($result))
	{
		$user = $regel["user"];
	}
	return $user;
}

let's explain it with an example 😉

so here you have a function that will return a username when you input a user_id
so if you want the username of user with user_id you'll have to use:

$username = id2user("5");

[Smifffy]

what i want to do is diplay a html table with php varibles from a sql table

but i want the table to be stord on file1.php and if i need the table on file2.php i can call it and set the varibles to the data gathered from the spl query

[jeroom]

could you give a snippet from the code you allready have, caus i don't understand what you're going to do...

[Smifffy]

ok

this is what i what to place into another place

<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">
            <tr>
            <td width=\"100%\">$row->title</td>
            </tr>
            <tr>
            <td width=\"100%\">$row->content</td>
            </tr>
            <tr>
            <td width=\"100%\">Posted by <a href=\"mailto:$row->authermail\">$row->auther</a></td>
            </tr>
            </table><br>

it is called from conf.php but i want it displayed in index.php

but also i want the $row->##### bits to display the data from the mySQL query in index.php

<?
require("conf.php");
//code to diplay news items
// open database connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

// select database
mysql_select_db($db) or die ("Unable to select database!");

// generate and execute query
$query = "SELECT id, title, content, auther, authermail FROM news ORDER BY id ASC LIMIT 0,15";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

// if records present
if (mysql_num_rows($result) > 0)
{
	// iterate through resultset
	// print article titles
	while($row = mysql_fetch_object($result))
	{//this is the code that formats the news (edit the HTML only))
	//THIS IS WHERE THE CODE NEEDS TO BE DISPLAYED
	}
}
// if no records present
// display message
else
{
echo "No news Present";
}
// close database connection
mysql_close($connection);
?>

i hope that explains it