running two conditions on mysql

bakaneko

hmm... not sure what is wrong the syntax "looks" correct to me but i dunno. this is what i got:

	$j = 1;
	$field = "data";
	$field .= $j;
	$query = "select from member where login = '$us3r' and $field is null";
	$result = mysql_query($query) or die (mysql_error());

It saids there is a syntax error near the where clause.:mad:

fox_m

Originally posted by bakaneko
hmm... not sure what is wrong the syntax "looks" correct to me but i dunno. this is what i got:
	$j = 1;
	$field = "data";
	$field .= $j;
	$query = "select from member where login = '$us3r' and $field is null";
	$result = mysql_query($query) or die (mysql_error());
It saids there is a syntax error near the where clause.:mad: [/B]

First off you need to select something ....
select from .... will not work.
select bla from .... will

second make sure your spelling is correct and that $us3r is filled
third is $field an actual collum in the table where you are selecting from?

Hope this helps
Fox_m

bakaneko

ya... i am trying

$query = "select $data from member where login = '$login'";
$result = mysql_query($query) or die (mysql_error());

where $data = "data1" and $login = the user name

so i want to get the value from data1 and check if it is null or not
if it is null then i want to alter this column and insert a value if it isnt null i want to change $data to "data2" and check again till i get a null value or ""

what handle do i use to compare the value for $data???? that is the part i am stuck on now. i tried appending a $ to the front of $data but that didnt work or the intepreter took it as a literal.

any help would be great...

stolzyboy

put this

echo $query;

between your $query and $result lines

that will show you the actual query you are running

fox_m

Originally posted by bakaneko
ya... i am trying

$query = "select $data from member where login = '$login'";
$result = mysql_query($query) or die (mysql_error());

where $data = "data1" and $login = the user name

so i want to get the value from data1 and check if it is null or not
if it is null then i want to alter this column and insert a value if it isnt null i want to change $data to "data2" and check again till i get a null value or ""

what handle do i use to compare the value for $data???? that is the part i am stuck on now. i tried appending a $ to the front of $data but that didnt work or the intepreter took it as a literal.

any help would be great...

I think you need 2 querys here ....

1 to select the data and if $result is empty you have to do an insert query. Mabey you could do it with an fancy query (with select into temp table and stuff like that ) but that goes beond my mysql knowlage.

Hope this helps.

bakaneko

it returns this:

select data1 from member where login = 'bako'

which is right... i think but my question is after this if i extract this row using

$row = mysql_fetch_array($result);
extract($row);

what do i do next? i want the value from data1 but data1 is in the varibale $data... i dunno how to set up the handle to actually get the value from data1 in the table...

i tried
$temp = '$';
$temp .= $data;

that gives me $temp = "$data1";
but i cant use this to compare anything err... so the problem is how to get to variable value if that variable name is held in a variable... 😕

i think jump off a cliff now

fox_m

I think that $data is not what you want (because you used that to gather the data).
But $row because thats the result of your query and part of the next sql statement to either update or insert the data.

Hope this helps some more 🙂

bakaneko

doh...now i get it... jesus... hits head
so i would just use $row[0] and that be it =)

ill try tomorrow =P

thanks all