Calling a specific row in Sql when ever i like

[rmariano02]

How can i call a specific row when ever a like.

 

example :

 

$record = mysql_query("select * from table_name");
($getValue= mysql_fetch_row($record)   //i'm not sure what should i use. should i use mysql_fetch_array, mysql_ fetch_ assoc, mysql_ fetch_ object,  mysql_ field_ name and etc.

print $getValue[$column_name][0];

 

0 = value 1st row in the database/table_name

1 = value 2nd row in the database/table_name

2 = value 3rd row in the database/table_name

......

....

......

.....

etc.

 

is there a code i can do except from using sql_fetch_array then loop and put in into a multidimensional array?

[xyph]

You'd have to use MySQLi

 

<?php

$sql = new MySQLi('localhost','root','pass','db');

$query = 'SELECT * FROM table';
$result = $sql->query($query);
if( $result == FALSE )
echo 'There was a query error';
else
$data = $result->fetch_all(MYSQLI_ASSOC);

print_r($data);

?>

 

Or code the loop yourself

 

<?php

mysql_connect('localhost','root','');
mysql_select_db('db');

$query = 'SELECT * FROM table_a';
$result = mysql_query($query);

if( $result == FALSE )
echo 'Query error';
else {
$data = array();
while( $row = mysql_fetch_assoc($result) ) $data[] = $row;
}

print_r($data);

?>

[rmariano02]

Can i still use the same code in SQL to SQLi?

or

i still need to declare both SQL and SQLi?

[xyph]

Those snippets will work independent of each other.

 

If you use the MySQLi version, I see no reason to keep the rest of your application on the old, unmaintained MySQL functions.

[rmariano02]

Sorry i'm just new in PHP and SQL

 

can i know what do you mean by

Those snippets will work independent of each other.

 

If you use the MySQLi version, I see no reason to keep the rest of your application on the old, unmaintained MySQL functions.

 

sorry i'm not good in understanding English.

do you mean is that i can no logger use the calling of sql in to SQLi?

or i can still use the same code because SQLi can adopt to SQL old codes.

 

i'm realy sorry for your trouble  . 

[xyph]

No, MySQLi knows nothing about the old MySQL resources or functions.

 

I've provided you with a solution that works in both sets of functions.

 

I'd strongly suggest moving your entire script over to MySQLi, as the old MySQL functions are no longer actively developed. That said, your application will still work fine if you stick with the old.

 

If you don't want to change, the second snippet will do what you want.

[rmariano02]

Thank you so much again and sorry for asking too much questions.

[xyph]

Never too many questions. As long as you are ready to learn, we're here to help

 

PHP keeps a lot of old functions that have been replaced or deemed 'bad practise' to avoid breaking existing, old scripts. This can make life VERY confusing for a new PHP developer, especially because a LOT of tutorials are never updated to reflect these changes.