if and while loop issue

[Pyro4816]

It's kinda hard to explain the problem so i will show you.
[code] $result = $connector->query("SELECT * FROM messages WHERE
two='".$_SESSION['username']."' AND rd='0'");
$result2 = $connector->query("SELECT * FROM messages WHERE two='".$_SESSION['username']."' AND rd='0'");
$row9 = $connector->fetchArray($result2);
if ($row9['ID'] != ""){
echo '<b>RECEIVED</b><br /><table><tr><td>Title</td><td>From</td><td>Status</td></tr>';
while ($row = $connector->fetchArray($result)){[/code]
basically the issue is by the time i make it to the while loop i have moved on to the second result and on, i solved it by doing the same query twice and making to different "rows" is there a way to get my desired effect in one query?


All i really need is an if statement that can determine if the query is empty or not, any ideas?

ALSO, i have ben having a ton of problems with case sensitivity in databases, is there any way to fix that, like ill request items for Pyro and it returns things for Pyro and pyro but the system i am using is like  [code]if (name == $name){
}[/code]
where name is from the database and $name is a session, like it will only display is the two match exactly like:
Pyro = Pyro but if it is Pyro = pyro it errors.

[.josh]

[url=http://www.php.net/mysql_data_seek]mysql_data_seek()[/url]

[Pyro4816]

well that solved my main problem, now i just need to fix the case sensitive thing

[wildteen88]

[quote]ALSO, i have ben having a ton of problems with case sensitivity in databases, is there any way to fix that, like ill request items for Pyro and it returns things for Pyro and pyro but the system i am using is like
[code]if (name == $name){
}[/code]

where name is from the database and $name is a session, like it will only display is the two match exactly like:
Pyro = Pyro but if it is Pyro = pyro it errors.[/quote]
Use the identical operator === instead. This will then make the comparison case sensitive.