trouble selecting data and echoing

[toolman]

Hi there,

 

I am trying to select from my database and echo the result.

 

This is what I have:

 

$result = mysql_query("select * from website_settings");
$row = mysql_fetch_array($result);

 

and I am echoing using:

 

<input name="website_name" value="<?php echo $row['website_name']; ?>" type="text" class="input" />

 

But it is not echoing.

 

does anyone know what I have wrong?

[Alex]

I don't see anything immediately wrong with that. Are you sure website_name is the name of the column? You might want to put in print_r($row) for debugging.

[toolman]

Thanks, I tried the print_r($row)

 

and it produced this:

 

Array ( [0] => [website_name] => )

 

[JAY6390]

The first record has no website_name value according to your output

[toolman]

I see. I noticed my top record is blank.

 

What I am trying to do is to only allow one record which can be updated. However, when I insert another record, it automatically adds a blank record to the top.

 

Any ideas whats going on?

Thank for your help.

[JAY6390]

Without seeing your code no...I can't read minds

[Alex]

You shouldn't be inserting more records then, just updating the one.

[toolman]

I see. i am getting into a bit of a pickle.

 

This is now what I have, but it doesn't seem to be updating.

 

$website_name = $_POST['website_name'];
$sql = "INSERT INTO website_settings VALUES('$website_name')";
mysql_query($sql);


$update = mysql_query("UPDATE website_settings SET website_name = $website_name");

$result = mysql_query("select * from website_settings");
$row = mysql_fetch_array($result);

[Alex]

You should have a primary incrementing key field so that you can identify certain records. Then use a WHERE clause to make sure you're only updating one record (and remove that insert query..). Another problem I see if that you don't have quotes around $website_name in your UPDATE query.