Re: asp to php

$db = mysql_connect("localhost", "make", "testit"); mysql_select_db("jobs", $db); $return = mysql_query("select * from config"); $copy = mysql_fetch_array($return); mysql_close(); I can not find Jobs.sql. What is going on? "Harpreet" <harpreet@crispincorp.com> wrote in message news:001601c150f6$0c341000$38c8a8c0@harpreet... > > I used the asp2php program to convert my page but ti doesnt seem to mak > sense to me. Like the query works fine but now i would like to print the > value on the screen. > > My code is as follows: > > $sqlstr="SELECT count(*) total from sys_parameter_tbl"; > $result=mysql_query($sqlstr); > print total; > > how can i print total?? > > help is appreciated. > regards, > Harpreet Kaur > Software Developer > Crispin Corporations Inc. > > > > -----Original Message----- > From: Christopher J. Graham [mailto:cjgraham@tachegroup.com] > Sent: Tuesday, October 09, 2001 2:39 PM > To: harpreet@crispincorp.com; php-db@lists.php.net > Subject: Re: [PHP-DB] asp to php > > > FYI: Have you seen this page? > > http://asp2php.naken.cc/ > > > on 10/09/2001 2:39 PM, Harpreet at harpreet@crispincorp.com wrote: > > > I have an asp page and am trying to convert my asp code to php. > > > > my asp code is as follows: > > <% ' Check for message alerts for Traffic Area > > sqlstr = "SELECT COUNT(*) TOTAL FROM MSG_OPERATOR_TBL WHERE PRIORITY >= > > 1000 AND READ_FLAG = 'N' AND TYPE = 'TR'" > > if Session("ObjectRecordset").State = 1 then > > Session("ObjectRecordset").Close > > Session("ObjectRecordset").Open sqlstr, Session("ObjectConnection") > > total1 = Session("ObjectRecordset")("TOTAL") > > Session("ObjectRecordset").Close > > %> > > The php code so far is: > > > > <?php > > // Check for message alerts for Traffic Area > > $StrConnectionUser=mysql_connect("ip address","$USER"); > > mysql_select_db(databasename, $StrConnectionUser); > > $sqlstr="SELECT COUNT(*) TOTAL FROM MSG_OPERATOR_TBL WHERE PRIORITY >= > 1000 > > AND READ_FLAG = 'N' AND TYPE = 'TR'"; > > $result=mysql_query($sqlstr); > > ?> > > > > How do i get the value of TOTAL from the above query. > > > > Please help, > > Regards, > > Harpreet Kaur > > Software Developer > > Crispin Corporations Inc. > > > > > > > ------------------------------------------------------------------------ > Christopher Graham > cjgraham@tachegroup.com > > PGP Fingerprint: F765 CCB5 B9CF 1285 7E3E 8CB0 0B1B 8454 9D66 D411 >