PHP & MySQL

Ronnie Dackus · **Posted:** April 17th, 2007, 1:23 pm

Hi,

Help needed with the following.

I've got the following PHP script the has as a result 3 records that match the criteria "Peter"

Code:

<?
    $sql = 'SELECT     person, address
        FROM     names 
        WHERE     person = "peter"';
    $res = mysql_query($sql,$link);
    if ($res && mysql_num_rows($res) >= 1)
    {
        while ($row = mysql_fetch_array($res))
        {
            echo 'name: '.$row['person'].' address: '.$row['address'].'<br>';
        }
    } else {
        echo 'No data found';
    }
?> 

How can I display this result in Opus ? For example:

Field
Person Address
Peter 1 x
Peter 2 y

Hope somebody can help.

Thanks in advance

Regards

Ronnie

mackavi · **Posted:** April 17th, 2007, 2:13 pm

Don't use PHP, but there are some tutorials on how to post / read data from a web database. There in the tutorial section.

Ronnie Dackus · **Posted:** April 17th, 2007, 2:34 pm

Thanks for your reply,

In the tutorial section there is only limited info.

It's like with a access database: multi row output when you have more then one result and display them in an array!

You repleyd with the comment of not to use PHP, whats your advice then??

Regards

Ronnie

mackavi · **Posted:** April 17th, 2007, 3:11 pm

Sorry Ronnie,

I meant that I don't use PHP. Having had a quick reread of the Tutorials and look at the Post Web Data action I would guess that it's not designed for reading multi records.

However, I wonder whether it would be possible to to implement this idea:

Run your SQL query but return a count (myX) of the rows

Rerun the query returning the row with the highest Primary ID

Repeat the process myX times but each time set the where clause to exclude any records greater than the last found highest primary ID.

Mackavi

Ronnie Dackus · **Posted:** April 17th, 2007, 3:18 pm

Thanks Mackavi,

Will give it a try.

Regards,

Ronnie

Digital Workshop

PHP & MySQL

Who is online