[SOLVED] edit article fields - how can i dedicate the id ?

[redpedia]

Hello

 

I've a problem , I've made a insert page and edit page for simple article, in the edit page , I've put a article name and edit , delete links

 

first problem is when i move the mouse above the edit link it gives this link in the IE status bar

 

http://localhost/news/edit_outputarticle.php?=0000000001

 

Why there is many of zeros ! , while i just have to records in the database !

 

Problem two , I've made an Output edit article page to edit the article fields , the problem is i can't dedicate to the code that i need article number 1 or 2 or 3 ... with where syntax .

 

here is the code

 

 

<?php

include "config.php";

$query=mysql_query("select * from article where id=");

$fetch=mysql_fetch_array($query);
?>

 

what should i put in where syntax here ?

 

thanks in advance

 

[craygo]

Not sure what the zero's are for but you might want to fix that first. There should also be a name for the value.

http://localhost/news/edit_outputarticle.php?id=0000000001

 

As far a getting the id for your query

use this

<?php
include "config.php";
$id = $_GET['id'];
$query=mysql_query("select * from article where id='$id'");

$fetch=mysql_fetch_array($query);
?>

 

Ray

[redpedia]

sorry but id didn't work also it gives me this erorr

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\news\edit_outputarticle.php on line 18

[craygo]

add some error checking

<?php
include "config.php";
$id = $_GET['id'];
$query=mysql_query("select * from article where id='$id'") or die(mysql_error());

$fetch=mysql_fetch_array($query);
?>

 

Ray

 

 

[redpedia]

thanks , i think its working

 

Erorr found is i've forget to name the link like edit.php?id=

 

thanks ray

 

[redarrow]

preg_match the id mate..

<?php
include "config.php";
$id =$_GET['id'];
if(preg_match("/[0-9]/",$id)){
$query=mysql_query("select * from article where id='$id'") or die(mysql_error());
$fetch=mysql_fetch_array($query);
}
?>