sql question

[richard181]

$qury=select some thing from something where name ='john';
arra=fetch_array($qury);

echo arra['name'];

so if i got this code and then down on my page i just do this

$qury=select some thing from something where name ='juan';
arra=fetch_array($qury);

echo arra['name'];

will that mess with my cod in any way? becuase it does print the other name but since the variable and the query is the same would that bring any problem?

[Houdini]

This is wrong

$qury=select some thing from something where name ='john';

It needs to be something like

$qury="select some thing from something where name ='john'";

and

arra=fetch_array($qury);

echo arra['name'];

needs to be

$arra=mysql_fetch_array($qury);

echo $arra['name'];

[etully]

Houdini is right, the syntax needs to be correct. But regarding the second part of your question, both queries (john and juan) will work. It won't mess up your code. You can do a select, use the data, and then do another select without a problem as long as you remember that when you do the second select statement (for juan), the data from the first select statement (for john) is gone from $arra.