[mhs12grade1992]

Is there any possible to record arrays on a database without creating table and inserting into the table? I won't have to use INSERT INTO, CREATE DATABASE, CREATE TABLE, SELECT * FROM, etc., won't I?

Like I want to save arrays in my database....
$name="MHS". How can I record it on database? I want it show $name on every page.

If I required to use those code above, then it won't work. Forget it.
INSERT INTO works, CREATE TABLE works and SELECT * FROM doesn't work.
SELECT won't show arrays at all.

Can you help?

[NeverMind]

Is there any possible to record arrays on a database without creating table and inserting into the table?

you are actually asking to use a databse with out using a database!!?
well, this is a tough one..

you said you could insert and create, why can't you SELECT?
show us the SELECT query you used, we might be able to help..

[mhs12grade1992]

I am making a guestbook using those code:
It's on view_guestbook01.php


<?php

define('DB_HOST','mysql');
define('DB_USER','idididididid');
define('DB_PASSWORD', '*********');
define('DB_NAME','guestbook');

@mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die('Unfortunately, your webmaster cannot connect to his database. '.mysql_error());
mysql_select_db(DB_NAME) or die('Cannot select dataname from the database. '.mysql_error());

$query1="SELECT user_id FROM guestbook WHERE user_id=11";
@mysql_query($query1) or die(mysql_error());
$over_ten="";
if (user_id>10) {$over_ten="ten";}



echo '<table cellpadding="0" cellspacing="0" border="0">';
echo '<tr><td valign="top">';
echo '<a href="view_guestbook01.php"><img hspace="1" vspace="1" border="0" src="button_home.jpg"></a>';
echo '</td><td valign="top">';
echo '<a href="view_guestbook01.php"><img hspace="1" vspace="1" border="0" src="button_back.jpg"></a>';
echo '</td><td valign="top">';
echo '<a href="view_guestbook02.php">';
if ($over_ten=="ten") {echo '<img hspace="1" vspace="1" border="0" src="button_next.jpg">';}
echo '</a>';
echo '</td><td valign="top">';
echo '<a href="post_guestbook.php"><img hspace="1" vspace="1" border="0" src="button_post.jpg"></a>';
echo '</td></tr>';
echo '</table>';




$query="SELECT name FROM guestbook WHERE user_id=1";
@mysql_query($query) or die(mysql_error());
if ($name!="")
{
echo 'Name: '.$_POST['name'];
echo '<br>';
}

$query="SELECT email FROM guestbook WHERE user_id=1";
@mysql_query($query) or die(mysql_error());
if ($email!="")
{
echo 'Email: <a href="mailto:'.$email.'">'.$email.'</a>';
echo '<br>';
}

$query="SELECT website FROM guestbook WHERE user_id=1";
@mysql_query($query) or die(mysql_error());
if ($website!="")
{
echo 'Website: <a href="http://'.$website.'">'.$website.'</a>';
echo '<br>';
}

$query="SELECT message FROM guestbook WHERE user_id=1";
@mysql_query($query) or die(mysql_error());
if ($message!="")
{
echo 'Message: '.$message;
}
echo '<br><br>';


@mysql_close();

?>

[NeverMind]

I'll tell you why it's not working!
you were doing all these mysql_query() but not once have fetched the results!
another thing, you didn't surround the user_id with quotes..
also, you are doing the same query over and over but just changing the field you are fetching!
use one query with all fields and then do your IFs..
try this one instead:

PHP Code:

<?php



define('DB_HOST','mysql');

define('DB_USER','idididididid');

define('DB_PASSWORD', '*********');

define('DB_NAME','guestbook');



@mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die('Unfortunately, your webmaster cannot connect to his database. '.mysql_error());

mysql_select_db(DB_NAME) or die('Cannot select dataname from the database. '.mysql_error());



$query1 = "SELECT * FROM guestbook WHERE user_id='11'";



$fetch = mysql_query($query1)or

die(mysql_error());



$row = mysql_fetch_assoc($fetch);

extract($row);



if ($user_id>10)

  $over_ten = 'ten';







echo '<table cellpadding="0" cellspacing="0" border="0">';

echo '<tr><td valign="top">';

echo '<a href="view_guestbook01.php"><img hspace="1" vspace="1" border="0" src="button_home.jpg"></a>';

echo '</td><td valign="top">';

echo '<a href="view_guestbook01.php"><img hspace="1" vspace="1" border="0" src="button_back.jpg"></a>';

echo '</td><td valign="top">';

echo '<a href="view_guestbook02.php">';



if ($over_ten == 'ten')

   echo '<img hspace="1" vspace="1" border="0" src="button_next.jpg">';



echo '</a>';

echo '</td><td valign="top">';

echo '<a href="post_guestbook.php"><img hspace="1" vspace="1" border="0" src="button_post.jpg"></a>';

echo '</td></tr>';

echo '</table>';





if ($name!='')

   echo "Name: $name<br />";



if ($email!='')

   echo 'Email: <a href="mailto:'.$email.'">'.$email.'</a><br />';



if ($website!='')

   echo 'Website: <a href="http://'.$website.'">'.$website.'</a><br />';



if ($message!='')

   echo "Message: $message<br />";



echo '<br><br>';





@mysql_close();

?>

[mhs12grade1992]

Oh thanks. That big help.

[mhs12grade1992]

Well, I read through some pages in the book about mysql_fetch_array() and mysql_num_rows() and $column[0].
I understand how SELECT works. In order to show it on guestbook, I have to use the codes......

$fetch=mysql_fetch_array($query, MYSQL_NUM);
That is the only one I can see from SELECT by using the fetch code above.