[SOLVED] function + query = :( not working

[taichimasta]

hi again , i just have a question i'm trying to get my query to execute within a function. i don't know whats wrong with it

example: (looks like this)

<?php
function online(){
$change = "UPDATE person SET online='1' WHERE uid='$memeber'";
$status = @mysql_query($change) or die("\n couldn't read if you are online <br/>\n ");
?>
}
content 
<?php  online(); ?>

Doesn't send the query what am i doing wrong?

[jwilliam]

Try using something like this:

 

mysql_query($change) or die(mysql_error());

 

That may give you more information about your error.

[taichimasta]

its not a mysql_error  i've checked , its the function it self something isn't reading. what am i doing wrong? i need the function to execute the query and it just does nothing.

[teng84]

<?php

function online(){

$change = "UPDATE person SET online='1' WHERE uid='$memeber'";

$status = @mysql_query($change) or die("\n couldn't read if you are online <br/>\n ");

?>

}<------

 

the braise is out side of your php script

[taichimasta]

uh thats my fault thats not how it really looks its an example the function is inbetween the <?php  and ?>  i'm not completely brain dead lol

[jwilliam]

Are you connecting to the mysql database correctly?  Why don't you post the code that you use to do this?

[teng84]

'$memeber'<----------------- is not set you are inside the function

[taichimasta]

here is the page , what is looks like.

<?php
// i hate leaving my something not finished up

[teng84]

but where is the function there. i think u dont get my point on the last post but here

 

<?php
function online($member){
 $change = "UPDATE person SET online='1' WHERE uid='$member'";
 $status = @mysql_query($change) or die("\n couldn't read if you are online <br/>\n ");
}
online($member);
?>

[taichimasta]

oh i think i see

 

Thanks works

[teng84]

welcome