Page 1 of 1

Reading

Posted: Wed Dec 17, 2003 8:13 pm
by Straterra
I have a table with multiple rows..I would like to read stuff from just 1 row..The code I have is ...

Code: Select all

<?php
$getinfo = sqlite_query($db, "select * from logintable");
$array = sqlite_fetch_array($getinfo);
echo $array['username'];
echo $array['password'];
?>
But this will only read from the ONLY row..right? So..how would I only read from the row that say.. socomname = 'straterra' ?

Posted: Wed Dec 17, 2003 8:37 pm
by Weirdan

Code: Select all

select * from logintable where socomname='straterra'