Posted by vid on 07/18/05 21:43

Thats just executing the query.. you need to use the result set, and
iterate over it...

$rs = mysql_query($query);
while($row=mysql_fetch_array($rs)) {
echo $row[0]; ...

}

stuff like that.


> Hey guys how would i show a filed from a MySQL database in a php file?
> Isnt it this?
> SELECT * FROM `user`
> But that dosent work because it comes out blank :-\
> And I already am connected to the database
> Code:
>
> mysql_connect ('localhost','myaccount','mypass')
> or die ("could not connect to server");
> mysql_select_db ('database')
> or die ("could not connect to database");
>
> $query = "SELECT *
> FROM `user`
> LIMIT 0 , 30";
> mysql_query($query);
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

• Next in forum: Re: [PHP] show a field in php file
• Prev in forum: show a field in php file
• Thread view: Re: [PHP] show a field in php file

[Reply to this message]