Mysql_fetch_array php

<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Impossible de se connecter : " . mysql_error());
mysql_select_db("mydb");

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

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

mysql_free_result($result);
?>

Source: php.net

Similar codes

2 votes172 views3 answers
Get current date from year input php
PHP
10 votes180 views3 answers
Php random array name
PHP
0 vote189 views1 answer
Check if given date time is of today or yesterday php
PHP
0 vote205 views2 answers
How make custom menu in wordpress
PHP Wordpress
3 votes259 views2 answers
Laravel model exists id
PHP Laravel
0 vote303 views1 answer
Drupal 9 loop term objects to retrieve term data (id, name, uuid)
PHP Drupal
0 vote170 views1 answer
Laravel Exclude URI from csrf token verification
PHP
0 vote249 views1 answer
Php add element to beginning of associative array
PHP
4 votes190 views3 answers
Laravel 8 check if null or empty
PHP
1 vote203 views1 answer
How to pass id through get template part
PHP