insert // url string // how do i do it?

[cyber_d]

Hi there,

can anyone help i seem to be a little stuck.

i wish to use a url eg) http://url/insert.php?insert_text=xxxxxxx
to update an entry in my MySQL dbase.

ie) whatever the value in the string // insert_text=xxxxxx will be entered into my table

any suggestions?

thnks a lot
Dave (za)
"former asp bunny"

[rincewind456]

<?php
$insert_text = $_GET['insert_text'];
mysql_query('INSERT into your_table VALUES('.$insert_text.')');
?>

Should work.

[thorpe]

theres an error in the query. should be...

mysql_query("INSERT INTO your_table VALUES ('$insert_text')");

[cyber_d]

<?php require_once('../../Connections/conn_cyberd.php'); ?>
<?php
mysql_select_db($database_conn_cyberd, $conn_cyberd);
$query_rsNWS_Updt = "SELECT * FROM network_status";
$rsNWS_Updt = mysql_query($query_rsNWS_Updt, $conn_cyberd) or die(mysql_error());
$row_rsNWS_Updt = mysql_fetch_assoc($rsNWS_Updt);
$totalRows_rsNWS_Updt = mysql_num_rows($rsNWS_Updt);

$nws_scroll = $_GET['nws_scroll'];
mysql_query('INSERT into network_status VALUES ('$nws_scroll')");

mysql_free_result($rsNWS_Updt);
?>

[rincewind456]

No it is not wrong, just a different way of doing it.

[cyber_d]

do you have an easier way? ... i would like to update a specific id

eg WHERE nws_id = 2

thanks

[cyber_d]

on my new website i want the network status to be changed using a url string that will be sent from my ISP's server if it is changed there.

http://www.cyberdynamix.net/php/index.php?page=58&pg_id=1