PHP help.

[Protege]

<?php
include( 'database.php' );

if( $mysqlQuery = mysql_query( 'SELECT * FROM `database`' ) )
{
    if( mysql_num_rows( $mysqlQuery ) <= 0 )
    {
        echo( 'No data in table' );
    }
    else
    {
        while( $mysqlFetch = mysql_fetch_array( $mysqlQuery ) )
        {
            echo( 'Blah: ' . $mysqlFetch[ 'blah' ] );
            // print_r( $mysqlFetch );
            // That will show you whats int he array etc ( field name etc )
        }
    }
}
else
{
    echo( 'Mysql Error' );
}
?>

Checks rows etc before broadcasting data

[Hypertext]

<?php
include 'database.php';

if($mysqlQuery = mysql_query('SELECT * FROM database.`table`')) {
    if(mysql_num_rows($mysqlQuery) = 0 ) {
        echo 'No data in table';
    }
    else {
        while($mysqlFetch = mysql_fetch_array($mysqlQuery)) {
            echo 'Blah: '.$mysqlFetch['blah'];
        }
    }
}
else {
    echo 'Mysql Error';
}
?>

Tidied up version of protege's.

Calon what is

. '';
//Why would you concatenate an empty string :S 

[Jahova]

Looks like it has been fixed.
Anyway, it could've just appeared in phpmyadmin. So you should've checked their first.

[Protege]

<?php
include 'database.php';

if($mysqlQuery = mysql_query('SELECT * FROM database.`table`')) {
    if(mysql_num_rows($mysqlQuery) = 0 ) {
        echo 'No data in table';
    }
    else {
        while($mysqlFetch = mysql_fetch_array($mysqlQuery)) {
            echo 'Blah: '.$mysqlFetch['blah'];
        }
    }
}
else {
    echo 'Mysql Error';
}
?>

Tidied up version of protege's.

Calon what is

. '';
//Why would you concatenate an empty string :S 

You haven't fixed **** all mate, your just trying to be clever and again failing.

<?php
include_once( 'database.php' );

if( $mysqlQuery = mysql_query( 'SELECT * FROM `database`' ) )
{
    if( mysql_num_rows( $mysqlQuery ) <= 0 )
    {
        echo( 'No data in table' );
    }
    else
    {
        while( FALSE === ( $mysqlFetch = mysql_fetch_array( $mysqlQuery ) ) )
        {
            echo( 'Blah: ' . $mysqlFetch[ 'blah' ] );
            // print_r( $mysqlFetch );
            // That will show you whats int he array etc ( field name etc )
        }
    }
}
else
{
    echo( 'Mysql Error' ); // Using brackets, isn't wrong.
}
?>

[Protege]

This is a better version:

<?php
include_once( 'database.php' );

if( $mysqlQuery = mysql_query( 'SELECT * FROM `database`' ) )
{
    if( mysql_num_rows( $mysqlQuery ) >= 1 )
    {
        while( FALSE === ( $mysqlFetch = mysql_fetch_array( $mysqlQuery ) ) )
        {
            echo( 'Blah: ' . $mysqlFetch[ 'blah' ] );
            // print_r( $mysqlFetch );
            // That will show you whats int he array etc ( field name etc )
        }
    }
    else
    {
        echo( 'No data in table' );
    }
}
else
{
    echo( 'Mysql Error' ); // Using brackets, isn't wrong.
}

?>

[Calon]

What the hell Hypertext? Have you read my code..

<?php
include "database.php"; // Hate single quotes. :P
$result = mysql_query("SELECT * FROM `database`"); // prefer result.
while($row = mysql_fetch_array($result)) { 
echo "bla: ". $row[""] ."";
}
?>

I left Lucas to put in the row, because some people are capable of doing that.

[Excellent]

Thanks guys, I've checked in phpmyadmin and it's just not submitting any data to the database. Checked my submit code and nothing has been changed since it worked.

[Invent]

Charlie, your version is a lot more messier than Protege's.

What the hell Hypertext? Have you read my code..


I left Lucas to put in the row, because some people are capable of doing that.

I think he means where you have:

echo "bla: ". $row[""] .""; 

You should just have:

echo "bla: ". $row[""]; 

[Excellent]

Charlie, your version is a lot more messier than Protege's.



I think he means where you have:

echo "bla: ". $row[""] .""; 

You should just have:

echo "bla: ". $row[""]; 

Yeah, input the id's Fixed now, had to delete the whole database and make a new one with new names, weird :S

[Calon]

Charlie, your version is a lot more messier than Protege's.



I think he means where you have:

echo "bla: ". $row[""] .""; 

You should just have:

echo "bla: ". $row[""]; 

Oh, I leave it within the quotations.