MySQL database... and PHP.. HOW?

Anon

Ok you people have helped before like a beast... truely great... now for more.. LOL

If there is allready data in that feild and I do not want it to insert more in to the setup script... incase the lamer runs it more than once ... if there a way i can do that through an if else statment?? ... Like if (data exist) ignore commands...??

what should i set as the database??? im not sure im doing the dbase right?

here is the code so far....

<?php

if ($submit == \"Setup\")

{
$query = \"insert into main
(content) values
(\'$request\')\"
;

mysql_query($query) or
die (mysql_error());

?>
index.php prepared for custom MOTD ... [OK]

<?php
}
else
{
include(\"failed.php\");
}

ANY help at all well accepted .. thanks in advance

[deleted]

You can do a "update table set data='foo' where id='bar' and data!='foo'" or something like that, but be warned that this adds significant overhead.

Anon

OK... well as a resionable newbie that means nothing.. LOL...

I have been trying this for about 3 days.. LOL

Its just either a case of changing one item or only viewing one item...?? maybie viewing one is easier... ??

$main = mysql_query("select * from main") or
die (mysql_error());

while ($row = mysql_fetch_array($main))
{

echo $row["content"];

}

mysql_free_result($main);

Is my code... can that be maid to only look at the top row or does it have to say everything in the table
??

Thanks in advance

[deleted]

Well, what you said was this:

"If there is allready data in that feild and I do not want it to insert more in to the setup script... incase the lamer runs it more than once ... if there a way i can do that through an if else statment?? ... Like if (data exist) ignore commands...?? "

This is called dual-entry. Basically, inserting or updating with conditions will prevent the insert or update if those conditions are not met... so if you tell it, "Only insert X if there isn't a record that matches X" it will fail and return an error of the "lamer runs it more than once".