Digital Workshop

Hi Folks

I'm looking to select the total number of records(return a number) using the below with label 'all' linked to an opus variable in post web data. Any thoughts why it does not work. Cheers.



<?php
//connect to MySQL database
$user="xxxxxxx";
$password="xxxxx";
$database="xxxxxxx";
mysql_connect("localhost",$user,$password);
@mysql_select_db($database) or die( "Unable to select database");

$connect = mysql_connect("localhost",$user,$password);
$db = mysql_select_db($database,$connect);
$query = "SELECT * FROM weather1";
$result = mysql_query($query, $connect);

$row = mysqli_fetch_all($result);
$data = $row['all'];
echo $data
?>

For starters, you appear to be mixing mySQL and mySQLi. You should only be using the latter.

I've posted a detailed working script already, though the whole post is also worth reading.

viewtopic.php?f=4&t=5684

Some key points:

1. Build the script in steps and check that each works.
2. Make use of browser and console to check PHP responses before you get to the Opus side.
3. Keep an eye on your server logs for PHP errors.

</mack>

Just seeing your post now, Cheers Mack.