|
|
Posted by bill on 04/03/07 13:33
Toby A Inkster wrote:
> bill wrote:
>
>> I am stuck using 4.x because my hosting company does not have
>> PHP5 available, yet.
>> What would be the php 4 code ?
>
> I'm not really familiar with the MySQL functions in PHP, because I use a
> decent database; and it's been a while since I upgraded away from PHP 4,
> but it should be something like this:
>
> <?php
> $db = mysql_connect(/* connection settings */);
> mysql_select_db($db, 'some_database');
> mysql_query($db, "ALTER TABLE foobar ADD tempcol integer;");
> $count = 0;
> $rs = mysql_query($db, "SELECT order FROM foobar ORDER BY order;");
> while ($row = mysql_fetch_array($rs))
> {
> $count+=10;
> mysql_query($db, sprintf("UPDATE foobar SET tempcol=%d WHERE order=%d;"
> $count, $row['order']));
> }
> mysql_query($db, "UPDATE foobar SET order=tempcol;");
> mysql_query($db, "ALTER TABLE foobar DROP tempcol;");
> unset($count, $rs);
> ?>
>
Many thanks - maybe I'll be able to use a "decent database".
I have use DataFlex for many years and am transitioning to SQL
and PHP. This is the first time that I have used a remote server.
what is a decent database to use with PHP, and why ?
bill
Navigation:
[Reply to this message]
|