I need help plz

[SweetAmona]

Hi everyone,
I need help with my PHP project; I need some codes and SQL queries.

First, how can I display all the rows in a Database table on the screen?
I need the SQL query for that please and what will be the function for that in PHP.
Second, what is the SQL query for searching in the Database?
Hope you can provide me with what I need...

All the thanks.

[ucbones]

try looking in the manual (http://www.php.net/manual/)

from the manual...

<?php
    mysql_connect("localhost", "mysql_user", "mysql_password") or
        die("could not connect");
    mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    printf ("ID: %s  Name: %s", $row[0], $row[1]);  
}

mysql_free_result($result);
?>

[SweetAmona]

Thank you ucbones

I'll try it 🙂