im about to go insane

adam_uk · 05-29-2003, 01:50 PM

PHP Code:

  <?

include("config.php"); 

$select = "SELECT * FROM `news` WHERE id = '$id'";

$result= mysql_query($select); 

while($data = mysql_fetch_array($result)){

????: NamePros.com http://www.namepros.com/programming/14816-im-about-to-go-insane.html
$id= $data["id"];

$newstitle= $data["newstitle"];

if (@!$my_notes){

$my_notes = "No Notes Where entered";

}

}

?>

 
<html>

<head>

<title>arrghh</title>

</head>

<body>

<? echo $newstile; ?><br>

????: NamePros.com http://www.namepros.com/showthread.php?t=14816
</body>

</html>

:cries:

anyone tell me whats wrong with this code?

if i go to news.php?id=1 nothing works but if its changed to this all to this

PHP Code:

  <?

include("config.php"); 

$select = "SELECT * FROM `news`";

$result= mysql_query($select); 

while($data = mysql_fetch_array($result)){

$id= $data["id"];

$newstitle= $data["newstitle"];

if (@!$my_notes){

$my_notes = "No Notes Where entered";

 
}

}

?>

 
<html>

<head>

<title>arrghh</title>

</head>

<body>

<? echo "$id <br> $newstitle" ?><br>dsfasdfasdfasdf

</body>

</html>

it selects the values but it doesnt work with the ?id=1

:cries:

deadserious · 06-01-2003, 11:33 AM

Hey I see one reason why you may not get any results on your first example, you have $newstile and I think it should be $newstitle.

I'm a novice when it comes to MySQL coding, but why do you have the back-ticks around your table names in your SELECT query? Those aren't needed are they? Just wondering.

05-29-2003, 01:50 PM	THREAD STARTER #1 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,187	im about to go insane PHP Code: <? include("config.php"); $select = "SELECT * FROM `news` WHERE id = '$id'"; $result= mysql_query($select); while($data = mysql_fetch_array($result)){ ????: NamePros.com http://www.namepros.com/programming/14816-im-about-to-go-insane.html $id= $data["id"]; $newstitle= $data["newstitle"]; if (@!$my_notes){ $my_notes = "No Notes Where entered"; } } ?> <html> <head> <title>arrghh</title> </head> <body> <? echo $newstile; ?><br> ????: NamePros.com http://www.namepros.com/showthread.php?t=14816 </body> </html> :cries: anyone tell me whats wrong with this code? if i go to news.php?id=1 nothing works but if its changed to this all to this PHP Code: <? include("config.php"); $select = "SELECT * FROM `news`"; $result= mysql_query($select); while($data = mysql_fetch_array($result)){ $id= $data["id"]; $newstitle= $data["newstitle"]; if (@!$my_notes){ $my_notes = "No Notes Where entered"; } } ?> <html> <head> <title>arrghh</title> </head> <body> <? echo "$id <br> $newstitle" ?><br>dsfasdfasdfasdf </body> </html> it selects the values but it doesnt work with the ?id=1 :cries:

06-01-2003, 11:33 AM	#2 (permalink)
deadserious Senior Member Join Date: Aug 2002 Posts: 1,255	Hey I see one reason why you may not get any results on your first example, you have $newstile and I think it should be $newstitle. I'm a novice when it comes to MySQL coding, but why do you have the back-ticks around your table names in your SELECT query? Those aren't needed are they? Just wondering.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)