i need a very small help:)

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Locked
bedrosamo
Forum Newbie
Posts: 16
Joined: Wed Sep 20, 2006 2:21 pm

i need a very small help:)

Post by bedrosamo »

i just want to print on a page something that is found in my database, i used

<?php

define("LOG_USERNAME","root");

define("LOG_PASSWORD","vertrigo");

define("DBname","sql_tables");


mysql_connect("localhost","root","vertrigo");
mysql_select_db(DBname);

$query = "SELECT UserName, CustID, Email FROM customer WHERE UserName=a";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "Name :{$row['UserName']} <br>" .
"Subject : {$row['CustID']} <br>" .
"Message : {$row['Email']} <br><br>";
}


?>


and its not working , who can help me fixing it ? (seems its not understanding the "mysql_fetch_array" and i dont know php to fix it .. i just want to pring this:s anyone can help?
[/size]
the error is : mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:/vertrigoserv/www/test.php on line 16
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

cross-post.
mod-request: delete this thread and move viewtopic.php?t=55824 to PHP-Code.
User avatar
hawleyjr
BeerMod
Posts: 2170
Joined: Tue Jan 13, 2004 4:58 pm
Location: Jax FL & Spokane WA USA

Post by hawleyjr »

Locked.
Locked