On Fri, 11 Feb 2000 09:36, Ardani Sarjito wrote:
> hi everyone!
>
> I'm new to PHP.
>
> I don't know why I can't make this page work.
> it doesn't show my search result.
>
> Any help would be appreciated.
> This script is driving me nuts! :-)
>
> Thanks!
>
> <?php
> $connect = mysql_connect("localhost","user_name","password");
> $select_data = mysql_select_db("ardani_cd_collection");
> $query = "SELECT * FROM main where description = '$song_title'";
> $result = mysql_query($query);
>
> while($row = mysql_fetch_row($result))
> {echo "<table
> border='1'>","<TR>","<TD>",$row[1],"</TD>","<TD>",$row[2],"</TD>","<TD>
>",$ro
> w[3],"</TD>","<TD>",$row[4],"</TD>","<TD>",$row[5],"</TD>","</TR>","</t
>able> ";}
> ?>
1 Try echoing your query and pasting it into a mysql console and see what
happens (if you have console access) or at least see if the echoed query
is logical.
2 View the source and see if there is anything there
3 Use mysql_num_rows() and echo the number of rows returned.
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
I have a 33.6Kbps modem and 1.5bps fingers
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
