[RESOLVED] Nothing Happens??

lisatwin1

I run the following code, and no errors are shown; however, nothing after the $count.... works. I don't get an echo for count (the line echo "count =" . $count) 😕

I have the sample file up at http://register.pedalandplayinparadise.com/step1.php just, say "yes" and the user john doe exists.

Thank you in advance.

<?php
error_reporting(E_ALL);
ini_set('display_errors', True);
// ------------------------CONNECTION INFO
$dbc = mysqli_connect('', '', '', '');
if(!$dbc){echo "unable to connect"; echo $mysqli->connect_error;}

$firstName = $POST['first'];
$lastName = $POST['last'];
echo $firstName . " " . $lastName . "<br>";

$query = "SELECT * FROM 'riders' WHERE firstName=$firstName AND lastName=$lastName";
echo "query: " . $query . "<br>";
$result = mysqli_query($dbc, $query) or die (mysql_error());
if(!$result){echo mysql_error();}
if ($result){echo "Query completed successfully.";}
$count = mysql_num_rows($result) or die(mysql_error());
echo "count =" . $count;

$row = mysql_fetch_array($result)or die(mysql_error());

mysqli_close($dbc);
?>

traq

QUOTE your user input in your query. Also, you're quoting your table name incorrectly.

SELECT * FROM `riders` WHERE `firstName`='$firstName' AND `lastName`='$lastName'

Your script is actually [font=monospace]die()[/font]ing up by [font=monospace]$result =[/font] or maybe at [font=monospace]if(!$result)[/font].

You're not getting any output from [font=monospace]mysql_error()[/font] because you're not using mysql_ functions to execute the query (use [font=monospace]mysqli_error()[/font] instead).

sneakyimp

Also, make sure you don't mix mysql and mysqli functions. Pick one or the other (mysqli_* is better) and stick with it.

lisatwin1

Thanks! I had thought that it was getting 0 results which was the problem, but I didn't realize I had to use mysqli... In place of all mysql... I had looked up the two functions but found nothing conclusively . So that means that would use mysqli for num rows too. That is probably why I was getting errors on that one before. My computer is unplugged right now, but I will give that a try and let you know. Thanks agai!

lisatwin1

just a quick update, other than the mysl & mysqli controversy, the issue was that "cellPh" was spelled "cellPH" dang my fat fingers! So now to post the next issue, lol.

Thanks for everyone's help!