[RESOLVED] empty database

[tommyrulez]

I have a script that checks to see if user exists, but since the database is empty right now I also have that checked. Problem, I'm having is the form will not load if condition is true and nothing shows up in an echo.
<?php
include 'db.php';
mysql_select_db($dbname) or die(mysql_error());
$result = mysql_query("SELECT date, user FROM users");
$i=0;
while ($row = mysql_fetch_array( $result )){
$row = $row;
echo $row;
$i++;
}
?>

This also does not work.

$row[$i] = $row;
echo "This is row: " .$row[$i];
$i++;

if I use
$row($i) = $row;
echo "This is row: " .$row($i);

I get: Can't use function return value in write context

[halojoy]

I have written some comments in the code.
Think you will understand it and learn this tricky part

<?php
include 'db.php';
mysql_select_db($dbname) or die(mysql_error());

$result = mysql_query("SELECT date, user FROM users");

//see if any row was found
if( mysql_num_rows($result) > 0 ){

$allrows = array();// to put all result rows in
//$i=0;  // no counter is really needed will work without
while (row = mysql_fetch_array( $result )){
	$allrows[] = $row; //add this row into $allrows
	echo $row['date'].' '.$row['user'].'<br />';
}

}else{   //result num_rows == 0
	echo 'no rows found';
}

// see what was saved into $allrows
echo '<pre>';
print_r($allrows);

?> 

[tommyrulez]

Thanks, for the quick response, Halo. I love this forum.

This would actually go in results page
echo $row['user'].' You already filled this form on '. $row['date']. '<br />';

This will be the code:

<?php
include 'db.php';
mysql_select_db($dbname) or die(mysql_error());
$result = mysql_query("SELECT date, user FROM users");

//see if any row was found
if( mysql_num_rows($result) > 0 ) {

$allrows = array();// to put all result rows in
//$i=0;  // no counter is really needed will work without
while (row = mysql_fetch_array( $result )){
    $allrows[] = $row; //add this row into $allrows

if $pUser //received when user logs in =$row['user'] {
mysql_close($con);
include 'results.php';
}

else {
include 'Pollform.php';
mysql_close($con);
}
}

[tommyrulez]

while ($row = mysql_fetch_array( $result )){ 🙂

[tommyrulez]

After playing with it. Here are the final results.

<?php
include 'db.php';
mysql_select_db($dbname) or die(mysql_error());
$result = mysql_query("SELECT date, user FROM users");

//see if any row was found
if( mysql_num_rows($result) > 0 ) {

$allrows = array();// to put all result rows in
//$i=0; // no counter is really needed will work without
while($row = mysql_fetch_array( $result )){
$allrows[] = $row; //add this row into $allrows
}
if ($pUser = $row['user']) {
mysql_close($con);
include 'results.php';
}
}
else {
include 'Pollform.php';
mysql_close($con);

}

?>

[tommyrulez]

Thanks once again, Halo. Now to work on the results page.

[halojoy]

Good.
You even corrected me. My little syntax slip: $row / row
I am sure your pages will work fine at your site.
And when you get some issue, you know where to ask.

I have been working a lot with PHP MySQL lately.
So I have lots of functions sharp & fresh in my memory.
Being off for 1 year from programming, you will forget lot of syntax.
And need to look things up again.

Thats how it is for all of us.
Cheers 🙂