error using where clause

vky84

Hi everyone,

I am tring to learn php by making a website for my own self. I am very new to php and hence i am facing a lot of problems. Mostly i m using code by getting the pregenerated code of phpmyadmin

The following code runs perfect and shows the data by date

<?php
include 'db_config.php';
include 'opendb.php';
$sql = 'SELECT * FROM `table` ORDER BY `table` . `date_added` DESC';
$query = mysql_query($sql, $conn);	
for ($i = 1; $i <= 3; $i++) {
if ($row = mysql_fetch_array($query)) {
echo "<tr>";
echo "<td>".$row['id']."</td>";
echo "<td>".$row['file_path']."</td><br>";
echo "</tr>";
}
}
?>

I made few changes to view all the data where the radio field is Video then i get error. I made the changing in only one line as follows

<?php
include 'db_config.php';
include 'opendb.php';
$sql = 'SELECT `radio` FROM `table` WHERE radio = \ 'Video\' LIMIT 0, 30 ';
$query = mysql_query($sql, $conn);	
for ($i = 1; $i <= 3; $i++) {
if ($row = mysql_fetch_array($query)) {
echo "<tr>";
echo "<td>".$row['id']."</td>";
echo "<td>".$row['file_path']."</td><br>";
echo "</tr>";
}
}
?>

I get this error "Parse error: parse error, unexpected T_STRING in C:\Program Files\EasyPHP 2.0b1\www\dd\read.php on line 4"

I searched for many other tutorials on using where clause, i implemented them but none of them helped me.

Please help me asap, it would be very helpful for me.

Thanks

NogDog

There is a space between the back-slash and the quote you wanted it to escape (just before 'Video').

PS: You could use double-quotes around the entire string, then the escaping would not be necessary.

vky84

Thankyou so much, That error is solved by your help 🙂

But now a couple of new errors are there , i wonder Y ? Now the error is inside the for loop the same error appears 3 times.

Here is error

Notice: Undefined index: id in C:\Program Files\EasyPHP 2.0b1\www\dd\read.php on line 10

Notice: Undefined index: file_path in C:\Program Files\EasyPHP 2.0b1\www\dd\read.php on line 11

Notice: Undefined index: id in C:\Program Files\EasyPHP 2.0b1\www\dd\read.php on line 10

Notice: Undefined index: file_path in C:\Program Files\EasyPHP 2.0b1\www\dd\read.php on line 11

Notice: Undefined index: id in C:\Program Files\EasyPHP 2.0b1\www\dd\read.php on line 10

Notice: Undefined index: file_path in C:\Program Files\EasyPHP 2.0b1\www\dd\read.php on line 11

Please help me , I tried to solve it my self a lot but no luck. Thankyou

NogDog

Your query only selects the column named "radio" from the database table. Therefore, the only array element in $row will be $row['radio']. If "id" and "file_path" are other columns in that table that you want to reference, then you need to add them to the query:

$sql = "SELECT `radio`, `id`, `file_path` FROM `table` WHERE `radio` = 'Video' LIMIT 0, 30";

vky84

Thanks a lot Man...!

You rock, it really worked and it was very helpfull buddy!

Perhaps I have a little misunderstanding in the code above, that i wanted to use all the columns of the table. For now i am mentioning all the names of the columns in the query, is there a way to call all of them without mention name of each column?

Anyway, i am still very thankfull for your help as it solved my problem in a nick of time

NogDog

You can do SELECT * FROM . . . to retrieve all columns, but it is generally a better practice to list the columns explicitly if for no other reason than to make the code easier to maintain; and if you do not actually need every column in the table, then listing just those you need will make the code somewhat more efficient, too.