PHP, ODBC and Access 97

[DigitalExpl0it]

Yeah this is weak I know, but gotta learn it some time...

Im connecting to a access 97 database using odbc, now everything works just fine.

How can I limit the results?

with mysql and php I can add the limit command within the SQL statement, but the limit command is not working with access, Any ideas?

ive tryed this

$query = "SELECT * FROM News Order By NewsID Desc LIMIT 0,5";

and this...

$query = "SELECT * FROM News Order By NewsID Desc LIMIT 5";

I just want the last 5 records

[TTT]

this is not best solution ...but...

$counter = 0;

while (...)
{
$counter ++;
$blaa
if($counter == 5)
{
endwhile;
}
}

[Weedpacket]

Originally posted by TTT
this is not best solution ...but...

$counter = 0;

while (...)
{
$counter ++;
$blaa
if($counter == 5)
{
endwhile;
}
}

Y'ever hear of for loops (that wouldn't even parse)?

No, Access97 (and MS SQL Server) don't do LIMIT. Why not? Ask them up at Redmons.

I've never heard of it, let alone tried it, but someone over my shoulder here says that

"SELECT TOP 5 .... ORDER BY DESC"

could work.

And adds "and get a real dbms"

[cahva]

Originally posted by Weedpacket

I've never heard of it, let alone tried it, but someone over my shoulder here says that

"SELECT TOP 5 .... ORDER BY DESC"

could work.

And adds "and get a real dbms"

That persons right... And you are right too, he should get a real dbms 🙂

Couple of weeks ago I had to use ASP(yagh!) and Access(Bigger YAGHH!) to do quite simple thing. With PHP/MySQL it would have taken a day or so, with ASP and Access it took me a week to code!

Access is good in one thing tho, to quickly make a sketch of a database with relations...

[DigitalExpl0it]

thanx it worked 🙂

$query = "SELECT TOP 5, * FROM News Order By NewsID Desc";

[DigitalExpl0it]

ok the above code works fine, but is there a way to get the last 5 in the database? Like Select BOTTOM? or somthing. I dont need the first 5 I need the last 5 records

[fandelem]

Simply reverse the order and then select the top five..

$query = "SELECT TOP 5, * FROM News Order By NewsID ASC";

k.

[Weedpacket]

I dunno - the guy's not here now. You could always try it, I suppose...

Does it take the top five and then order them or does it order them and take the top five? If the latter then ORDER BY ASC would be more appropriate - you can always reverse the results once you get them into PHP.

If the former, then it's not very useful...

[DigitalExpl0it]

ok, sweet

$query = "SELECT TOP 5 * FROM News Order By NewsID ASC";

this works. I get the 5 last records, but only in ASC not DESC. Is there a way to reverse the oder after getting the records?

[Weedpacket]

Well yeah; read all the records into a PHP array, and then reverse the array (the function's called array_reverse(), IIRC).

So I take it there is no "BOTTOM"?

[DigitalExpl0it]

Originally posted by Weedpacket
Well yeah; read all the records into a PHP array, and then reverse the array (the function's called array_reverse(), IIRC).

So I take it there is no "BOTTOM"?

bope...pretty gay I think..hate access lol... this is for work trying to get them to switch from asp and access to php and mysql or php and oracle

[DigitalExpl0it]

ok heres my code to connect to access with php

<?

$db_connection = new COM("ADODB.Connection"); 
$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("db.mdb") ." ;DefaultDir=". realpath("../php"); 
$db_connection->open($db_connstr); 
$rs = $db_connection->execute("SELECT TOP 5 * FROM News Order By NewsID ASC"); 
  $NewsID = $rs->Fields(0);
  $title = $rs->Fields(1);
  $url = $rs->Fields(2);
  $author = $rs->Fields(3);
  $newsImage = $rs->Fields(4);
  $Article = $rs->Fields(5);
  $NewsTime = $rs->Fields(6);
  $NewsDate = $rs->Fields(7);
while (!$rs->EOF) { 

?>
            <table width="95%" border="0" cellpadding="0" cellspacing="0" align="center" class="SubList">
              <tr> 
                            <td height="15"><a href="News.asp?NewsID=<? print "$NewsID->value"; ?>"><? print "$title->value"; ?></a>&nbsp;&nbsp;&nbsp;</td>
                            <td width="70">&nbsp;</td>
              </tr>
			  </table>
             <table width="95%" border="0" cellpadding="0" cellspacing="0" align="center">
             <tr> 
                <td width="5" rowspan="2">&nbsp;</td>
                <td> <span class="Black7"></span> <span class="Black72"> Posted 
                  by&nbsp;<? echo"$author->value"; ?> on <? echo "$NewsDate->value"; ?> 
                  @<? print "$NewsTime->value"; ?></span><br>
                  <span class="BlackB92"> 
<? 
//Limit the text, 350 chrs
$doit = $Article->value;
$max=350;
$modstr=((strlen($doit)>$max)?substr($doit,0,$max) . "..." : $doit);
echo $modstr;
?>
                  </span></td>
                            <td width="70" align="center" valign="middle"><img src="Pictures/<? echo "$newsImage->value"; ?>" width="50"></td>
              </tr>
              <tr> 
                <td align="right"><span class="readmore">&nbsp;&nbsp;<a href="News.asp?NewsID=<? echo "$NewsID->value"; ?>" class="readmore">[Read 
                  More]</a>&nbsp;&nbsp;</span> </td>
                <td width="70">&nbsp;</td>
              </tr>
            </table>
            <?
$rs->MoveNext(); 
} 
$rs->Close(); 
$db_connection->Close(); 
?>

not to sure on how to use array_reverse ();

an example off php.net shows this

$result = array_reverse ($input);
echo "$results";

[DigitalExpl0it]

anyone know how to reverse the database output?

its listing the bottom five but in ASC, I need it DESC with the last five

[saidbakr]

in SQL statement you can code
Select * from tablename order by -name
if you have names
angle, John, Zepra
will be displayed as
Zepra, John, angle
i.e revers order